Recent Posts

extjs.pilotwarezhk

extjs.pilotwarezhk

Return To Blog Listing

a personal learning experience in SEO, PHP, ExtJS, LAMP, etc...

Search This Blog's Tags For:

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...