June 20, 2013

Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… \ attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid… defines the mysql resource on each node and has many parameters, here’s the ones I had to define: config: The path of the my.cnf file. Remember that Pacemaker will start MySQL, not the regular init…

Post: Fixing MySQL with a comment in the config file

… the first one. The multiple instances were started through the mysql_multi init script. Perhaps you already know what was wrong…” in the /etc/my.cnf file. Not a [mysqld_multi] config file section, but the text string “mysqld_multi”. It was… on; I just checked a recent download, and the official MySQL distribution contains a file called mysqld_multi (note the different…

Post: Debugging MySQL SSL problems

MySQL version.  I had already added the relevant config options in the ‘mysqld’ section of the my.cnf: [mysqld] ssl-key=/etc/mysql/ssl/server-key.pem ssl-cert=/etc/mysql… got what I had been looking for: # mysql –ssl-ca=/data/mysql/etc/mysql/DigiCertCA.pem … mysql> … ————–Connection id: 101 Current database: Current user…

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

…. Also note that the following changes were made in the MySQL config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M…, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area…

Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet

… that to build binaries: cmake . -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF make -j2… as expect we will have binaries in /usr/local/mysql, which we start mysql> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | +————————-+——————————+ | version…

Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

… pt-online-schema-change pt-archive pt-mysql-summary pt-heartbeat pt-variable-advisor pt-config-diff pt-deadlock-logger The bug…-query-digest now handles this correctly. Fixed bug 1015590: pt-mysql-summary doesn’t handle renamed variables in Percona Server 5…: pt-heartbeat handles timezones inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:55 FTS_0000000000000114_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:54….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 19:07 FTS_0000000000000025_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 18:57…

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far… tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except innodb_old_blocks_time=0 Config 3: MySQL

Post: Get Me Some Query Logs!

… they started with. $ full-slow-log [ -v ] [ -s seconds ] [ -c config ] -v is for verbose output. -s seconds allows you to… if you forget to give another value. -c config allows you to specify a MySQL config file other than $HOME/.my.cnf, so… log Sleeping 5 seconds… done. Restoring slow_query_log_file=mysql-slow.log Restoring long_query_time=60.000000 Restoring slow…

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

…. Also note that the following changes were made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr… that the following changes were made on MariaDB 5.5 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…