June 18, 2013

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…-table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables were… UTC regardless of the server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM…

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… a practical application of running a MySQL database on a tablet, but it was more to check capabilities of mobile gadgets, which…

Comment: Innodb Performance Optimization Basics

… point this out given the recent posting on the about checking MySQL Config files. Keep up the fantastic work. Kirby

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… of it doesn’t seem to work. First, let’s check the stats immediately after setting these variables, and then let…

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

… 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….000000 | 0.000000 | 0 | 0 | 0 | 0 | 1 | 1 | | 4 | checking permissions | 0.000015 | 0.000014 | 0.000000 | 0.000000 | 0…

Post: How Percona does a MySQL Performance Audit

checked out Apache and network config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL… port, etc etc. Nothing unusual. Next I check what the MySQL version is, and I check (with the ‘file’ command) whether /usr/libexec… of other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to…

Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script

… Since we know the “instance_id” of the new instance, checking if it is running is easy: done=”false” while [ $done…/ha.d/ha.cf and ask heartbeat to reload its config MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE…/ha.d/ha.cf and ask heartbeat to reload its config MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE…

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

… test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is…. Back to our test, we check that the data is the same on both nodes: percona1 mysql> select * from percona; +—-+—————+——–+ | id | inserted… trimethylxanthine 2012-07-24 11:42:50.237 INFO: Read config: daemon: 0 address: gcomm://192.168.70.2:4567 group…

Post: Backing up binary log files with mysqlbinlog

… got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http… below will connect to the remote server specified in the config and ensure mysqlbinlog utility is up and running. By default… addition, older logfiles that have been rotated can be checked against the MySQL server’s version if they are the same or…

Post: Shard-Query EC2 images available

… avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G…-05-10 04:26:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL… to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of …