…/mysql-connector-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY…does not include constraints identified via metadata files!) Anomalies – Identifies possible relationships between columns/tables based on names, tables without indexes…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…-key-checker, but it does not detect all cases. For example: mysql> alter table test add index… ######################################################################## # Key redundant ends with a prefix of the clustered index # Key definitions: # KEY `redundant` (`col2`,`id`) # PRIMARY KEY (`…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-…obvious. In the following test sysbench does 9 primary key SELECTs followed by a PK UPDATE …–oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…Innodb is a single row (well, the PRIMARY KEY index entry for that row). This means …standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… cluster nodes simultaneously. You can. It does NOT set an lower bound on performance…
Post: Finally. How to verify if all MySQL records were recovered
April 25, 2013 By Leave a Comment
… case the same question arises: How many MySQL records were recovered and how many were lost…an unidirectional list. The list is sorted by primary key and starts with the internal record infinum …does before it tries to find any records in the page: ./constraints_parser -5f pages-actor/FIL_PAGE_INDEX…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…NOT NULL, pad CHAR(60) DEFAULT ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) and … to 60-sec checkpoint interval, as TokuDB does time-based checkpoints. These drops are quite …_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… note there are some MySQL optimizer restrictions in how well it can deal with primary key appended to the index column, especially in such…. Q: Table1 has a primary key. Table2 joins to table1 using Table1′s primary key. Should table2 have an index on the field that is… does not any more performance can degrade 10 or more times. Q: In which cases should auto-increment be used as primary key…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… MyISAM tables in case of MySQL/System crash is painful and great to be avoided. Long primary key – why did not I use… only index I have I do not have any overhead as this would come only if extra indexes are defined. The primary key itself does not get much larger whatever columns you place into it, as primary key BTREE contains…
Post: Using innodb_sys_tables and innodb_sys_indexes
June 15, 2012 By Leave a Comment
… primary key only copy the data to it and when create secondary key by sort. Looking at innodb_sys_tables and innodb_sys_indexes… set (0.00 sec) As you can see both primary key and secondary key exist in the table. Looking around I found post… to set expand_fast_index_creation=1 if you want this feature to work… and indeed it does. mysql> select * from innodb_sys…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… in terms of data and index size: mysql> show table status like “sbtest” \G ***************************…index_creation=1 which builds table with primary key only when creating a table and when builds all indexes…index does not fit to memory any more. Creating Index by sort is great Creating index…
