…doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=… the other hand, TPS does slightly drop with time in the second half of the experiments. Same…sleeps is not enough to solve them. However, MySQL 5.6.2 is experimental code and I am sure that next MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…sleep…time_formatblogpercona.commanual time_zoneblogpercona.commanual timed…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… for scripts running very long time. For simplicity I did not use MySQL, but other system call – sleep() which has similar behavior for… experimenting with sleep() function is wrong and if I would use real MySQL queries this would be counted to max_execution_time and so… 2 simple scripts which run for 1000 seconds (spending this time on MySQL time) one is doing single query another 1000 queries 1…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…permanent and temporary. There is a max_heap_table_size variable which …: 16384 INDEX_LENGTH: 0 CREATE_TIME: NULL UPDATE_TIME: NULL *************************** 2. row *************************** SESSION_ID: …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
….php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2….php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h 10.2.2… of the max of 20. This is required for another series of benchmarks I’ll present soon, this time looking at the…
Comment: Apache PHP MySQL and Runaway Scripts
May 24, 2008 By 20 Comments
… runaway MySQL query. Eventually the max_execution_time will be reached, as the execution of mysql_?, PDO etc are counted towards the max_execution_time, and the script is aborted. In you tests however, the sleep() function…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime…Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment: NULL Create_time: 2011-05-10 04:26:14 Update_time…thread-concurrency-timer-based innodb-thread-sleep-delay=0 innodb-use-sys-stats…
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
…_cluster_start #!/bin/bash #Give some time to the nodes to connect /bin/sleep 15 /usr/local/mysql/bin/ndb_mgm -e ‘all…_ndbd #!/bin/bash #Give some time to ndb_mgmd to start /bin/sleep 10 nohup /usr/local/mysql/libexec/ndbd -c 10.2… ndbdclone ndbd1-IP \ meta globally-unique=”false” clone-max=”2″ clone-node-max=”1″ location loc-1 mgmd inf: testvirtbox location loc…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… hard time to keep up with update rate, in this case difference between these values will also grow and innodb_max_purge… to enter innodb queue at the same time Innodb makes thread to sleep for some time before trying to wait (if no free…. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1, locked 0…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… about every bit of information about queries that mysql-proxy can, making this a viable way to… # total min max avg 95% stddev median # Exec time 114ms 0 101ms 14ms 100ms 33ms 737us # Hosts 8 # Time range…CREATE TABLE `dual`\G # EXPLAIN select 1 from ( select sleep(.1) from dual ) as x\G Indeed, it’s…
