… MySQL creative error message: mysql> show tables; +—————-+ | Tables_in_test | +—————-+ | queue | | test_innodb | +—————-+ 2 rows in set (0.00 sec) mysql… MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 Server version: 5.1.30-community-log MySQL…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… offer great performance on distributed systems, especially if they are connected via not very fast network you need to come up… timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL got back to spend…, our patches and I guess Google patches are in the queue which is very good sign. There is still fair amount…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…OF SPEC} Other … # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller … not different MySQL configurations, I didn’t try out different MySQL versions or…= 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding…tools available to see disk utilization latencies queues etc. There is however also a …any “Cluster” having SAN you can always “connect” the storage to another node – if server…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… and the maximum degree of parallelism is easily enforced with queue. Today I am going to show you how to take… the serial version as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), count(*) from words2… cores are connected to my bus, and because I chose to create six hash “buckets” in the table. This allows MySQL to…
Post: Percona Launches New Support Option for MySQL
October 5, 2010 By 9 Comments
… which we have offered top-notch consulting since 2006. Just MySQL, MariaDB, Percona Server with XtraDB, and Percona XtraBackup. Focusing makes… us went into one pool, one queue. This works great to keep everyone accountable and connected to customers, but it sometimes makes… offering is a significant step forward for the entire community. MySQL users need better choices. They need immediate access to deep…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… each of connections for MySQL there will be ether not started state if there is no active Innodb transaction for this connection, or… innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue“. Latest one is quite interesting – to avoid… it enters the queue. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in…
Post: Living with backups
November 6, 2008 By 28 Comments
… /sys/block/$device/queue/scheduler ] ; then \ echo “cfq” > /sys/block/$device/queue/scheduler ; fi ; done # cat /sys/block/sd?/queue/scheduler noop anticipatory…; } … my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected“‘); … if ($$row[1] < 10) { $is_running= 1; } if ($$row... this script does is to check MySQL status every second and in case the number of connected threads goes above 50, it…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… run single batch job on the server with MySQL, Load Average is likely to be close to … parallel execution continues and where waiting in the queue starts. If you have fully CPU bound workload …1 and your workload scales linearly with number of connections and CPUs (ie there are no row waits involved…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…concurrency variable. A thread is placed in a queue when it tries to enter InnoDB if the…-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings:…=500 innodb_max_dirty_pages_pct=90 max_connections=3000 query_cache_size=0 skip-name-resolve…
