A few days ago, one of our clients presented an interesting problem. They had several editions of an application with each edition being served for a specific client through his own subdomain. There exists a client(subdomain)-edition(document root) mapping in the database. They need to be able to map each client...
InnoDB Buffer Pool InnoDB buffer pool is one of the most important options for improving InnoDB performance. InnoDB buffer pool is a space reserved in memory which is used to save data and indexes that are frequently accessed. When MySQL server receives a query, if the...
Before Mysql 5.6 indexes had some limitations like the range comparisons, if the part of the index used in a range comparison the part of the index after the range scans cannot be used by where conditions so mysql retrieves all rows which met only...
