[MySQL]: optimizer Index strategy
If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on…
[MySQL]: Innodb plugin 1.0.4 fine tune for performance
SERVER SETTINGS (my.cnf) ======================================================= #The MySQL server always must be started with the option ignore_builtin_innodb, as long as you want to use the InnoDB Plugin as a shared library. ignore_builtin_innodb #load the InnoDB Plugin and all Information Schema tables…
![[MySQL]: Cluster Architecture](http://dbversity.com/wp-content/uploads/2014/11/mysql_cluster_acchitecture-150x150.png)
[MySQL]: Cluster Architecture
Introduction: MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, combining 99.999% availability with the low TCO of open source. Designed around a distributed, multi-master architecture with no single point of failure, MySQL Cluster scales horizontally on commodity hardware to…
[MySQL]: When does InnoDB compress and decompress pages?
I found below is an interesting discussion and wanted to share with you. There are two sections for rows in the page format for InnoDB compressed tables. The compressed section has one or more rows and must be decompressed to…
[MySQL]: Running Multiple MySQL Instances on One Machine
Running Multiple MySQL Instances on One Machine In some cases, you might want to run multiple instances of MySQL on a single machine. You might want to test a new MySQL release while leaving an existing production setup undisturbed….
[MySQL]: Backup & Recovery
Backup and Recovery It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data…
[MySQL]: Server Logs
10.1 The Error Log The error log contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running. If mysqld notices a table that needs to be automatically checked or…
[MySQL]: Server Administration
9.1 Server System Variables [client] [mysqld] [mysqldump] [myisamchk] [mysqlhotcopy] auto_increment_increment Controls the interval between successive column values. auto_increment_offset determines the starting point for the AUTO_INCREMENT column value. Autocommit log-error skip-networking init_connect A string to be executed by…
[MySQL]: Administrative and Utility Programs
8.1 myisamchk ― MyISAM Table-Maintenance Utility The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables. You can also use the CHECK TABLE and REPAIR TABLE statements to check…
[MySQL]: Client Programs
7.1 mysql ― The MySQL Command-Line Tool mysql is a simple SQL shell (with GNU readline capabilities). It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as…