June 18, 2013

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

January 9, 2013 By Leave a Comment

… 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…

Filed Under: MySQL, Percona Software, Percona Toolkit Tagged With: , , , ,

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

February 28, 2013 By 11 Comments

… 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…

Filed Under: MySQL, Percona Software Tagged With: , , , , , ,

Comment: Innodb Performance Optimization Basics

March 4, 2008 By 75 Comments

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

Filed Under: Insight for DBAs Tagged With:

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

February 26, 2013 By 1 Comment

….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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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

March 11, 2013 By 7 Comments

… 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…

Filed Under: MySQL Tagged With: , , , , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… 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…

Filed Under: Insight for Developers Tagged With:

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

August 19, 2010 By 6 Comments

… 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…

Filed Under: Insight for DBAs, MySQL Tagged With:

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

July 25, 2012 By 6 Comments

… 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…

Filed Under: MySQL, XtraDB Cluster

Post: Backing up binary log files with mysqlbinlog

January 18, 2012 By 2 Comments

… 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…

Filed Under: Insight for DBAs, MySQL

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… 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 …

Filed Under: MySQL
« Older Posts
Newer Posts »