… format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility …=12 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_…innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility…size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_…innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=10M innodb_flush_log_at_trx_commit=1 #skip-innodb…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… be an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA… and analyze them individually. The goal is always to develop X-Ray Vision and see through the symptoms to the underlying…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… Innodb Table id2 is not needed pas part of second key as PRIMARY key is appended to it internally anyway. For MyISAM…,C,ID and Having other indexes on one column, idx1(X) idx2(Y) etc? A: I would wonder whenever it is… index for “order by desc” indicates a double linked list. Innodb has double linked list – each leaf page contains pointers to…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 …, for instance) and eking performance out of an InnoDB table for raw SELECT speed will take a … such, MySQL was a pathetic “option”. Yes 5.x has included triggers, stored procedures, and such, but …
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
….x may be not so good for MySQL. And yesterday one customer reported that just changing cfq to noop solved their InnoDB…=MYISAM innodb_buffer_pool_size=3G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log_at_trx_commit=1 innodb…=128M innodb_thread_concurrency=0 innodb_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb_adaptive…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…, with increment of 1Mb/day) — I have used a table MyISAM, info from phpmyadmin: Collation utf8_general_ci lenght row 122… to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1… this configs? – do i switch table from MyISAM to InnoDB (if yes, how to configure InnoDB for best performance?) – what parameters i need…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… limit of 600 connections when every connection consumes X mb. If the answer to ‘b’ is 2mb…_timeout=3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size=2M query_… innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…_log = 75 # skip-innodb max_connections = 600 #thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M… = 131072 default-storage-engine = InnoDB #thread_concurrency = 32 innodb_buffer_pool_size = 4096M innodb_lock_wait_timeout = 120 innodb_use_sys_malloc = 0 long… to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… storage engine or just default storage engine will switch from MyISAM to Falcon. It was rather interesting to hear a lot… nothing told about Innodb features, even ones such as page compression which were publicly announced before. Somewhere in 6.x series proper… at. There is also not much told about Maria (aka MyISAM++) in product road map presentation, so I guess this is…
