Recent Posts Tagged With 'MySQL'

• More on optimization

  Posted on Wednesday August 20th, 2008 at 00:53 in MySQL, optimization, my.cnf

  There’re many articles around the internet related to MySQL optimization, fine tunning my.cnf to achieve a better performance. After reading hundreds of articles, I found that, none of these are really useful if you have a poor designed data...

• Backing up MySQL with mysqlhotcopy

  Posted on Thursday June 19th, 2008 at 03:48 in MySQL, backup, mysqldump, mysql server, mysqlhotcopy

  To backup MySQL database, the first tool most people will use probably is mysqldump, although it’s good to store the backup since it’s in plain text format, but it’s really slow. No doubt the simpliest way to backup a database is ju...

• check and optimize MySQL database automatically

  Posted on Wednesday June 11th, 2008 at 05:09 in MySQL, Maintenance, optimization, mysqlcheck

  MySQL is a very popular, free, yet powerful database system. But just like all other database systems, the tables will get fragmented with overhead due to continous update, delete, or insert operations. Also, the databases may get corrupted due to in...