Sometimes, you want to backup individual databases in MySQL to move to a different server. This part is easy using mysqldump: shell mysqldump -u root -p --databases db1 db2 ... backup.sql The problem is, what happens when you want to backup the permissions associated with these databases? Well, here...

MySQL is a fantastic open source database used by the many thousands of web applications. The default MyISAM table system is one of the simplest and fastest around, but it does not support foreign keys (although it is planned for version 6). Fortunately, the lesser-used InnoDB table type does suppor...

I had a good time at the conf and my talk seemed to go over pretty well. I somehow ended up in the largest session room (I admit to feeling a bit overwhelmed). Attendance seemed to be at a decent level, though I think I may have overwhelmed some of them a bit with the information. Had lots of questi...

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? To give an idea as to the size of the project the current system has 35 tables, and on th...

Hanno fragt mich: Hi Kris, wir suchen mal wieder einen Linux-Admin. Diesmal eine Teilzeit-Kraft, die halbtags arbeiten will: http://www.epublica.de/jobs.html Aufgrund des Profils wäre auch bzw. gerade eine junge Mutter geeignet, die in den Job zurückkehren will. Kennst Du da wen? Wir suchen schon ...

Most MySQL developers have a copy of their databases running on a local PC. Although the MySQL command line may be fun for a while, it is no substitute for a decent database design application such as Workbench or SQLyog. Connecting to a local database on localhost’s port 3306 is easy. However...

This might be a bit cutting edge, but the new fallocate() call in > Linux 2.6.23 might be able to improve InnoDB performance. When InnoDB needs more space it auto-extends the current data file by 8MB. If this is writing out zeros to the new data (to initialize it) then using fallocate() would cer...

[Drizzle] won’t be a get-out-of-jail-free card for very write-heavy applications but I bet it will do wonders for heavily replicated, heavily federated, read-heavy architectures (you know, normal stuff). - Richard Crowley...

Just a quick reminder that I will be at the Florida Linux Show this Monday representing PHPWomen and giving a talk on MySQL performance tuning. My talk starts at 09:30 and afterwards I will be at either the PHPWomen’s booth or the Sun Microsystems booth or the Jax PHP User group booth. Feel fr...

Have you ever looked for the perfect thing, and find that no one in Europe carry it, and no one will ship it to you. I have! I have been considering a low power, very green, server platform to use as a MySQL / Sybase / HTTP server system. My perfect system would have been this, Compaq Presario CQ200...