…== by 0x6B70A62: mem_heap_create_…get_waiters is called from mutex_exit and there we find a comment: /* A problem: we assume that mutex_reset_lock…table_state) (sql_show.cc:6238) ==9090== by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090== by 0x6A7D72: mysql_select(THD*, Item***, TABLE…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… (There’s also an innodb_additional_mem_pool_size but it’s… temporary tables. The following query creates at least 2 temporary tables: select * from ( …mysql> set @a := repeat(‘a’, 1024 * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… assume the team had tried to get the most the given configuration …table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_additional_mem…flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…bits virtual power management: I tested MySQL-5.1.30 with …table_type=MYISAM ft_min_word_len=4 innodb_additional_mem…tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table…-like benchmark (you can get it on https://launchpad.net…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… clear confusions with the problem Im getting w/ our servers: Here is …are using InnoDB tables #innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file_path…_buffer_pool_size = 384M #innodb_additional_mem_pool_size = 20M # Set .._log_file_…_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 …
