Over the last 2 weeks I’ve had problems on three sites with the exact same problem.

The watchdog table grew FASTER than the cron job (which should delete old log entries older than e.g. 3 days) would have deleted it.

This again ended in a “device full” last night when one watchdog table became 5 gigs.

(and I had a “table full” problem on another site last week – tough 64bit MYSQL should be able to do 4TB spaces, that one was 4GB only)

Now, it’s obvious that disk full problems shouldn’t be a problem for a content management system like Drupal to take care about,

Experiences and tips and tricks for using wordpress as a content aggregator – 100,000 posts are not the average weblog volume

5 easy steps to tune your mysql statements

MyTop mysql Top Processes viewer

MD5 cracking service

A little cleanup – after testing out MySql's ACID compliant storage engine InnoDb some months ago I had a 3 Gigabytes large IBDATA1 cluttering my server's 10k SCSI disks… compared to the 300GB desktop drives this is just 1%, but…

MySQL bulk insert delayed

While testing WordPress for a news aggregation project I noticed that the slow-query log of MYSQL grew and grew… well… no wonder… brrr… temporay segments, and filesorts go to disk…

Alan points out that an unsalted MD5 hash can be cracked within seconds when he tries Cracking MySQL's MD5 function really works that fast… Interesting to find out that there seems to be a web service some where (I haven't…

After weeks of investigation by the admin support staff we only came to the single conclusion … the mysql backup of the WHM/Cpanel backup feature simply corrupts the backup after some megabytes or a few million records… not designed for…

It seems as if I am the one and only person using cpanel/whm for the web hosting solution and at the same time have a MySQL database with 5+mio records. During the backup process cpanel simply truncates the results at…

MYSQL Sync Agent

Q: Why are you using MYSQL? A: Because it was there (ed: on the webspace) and free I guess that's how many zillions of people started using MYSQL – including me. ordering a 40$/yr space already includes mySql and…