… Old variable innodb_adaptive_checkpoint was deleted. Bug fixed: #689450. (Yasufumi Kinoshita) Old variable innodb_flush_log_at_trx_commit_session was deleted. …profiling_server and profiling_use_getrusage were merged into the Slow Query Log page. (Oleg Tsarev) Other Changes Additional information …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…_inc; Compare that to Percona Server with log_slow_verbosity=full: # Time: 111229 3:11:26 # User…InnoDB_IO_r_bytes: 16121856 InnoDB_IO_r_wait: 0.001414 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB…6% 260 0.0002 1.00 0.00 DELETE poller_output # 20 0x428A588445FE580B 0.0449 0.6%…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… renamed to innodb_current_row_locks. (Yasufumi Kinoshita) Old system variable innodb_enable_unsafe_group_commit was deleted. The existing MySQL variable innodb_support…. (Oleg Tsarev) Old system variable use_global_log_slow_control was renamed to slow_query_log_use_global_control. (Oleg Tsarev) Old…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… looks something like this: SELECT * FROM table WHERE deleted = 0 AND group_id IN (62715996, 62716592, 62717660,…build_page_hash_index,btr_search_info_update_slow,btr_search_info_update,btr_cur_search_…things a lot worse in this workload and innodb_adaptive_hash_index_partitions=16 available for …
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
… hoping that eventually MySQL’s InnoDB becomes close to on par with the competition – …for a production database involving inserts, updates and deletes but not so much in 2010. MySQL surprisingly…they’re detrimental. Not only do these indexes slow down insert operations, the MySQL optimizer sometimes …
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
…earlier fast-recovery code. Added the –percona_innodb_doublewrite_path option to place the …). Added the –use_global_log_slow_control option to control slow-query logging globally without restarting,… Recovery process may hang when tablespaces are deleted during the recovery #570840 deb package …
Comment: COUNT(*) vs COUNT(col)
April 11, 2007 By 45 Comments
The statement that “COUNT(*) with InnoDB is slow without a WHERE clause because InnoDB doesn’t cache the row count” only tells part…, covering indexes and NOT NULL are true, and apply to InnoDB as well as MyISAM. But there is more to the… on throughput in the presence of updates (including deletes and inserts). However, with InnoDB, which uses row-level locking, there are multiple…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… deletes were awfully slow.. am testing below mentioned schema now.. Am still in the testing phase and am evaluating InnoDb as alternative because deletes are awfully slow…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…an auto_increment column) in nearly (emphasize nearly) every InnoDB table can have very serious and negative … add processing time to inserts, updates, and deletes but there are other benefits. Also – if… queries, especially > if you see them in slow query log. If you have trouble understanding >…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… options – when to delete binary logs from master. It does not affect Innodb and other storage engines transaction logs, slow query log or… engines which support large pages in general. Currently MyISAM and Innodb. Some SQL level items as Query Cache also could use… work for all storage engines but currently implemented only for Innodb. tmp_table_size This variable specifies maximum size implicit temporary…
