… too little for what you would expect from 24 core system. For comparison you can checkSysbench Results which Vadim published. For…,sub_select,do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_conn ection…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…269) ==9090== by 0x63A3E3: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5179) ==9090== by 0x6435EA: mysql_execute_command(THD*) (sql_parse.cc…potential deadlock. The locks in question are LOCK_global_system_variables and LOCK_system_variables_hash. Deadlock is possible when one …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… second and 1 IO to execute and we have 16 core system with hard drive which … take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018…0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable …commanual Com_empty_queryblogpercona.commanual Com_execute_sqlblogpercona.commanual Com_flushblogpercona.commanual Com…infoblogpercona.commanual sysdate_is_nowblogpercona.commanual system_time_zoneblogpercona.commanual table_definition_…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… system I’m working with. System performance Next I investigate what the system is doing, in terms of performance. There are two key commands for this on most operating systems (there are… expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server are extremely limited, and…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… you should expect from the system. What I usually look for MySQL is performance in random …important for MySQL. To prepare small 128MB single file working set we can use the following command: […808Gb (201.52Mb/sec) 12897.22 Requests/sec executed Test execution summary: total time: 60.0001s total …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… (+6ht) and 24GB of memory was selected. The selected operating system was Fedora 14. Oracle VirtualBox OSE was used to create… storage for the virtual machines. Baseline: The MySQL command line client was used to execute the a script file containing the 11 queries… results and response times were captured with the T command. The queries were executed on a single database schema containing all of…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…MySQL Storage Engines, some of which as InfoBright or KickFire take over execution after parsing, Sphinx MySQL support has nothing to do with MySQL…mysql –host 127.0.0.1 –port 3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL… multiple nodes in the system. The raw scan speed …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL…cache. Only SELECT queries are cached SHOW commands or stored procedure calls are not, …wasting memory. Distirbuted caching systems can effectively use memory on multiple systems so there is no…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…even data distribution in the system. To get an even … to 2010′; mysql> use ontime1; Database changed mysql> show table status …returned (0.084244966506958s, 0.078309059143066s, 0.0059359073638916s) Execute the test: As seen above… from the ./run_query command, called pivot_results cd shard-query/ $…
