June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

….mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java.jar Example Schema CREATE TABLE… other examples you can find a more comprehensive example here. Running SchemaSpy The syntax below if specific for MySQL, but note that… of the table sizes and an easy way to use the search feature of your browser to zero in on a particular table Constraints…

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

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

May 31, 2013 By Leave a Comment

…in-depth.  If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE…MySQL, for which we at Percona tend to find redundant indexes. And second, because in…

Filed Under: Insight for DBAs, MySQL, On Ground Training, Percona Toolkit, Training Tagged With: , , , , , , , , ,

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… there is approximately 12GB of data in the largest table. You can find the individual SSB query definitions in my previous blog post. Test…=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb…

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

Post: More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

… transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode…MySQL 5.6. In order to understand more about differences between results we have rerun tests on several our boxes. You can find… –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: Galera Flow Control in Percona XtraDB Cluster for MySQL

May 2, 2013 By 5 Comments

… existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of… possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc… the size of the transactions, which translates into number of unique key lookups into the certification index, which is a hash table…

Filed Under: Insight for DBAs, Percona Live, XtraDB Cluster Tagged With: , , ,

Post: Researching your MySQL table sizes

March 17, 2008 By 28 Comments

… data sizes so here it goes: Find total number of tables, rows, total data in index size for given MySQL Instance SELECT count(*) tables, concat(round(sum(table…; +——–+——————–+——-+——-+——-+————+———+ | tables | table_schema | rows | data | idx | total_size | idxfrac | +——–+——————–+——-+——-+——-+————+———+ | 48 | cacti | 0.01M | 0.00G | 0.00G | 0.00G | 0.72 | | 17 | mysql | 0…

Filed Under: Insight for DBAs Tagged With: , ,

Post: How to find MySQL queries worth optimizing ?

September 11, 2012 By 6 Comments

… it is easy to find slow queries or queries …tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 12F03 use sbtest; SET timestamp=1347397784; select * from sbtest where pad=’abc’; The query in…tables but because the access type to the tables is “const” MySQL does not count it as access to two tables. In…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE…size…

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

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

April 4, 2012 By 4 Comments

…in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA in…size=6M & mrr_buffer_size=6M MariaDB 5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables… did not find much of a performance improvement from using Hash Join in MariaDB 5….

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

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

February 26, 2013 By 1 Comment

…-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the sense … my 5.6 instance is 128MB – smaller than the size of my DIR data. So, with all of that… other I_S tables, I do find that the number of rows in I_S.innodb_ft_index_table is changing, so …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts