…buffer_size you would find descriptions such as “The read_rnd_buffer_size…LIMIT 10 it is unlikely to help as MySQL will stop fetching rows by pointers quickly For me this means since MySQL…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections”. This was never true …); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) … some things that have no defined limits. It’s not something that’s …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
…mysql> set global key_buffer_size=8000000; Query OK, 0 rows affected (0.03 sec) mysql> set global max_heap_table_size…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
…Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let… Pushdown Traditional B-Tree index lookups have some limitations in cases such as range scans, where index…records. For example, suppose you have a key defined as: KEY `i_l_partkey` (`l_partkey`,`l_quantity…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… optimizer_switch=’batched_key_access=on’ join_buffer_size=6M read_rnd_buffer_size=6M Also … order by revenue desc, o_orderdate LIMIT 10; In-memory workload Now …MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer_size=6M & mrr_buffer_size…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…key-buffer-size=1500M –innodb-buffer-pool-size=1500M –innodb-log-file-size…KEY_POINT_LIMIT Query: SELECT name FROM $tableName WHERE country_id = %d LIMIT 5 The same query as previous but with LIMIT…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort_buffer_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_size…
