Tag 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

Get Apache, MySQL, PHP With mcrypt and phpMyAdmin working on OSX 10.9 Mavericks

One of the best thing about OSX 10.9 Mavericks for web developer is Apache and PHP already installed. You do not have to start the Apache – its automatically starts when mac starts. Apache Even though you want to start … Continue reading

17. January 2014 by Zakir Hyder
Categories: Apple, Server Management, Web Development | 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

ISPConfig 3 setup on Ubuntu

There are number of Hosting Control Panel Softwares. The cPanel is best but it cost 10$ per month. Plesk also need licensing cost. Webmin is free but it interface is not user friendly. THe ISPConfig – Hosting Control Panel Software … Continue reading

10. February 2012 by Zakir Hyder
Categories: Linux, Server Management, Ubuntu | Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Comments

Setup LAMP With Ubuntu In 10 Minutes

I love Debian/Ubuntu based Linux because of this command apt-get. As a starter knowing this one command, It is so easy to install packages and you dont need to worry about package dependency and configuration. I first come use Ubuntu … Continue reading

18. October 2011 by Zakir Hyder
Categories: Linux, Server Management | 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