Take note of this graphic. Notice there’s been 3,775,826 queries processed by that MySQL server in a little more than 5 days. Nothing too impressive right? Right.
We know MySQL can handle many more queries than that in a much shorter period of time. What amazes me is how well MySQL performs on the server it’s running on. The box hosting that MySQL server is an old HP. It’s got 1 Pentium II 400mhz processor with 128Mb of RAM. And it serves data to anywhere between 10 and 14 seperate PC’s at any given point in time. In addition to that, this MySQL server also provides data to a web interface that is used by 50 or so people. The MySQL server pumps out about 500Mb worth of data every day.
MySQL never ceases to amaze me in what it can do on less than optimal hardware.
Well, now what?
Work with Me
I'm available for hire and always taking new clients, big and small. Got a project or an idea you'd like to discuss? Startup plan but no developer to make it happen? Just get in touch, I'd love to see if I can help you out!
Leave some Feedback
Got a question or some updated information releavant to this post? Please, leave a comment! The comments are a great way to get help, I read them all and reply to nearly every comment. Let's talk. 😀
3 thoughts on “MySQL Is Huge”
Try it on a 486/33. Seriously.
I ran a server with over a GB of data that was getting web hits to the tune of a few thousand a day, with probably anywhere from 10-30 SQL queries per web hit, for months, on a 486/33 with 40mb ram.
I think MySQL performance, at least in the version that was available 5 years ago, when I did that, hinges far more on your disk speed and RAM than on CPU.
Absolutely Eric, CPU speed hasn’t had much effect on MySQL servers from my experiences. RAM is where it’s at in MySQL. Optimization is key too. The query cache, key buffer, and table cache can all greatly improve performance if setup properly for the server.
MySQL is definitely slow when it has to check the disk for what it needs, instead of just grabbing it out of RAM. RAM is truly key, unless you have super speedy disks.
I agree with you, Tyler. I was using Pentium II MMX 32MB RAM. After upgrading to 64MB, the error message “Connection Time Out” do not display again.