Category Archives for MySql

Be careful of MySQL Query Cache

Configuring MySQL server for high traffic site is very hard. You have to consider many things. One of the pitfall for unweary person like me is query_cache_size. I must confess I thought it would make my mysql server would perform … Continue reading

11. September 2014 by Zakir Hyder
Categories: Linux, MySql, Server Management | Tags: , , | Comments

Implementing MySql View in CakePHP For Typeahead Search

View works like a table, but it is not a table. It never exists; it is only a prepared SQL statement that is run when you reference the view name. A programmer can write VIEWs that limit the dataset both … Continue reading

23. March 2012 by Zakir Hyder
Categories: CakePHP, MySql, PHP, Web Development | Tags: , , , , , , , , | Comments

Tuning / Optimizing my.cnf file for MySQL

MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack—LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python”. MySQL is used in some of … Continue reading

10. September 2011 by Zakir Hyder
Categories: MySql, Server Management | Tags: , , , , , , , , , , , , , | Comments