… InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id… = ‘f’ and cai.trash = ‘f’ and (cai.status is NULL) group by ld.label_id, cai.inventory_id All 4 tables in…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… market size of nearly US$1 billion within the next few years despite the buzz created by NoSQL alternatives Despite the buzz, MySQL… of our multiple service vendors including Ireland Presentations, Carleson Production Group, Tricord, the Hyatt Santa Clara, and the Santa Clara Convention…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… Cluster (PXC) for MySQL. I actually had more material than I covered (by design), but one …This prevents any node in the synchronous replication group from getting too far behind the others …actually the cost of certification depends only the size of the transactions, which translates into number …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… first post on MySQL transaction descriptors optimization introduced in Percona Server 5.5.30-30.2 and a followup by Dimitri Kravchuk… read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read-only transactions…_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…card as storage. By default linkbench dataset has 10M ids(after load of data size of datadir ~10GB)….Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate…_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…increasing ID $K=rand(0,10000) // distributed by pareto distribution $C, $PAD = random_string…_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…conducted for this post were sponsored by Virident. First, some background information. …=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –…size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…%’ group by t.table_schema, t.table_name, i.index_name; Now I can query this view to see my indexes: mysql> select… like ‘sakila%’ group by t.table_schema, t.table_name, i.index_name; Now we can can see index sizing information in the… old size. If you use innodb_file_per_table, then you can rebuild the tablespace for your table by simply doing: mysql> alter…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… which are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains zero…_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 12F24 SET timestamp=1347399108; select count(*) from sbtest group by k; This only sends… are actually needed to produce group by results. What you can think about in this case is removing group by and aggregate functions. Then…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… only those portions of them which are accessed frequently. The size of this “working set” can greatly depend on application and…: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table or filesort for group by by this column. This works because by…
