MySQL will allow n number of connections at a given point of time, To find out that n no of connections run the following command.
mysql> show variables like 'max_connections'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | max_connections | 100 | +-----------------+-------+ 1 row in set (0.00 sec)
So this server will allow max of 100 connections at any given point of time.
Tomorrow morning at 7:30 AM I will be leaving from Monterey for
San Francisco where we (me and Michelle) will be catching a
flight to Atlanta at noon. We will arrive in Atlanta around 8:00
PM EST. I believe we will have the shortest day ever due to the
time difference.
I am really thankful to MySQL and especially Arjen and Jay for
inviting me to speak at the MySQL Users Conference. I enjoyed it
a lot and will miss everyone I met until we meet again. Thank you
everyone for such a great time.
Frank
MySQLUC
or, why I find the Solaris manual pages amusing.
In this thread on the php internals list, Kevin is asking why the handling of whitespace in certain PDO DSNs is inconsistent. I go on to point out that the manual doesn't say anything about whitespace in DSNs, and that all the documented examples have no whitespace around the DSN parameters.
His response was:
but in this example we have a space and it works mysql: host = localhost; dbname=test
And another that I got via private email:
Thursday’s Keynote speaker at the MySQL Conference was Mark Shuttleworth talking on The Ubuntu Project: Improving Collaboration in the Free Software World.
Ubuntu from Canonical Ltd is fastly becoming one of the most popular Linux Distributions, based on Debian. Here were some notes from his presentation. Mark had some really powerful one or two line slides that typified both his presentation intention and the goal of Ubuntu.
Delivering on the Promise of Free Software
It's hard to believe that MySQL Users Conference is over. Though
each day seemed like very long, it went pretty fast.
My Applied Ruby on Rails and AJAX session was the last session at
the MySQL Users Conference and was happening at the same time as
Jim Starkey's Falcon storage engine. I was kinda worried
about the attendance at first, but when my session started, I saw
people standing in the back (full room). A lot of questions were
asked at the end. Thanks to everyone who attended.
Harrison Fisk, my session buddy, presented me with a speaker's
gift from MySQL, which was a very nice MySQL pen (Thanks).
At the end of the session I was told that there were about 114
people attending my session, roughly the same amount of folks
that attended Jim's session, Wow!.
As I was walking out of the …
Well, the conference is now over! I had a great time, and met a lot of awesome people. It was awesome, I truly enjoyed meeting many of you, and will definitely see you next year.
I’ve uploaded my photos and presentations for your enjoyment:
[Read more]By tim
Eric Scheide of craigslist offered me a stream of consciousness summary of the craigslist database setup. At a conference last year, Craig showed a slide (which helped inspire my postings about asymmetric competition [1, 2, 3]) that listed the number of employees at the top ten web sites. Most of them have thousands of employees. Some have tens of thousands. Craigslist, at #7 on the list, has 19.
Eric's email has that embattled "news from the front" feel that you might expect from a site handling that much traffic with only 19 employees!
First, in response to my question about the craigslist database architecture, Eric wrote: …
[Read more]I'm on the phone with a WebEx technical support person. Not sure why tech support is necessary for taking my money (I'm just trying to set up a WebEx account for Alfresco - signed up online, gave my credit card number, and have received nothing in return), but whatever.
The thing that frustrates me to no end is that I went from talking with a local, US salesperson to a remote, India-based support person who gave me infinitely less support. He didn't understand the urgency of my requirements, though he tried hard to care. I eventually hung up in desperation and called back to the US sales team, telling them they were not allowed to transfer me outside their building. Result? Successful account setup.
Which got me thinking. I'm not a big fan of outsourcing in any situation - as I feel that support and development is best done as close to the problem one is trying to solve as possible - but in the open source world it seems insane. …
[Read more]What a blast! It was great to see most of my old colleagues from MySQL when I worked there as a Professional Consultant. Lots of cool sessions and great turnout. By far, the best session was Jim Starkey's intro to Falcon. Even Heikki was there listening intently! I am looking forward to all of the great things MySQL has in store in upcoming versions.
I have mentioned a couple of times about the upcoming release of
MySQL Stored Procedure Programming by Guy Harrison and Steven
Feuerstein. It was scheduled for release in March but the release
date slipped a couple of times, I pre-ordered and the good news
is that the book arrived this morning, so it's out now (in the UK
at least).
It weighs in at 636 pages so while it's not the door stopper
that's often related to computer books there is a lot of
information in there especially given the relatively recent
addition of stored procedures to MySQL. Jay Pipes and Michael
Kruckenberg did a great job with their stored procedure chapters
in Pro MySQL but given that it wasn't an exclusive development
book it didn't go into detail about using stored procedures from
other languages, this new book goes into great detail on the
subject with dedicated chapters on using stored procedures with
PHP, Perl, Python, Java and .Net.
Having …