If you run a fairly busy and/or badly configured MySQL server, you may receive something like this when attempting to connect:
# mysql
ERROR 1040: Too many connections
MySQL is telling you that it is handling the maximum connections that you have configured it to handle. By default, MySQL will handle 100 connections simultaneously. This is [...]
Thanks to some hard work from Oden Eriksson and Frederik Himpe, MySQLTuner 0.9.1 is available in a Mandriva package.
MySQLTuner v0.9.1 is now available! This long-awaited update includes bug fixes, feature enhancements, and compatibility improvements.
MySQLTuner now checks for fragmented tables
When deletes or updates are made on tables, MySQL will often leave holes behind that it hopes to fill in later. If the size and quantity keep climbing, the holes can cause performance [...]
I found myself in a peculiar situation last week. I’d been asked to downgrade a server from MySQL 4.1 to MySQL 3.23. Believe me, I tried to advise against the request, but I didn’t succeed.
I made a MySQL 3.23 compatible dump with –compatible=mysql323, but the dump came out with backticks around the database [...]
I’ve received some great feedback on my first screencast. The suggestions have been helpful, and the compliments have made me want to create more free screencasts.
At this point, I’m opening it up to you - what would you like to learn? Of course, I’m still planning to make a full set of screencasts [...]
