… and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA. It’s advised…-info being ignored in such a case. Bug fixed #1180662. Low values for wait_timeout on the server could cause server… connections if the global wait_timeout value is set too low. Bug fixed #1180922. Other bug fixes: bug fixed #1177182. Release…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…-30.2 — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server… by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… at Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server… by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… enough. Lock priorities. By default MySQL treats updates as higher priority operations. You can use SELECT HIGH_PRIORITY or UPDATE LOW_PRIORITY to adjust that or you can simply set low_priority_updates option…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…_tc_sizeblogpercona.commanual log_warningsblogpercona.commanual long_query_timeblogpercona.commanual low_priority_updatesblogpercona.commanual lower_case_file_systemblogpercona.commanual lower_case_table….commanual sql_log_offblogpercona.commanual sql_log_updateblogpercona.commanual sql_low_priority_updatesblogpercona.commanual sql_max_join_sizeblogpercona.commanual sql_modeblogpercona.commanual…
Comment: Linux IO Schedulers and MySQL
January 31, 2007 By 7 Comments
… is tough to use with database as there can be priority inversion due to lock held by the thread etc. What… great to see implemented is per request priorities so log flushes for example would get high priority while background dirty pages flush low priority.
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…`) Not copying rows because this is a dry run. INSERT LOW_PRIORITY IGNORE INTO `test`.`_t_new` (`id`, `guest_language`, `guest_country…: Not copying rows because this is a dry run. INSERT LOW_PRIORITY IGNORE INTO `test`.`_t_new` (`id`, `guest_language`, `guest_country…
Post: SELECT LOCK IN SHARE MODE and FOR UPDATE
August 6, 2006 By 51 Comments
… on Innodb table but no updates. Supporting MySQL hints “HIGH_PRIORITY” and “LOW_PRIORITY” would probably be good start.
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… Cache also could use this feature. low_priority_updates If enabled selects will get higher priority than updates and waiting update will not…
Post: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
…: Field ‘v’ doesn’t have a default value Query: INSERT LOW_PRIORITY IGNORE INTO `sbtest`.`_sbtest_new` (`id`, `k`, `c`, `pad`) SELECT…
