This article mentions show popular configuration notes in popular softwares on PHP-based server: Apache, Nginx, PHP, and MySQL. 1. MySQL Should use MySQLTunner tool to analyze query_cache_size parameter is used to allocate an amount of memory to cache the frequently executed queries and return the result set back to the client. E.g.: 128M […]
mysql
14 posts
This post explains how to add a new slave to the existing MySQL replication. New slave server can be added to the MySQL replication without stopping master or shutting down existing slave server. You will have to temporarily stop replication on the slave server in order to take the current […]
This tutorial describes how to setup MySQL replication. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that […]
This article discusses about some MySQL performance tips which are collected over Internet and based on the experience of the author (me ^__^). Specific Query Performance Tips (see also database design tips for tips on indexes): Use EXPLAIN to profile the query execution plan Use Slow Query Log (always have it on!) […]