…in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.22 sec) Records: 0 Duplicates: 0…in MySQL 5.6, the second ALTER will also succeed -and the index will be created-, but we will get a…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…Creating a mysql.properties file While not explicitly required, I prefer to create this once so that the command line is shorter and neater. In…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…in MySQL 5.6. They open up a…1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1…is done manually for each table (currently a blueprint in innobackupex). He also included …test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…a table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES…5. Now everything is ready to generate a CREATE TABLE statement for a table: ./sys_parser -u root sakila/actor CREATE TABLE…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…-1)-3*2=1017 which is exactly the same as what I can create. That’s right folks, in MySQL 5.6 you can create a table with a few more columns in InnoDB! This led me…(‘”.cname(0,64).”‘) COMMENT ‘”.cname($_,254).”‘,\n”; } chop $sql; chop $sql; $sql.=”);”; print $sql; So the maximum number of columns for a table in MySQL…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in…about 100 update transactions to create a read view: I hope …0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup. After being deprecated in… slave in replication) and binlog information wasn’t available. Fixed by not creating … to a typo. Bug fixed #1172016. Percona XtraBackup would assume the table …
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… XtraBackup 2.1.0-rc1 on May …create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…a particular workload I’m interested in…Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT ‘0‘, `mid` int(10) unsigned NOT NULL DEFAULT ‘0…5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…
