…so I find it convenient to set it up on crontab so… sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0…` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE … of the actual SQL NULL value. This is basically a quick…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… is not expected: instead of removing all settings, some of them are reset to default values. This means that if you run START….02 sec) mysql> reset slave; Query OK, 0 rows affected (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start… what you want. So never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…default value…mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… sets of polls: “What is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL… in MySQL, the defines can still found in the source. Basically, it’s why we can’t have nice things (like default values… maximum number of columns you can create. If you try setting the storage engine to InnoDB however, you will get an…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…. Default database: ‘test’. Query: ‘insert into t VALUES(NULL,’salazar’)’ Retrieved_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-5 Executed_Gtid_Set: 7d72f9b4… is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-only workloads, especially when the default glibc memory allocator is used. Bug … overhead from innodb_pass_corrupt_table value checks by optimizing them for … when plugin-dir option was set in the [client] section of …). Percona Server for MySQL was missing help texts in the MySQL client because …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…_groups (user_id, group_id) VALUES (100, 1); UPDATE groups SET last_joined=NOW(), last_…number of times specified by this variable (default is 1 retry). This means more waiting…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…-only workloads, especially when the default glibc memory allocator is used. Bug … overhead from innodb_pass_corrupt_table value checks by optimizing them for … when plugin-dir option was set in the [client] section of …). Percona Server for MySQL was missing help texts in the MySQL client because …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… NOT NULL, k INTEGER UNSIGNED DEFAULT ’0′ NOT NULL, c CHAR(120) DEFAULT ” NOT NULL, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY… pareto distribution BEGIN INSERT INTO sbtest (hid, mid, id, k) VALUES ($HID, $MID, $ID, $K); INSERT INTO sbtest_r10 (hid, mid…/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand from documentation TokuDB comes with good settings…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… NULL or NOT NULL can shift all values by a byte and thus will spoil the… ENGINE=InnoDB DEFAULT CHARSET=latin1 Fields names explain their content. Index id in our example is 1679: mysql> SELECT …UNSIGNED NOT NULL, `first_name` VARCHAR(45) CHARACTER SET ‘utf8′ COLLATE ‘utf8_general_ci’ NOT NULL, `last…
