… mysqld mysqld [.] rw_lock_x_lock_func(rw_lock_t*, unsigned long, char const*, unsigned long) | — rw_lock_x_lock_func(rw_lock_t*, unsigned long… innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… existing table could wait on a metadata lock instead of failing or returning immediately if … received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George … increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… existing table could wait on a metadata lock instead of failing or returning immediately if … received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George … increase contention on log_sys->mutex in write-intensive workloads. Bug fixed #1163439 (Alexey Kopytov). …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… max_seeks_for_keyblogpercona.commanual max_sort_lengthblogpercona.commanual max_sp_recursion_depthblogpercona.commanual max_tmp_tablesblogpercona.commanual Max_used_connectionsblogpercona.commanual max_user_connectionsblogpercona.commanual max_write_lock_countblogpercona.commanual memlockblogpercona.commanual min_examined_row_limitblogpercona.commanual myisam_block_sizeblogpercona.commanual myisam_data_pointer_sizeblogpercona.commanual myisam_max…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… have “holes” (deleted rows) which can help significantly. delay_key_write Delay updating indexes for MyISAM tables. Good for performance but… with table locks or if LOCK TABLES are used. So in practice this option is used for MyISAM and MEMORY tables. max_write_lock_count Variable which may save you from read starvation if there are constant writes to the table. Works with table locks so…
Comment: What to tune in MySQL Server after installation
October 7, 2009 By 118 Comments
http://blog.taragana.com/index.php/archive/one-mysql-configuration-tip-that-can-dramatically-improve-mysql-performance/ try this max_write_lock_count = 1
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… mutexes, as well as for read-write locks. For these information both for exclusive locks and for shared locks is displayed. OS Wait is… case difference between these values will also grow and innodb_max_purge_lag will become your friend. “undo n:o” will… buffer pool also stores lock information, adaptive hash indexes and some other system structures. Pending reads and writes are pending requests on…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… be also tuning procedure for general heavy writing workloads. At first,
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… scale of write-intentional workloads. See benchmark results. Scalability fix — replaced page_hash mutex to page_hash read-write lock. See benchmark… this. New parameters in the XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active…’t have “head seek latency” (e.g. SSD or enough Write-Buffered), 0 may show better performance. Changed parameter for control…
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
… places where shared read lock is enough – and we replaced page_hash mutex to page_hash read-write lock. The new results you… new results. for reference InnoDB was run with next parameters: –max_connections=3000 \ –table_cache=2048 \ –query_cache_size=0 \ –innodb…
