Hoping to squeeze a few more cycles out of my VPS, I recently implementing PHP and MySQL caching. So far, I haven’t noticed much in the way of performance increases, but the Apache Bench test results show there is some improvement.
For PHP I used xcache and followed the guide I found here.
For MySQL I followed this guide. I only need to set the value of query_cache_size to enable it. Running mysql> SHOW STATUS LIKE ‘Qc%’; shows that it’s being used.
Ran into this today. I mysqldumped a database, and tried to import it again. The import failed with a SQL error. I was pretty annoyed that MySQLs own tools were generating invalid SQL until I dug into a little more. Turns out, one of my fields was named “usage”, which is a MySQL reserved keyword. So, I used the following mysqldump syntax to get a proper export.
mysqldump –password -c –allow-keywords databasename > output.sql
Page optimized by WP Minify WordPress Plugin