(Falko Timme) AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs.
Tag: Open Source
Creating a cross tab in MySQL
(Arnold Daniels) Data stored in a database is often also useful for statistical purposes. If you own a web-shop you want to be able to create a report about turnover. You can get statistical information by using GROUP BY, eg.
How expensive is a WHERE clause in MySQL?
(Baron Schwartz) This is a fun question I’ve been wanting to test for some time. How much overhead does a trivial WHERE clause add to a MySQL query? To find out, I set my InnoDB buffer pool to 256MB and created a table that’s large enough to test, but small enough to fit wholly in memory:
Partitions usability I – blues and a preview
(Giuseppe Maxia) Pop quiz. Look at the picture below. Quick: can you tell me to which year and month partition P001 refers?
Optimizing Queries on Cluster
(Johan Andersson) On the cluster mailing list (cluster@lists.mysql.com , thread “slow selects”) there was recently a very good example of how to optimize queries on Cluster. Thanks to Nick Keefen for raising this problem and Jeff Sturm for the answer how to solve it!
INNODB Shared Locks, Exclusive Locks and INSERT INTO SELECT FROM
(Dathan) I wrote an application that is able to send out 3-8 million messages an hour with only 10 CPU’s. This application is a part of an Offline Task system that scales linearly.
Handling MySQL Data Set Failures in PHP 5
(Alejandro Gervasio) If youre a PHP developer who wants to learn the basics of implementing customized exceptions in PHP 5, then look no further, because youve come to the right place. This is the third part of a four-part series entitled Subclassing exceptions in PHP 5. It teaches you how to extend
Virtualizing MySQL
(Sheeri Cabral) I had so much to say in response to a recent post asking about virtualization from Jennifer Glore that I realized it was long enough to be a blog post.
ORDER BY (the lesser known way)
(Ronald Bradford) We all know with MySQL you can use ORDER BY with a list of columns to return an ordered set, e.g. ORDER BY name, type, state; I often use the syntax ORDER BY 1,2; which Im surprised that some people do not know about.
What is an ‘unauthenticated user’?
(Sheeri Cabral) Every so often we have a client worrying about unauthenticated users. For example, as part of the output of SHOW PROCESSLIST they will see: