… will show the results of executing benchmarks for different queries and explain the results so that you …of the buffer ‘join_buffer_space_limit’. This variable controls the maximum allowed size of the buffer for … WHERE clause on an indexed column The SQL used for this test together with its …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… the fields of buf_pool->stat are unprotected. These are buffer pool statistics counters: number of read, written, evicted, etc. pages…: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:6238) ==9090== by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090…*, st_lex*, select_result*, unsigned long) (sql_select.cc:269) ==9090== by 0x63A3E3: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5179…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… the ./run_query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results & [1] 12359 $ tail -f ./raw — Q1 … At the end, you will get a result output that… port=3306 read-buffer-size=512K read-rnd-buffer-size=1M skip-host-cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…18.083490 | | restoring secondary keys | 17.824109 | | rename result table | 0.162041 | | end | 0.000008 | | Waiting… the data does not fit in the buffer pool, fast index creation provides even …innodb-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real 2m52.785s …
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…=0x33ae900, result=0x7f3e840058d0, setup_tables_done_option=1073741824) at /percona-server/5.5/Percona-Server-5.5.25a-rel27.1/sql/sql_select…-5.5.25a-rel27.1/sql/sql_parse.cc:3138 3138 res= handle_select(thd, lex, sel_result, OPTION_SETUP_TABLES_DONE); (gdb…::STMT_CONVENTIONAL_EXECUTION}, id = 0, query_strip_comments = {buffer = 0×0, length = 0, buffer_length = 0}, mark_used_columns = MARK_COLUMNS_READ, name…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…sql/sql_cache.cc patching file sql/sql_class.cc patching file sql/sql_class.h patching file sql/sql_parse.cc patching file sql/sql_select.cc patching file sql/sql…-fexceptions -fstack-protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘…temporary storage for intermediate results “tmp_table_on_…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… MyISAM FT index, I reallocated that memory to into key_buffer_size. The other thing that happened with regards to memory… index. You can use the DataImportHandler to import the result of any SQL query, and if you can form a SELECT query… performing all the tests on the same hardware, I got results that are least comparable to each other. Hernan S. commented…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…5.5 vs MySQL 5.6 performance results I’ve been looking at changes …8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /… 5610 | | PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 | 1556 | | SQL_MODE | | NO_ENGINE_SUBSTITUTION | | INNODB_OLD_BLOCKS_TIME …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… Innodb settings: innodb_buffer_pool_size=1G innodb_log_file_size=64M innodb_log_buffer_size=8M innodb_…idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root… idle connections from a third box and the results were the exact same. The conclusion is quite …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…that reads from a slave node will return results as current as reads from the original …redesign my prototype to use hints embedded in SQL comments, instead of instantiating different wrapper classes. Q…immediately, but the page also resides in the buffer pool and it can serve subsequent queries. …
