When you are using MySQL, you will (likely) have tables that can be fragmented. Fragmented tables in mysql needs to be optimized. You could simply OPTIMIZE every table in every database, but during an OPTIMIZE, the tables are locked, so writing is not possible. To minimize the time that MySQL […]
Database
28 posts
The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance: InnoDB is newer while MyISAM is older. InnoDB is more complex while MyISAM issimpler. InnoDB is more strict in data integrity while MyISAM is loose. InnoDB implements row-level lock for inserting and updating […]
Redis is an open source, BSD licensed, advanced key-value store. It is often referred to as a data structure server since keys can contain strings, hashes, lists, sets and sorted sets. This article shows how to install Redis to work with Linux-based PHP development environment. Installation and Configuration Download and […]
This excellent article talks about database performance on very big system at Twitter and Paypal. The article is originated from iTnews.com.au Driving big performance using MySQL Engineers at Twitter, Paypal have joined Facebook in offering a look under the hood of the massive MySQL deployments that drive their web services. Database […]
This article mentions common problems when performing pagination on a big data set and solutions to overcome them. Scenario When querying with a large dataset, we often use SELCT …. ORDER BY a,b,c LIMIT M, N , but do we know how does this query perform? Let’s look at the […]
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!) […]