…using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to create this once…possible relationships between columns/tables based on names, tables without indexes, columns flagged ‘nullable’ and ‘must be unique’ (woops!), single …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… mysql> ALTER TABLE test ADD INDEX (col2); Query OK, 0 rows affected (0.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW CREATE… set (0.00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in the same order) and… -and the index will be created-, but we will get a warning (note severity, to be exact): mysql> ALTER TABLE test ADD INDEX (col2…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still… matching rows in `title` by a secondary index. But the result was that it created a temporary table to count the movies… in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and… caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting …. Bug fixed #1162085. Percona Server would re-create the test database when using rpm on server…. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…deals with an empty transaction list when creating read views. However, the more general…–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… explicitly named foreign key constraint which implied an implicit secondary index with the same name. Fixed by detecting such cases and… caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… NULL, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and tables sbtest$I_r10…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel …Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line …information wasn’t available. Fixed by not creating xtrabackup_binlog_info file when binlog …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… unique index InnoDB will create one implicitely. Its name will be GEN_CLUST_INDEX. It doesn’t matter how the primary index gets created it will have minimal `ID` among the indexes of the table. mysql> select * from SYS_INDEXES WHERE TABLE_ID…
