…MySQL…commanual connect_…_host_…thread_cache_sizeblogpercona.commanual thread_concurrencyblogpercona.commanual thread_handlingblogpercona.commanual thread_stackblogpercona.commanual Threads_cachedblogpercona.commanual Threads_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… Host column; there you’ll see a hostname followed by a port number. That is the port number of the TCP connection… p on b.trx_mysql_thread_id = p.ID LIMIT 1′) if [ "${host}" ]; then echo “Host ${host} is blocking” port=$(echo ${host} | cut -d: -f2) tcpdump… iterations. And watch your server to find idle-in-transaction connections that are just sitting there doing nothing, and kill them…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… of connections you need. The problem is there can be only so many connections active between Host “Apache” and Host “MySQL“: Port 3306 as connection in… of Connections with MySQL, it however might not be overly efficient – managing large number of threads may be a bit more expensive. Threads also…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
…connection}{$datetime}}, $query if length($query); $connection = $1; $starttime{$connection} = $datetime if (($datetime $_) { sleep $now – $_; } # Now that the threads… { my $dt = $_; while((time() – $offset) connect(“DBI:mysql:database=$DBNAME;host=$DBHOST”, “$DBUSER”, “$DBPASS”) || die “Couldn’t …
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 10 Comments
… some MySQL Error Messages which are confusing, here is one more: 080603 20:53:10 [Note] Slave: connected to master ‘repl@host.com…/O thread: Failed reading log event, reconnecting to retry, log ‘master-bin.003676′ position 444292333 080603 20:53:10 [Note] Slave: connected…/O thread: Failed reading log event, reconnecting to retry, log ‘master-bin.003676′ position 444294573 080603 20:53:10 [Note] Slave: connected…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’20′ ‘Com_show_slave_hosts‘, ’61′ ‘Com_show_slave…_waited’, ’20096′ ‘Threads_cached’, ’0′ ‘Threads_connected‘, ’260′ ‘Threads_created’, ’124272′ ‘Threads_running’, ‘…mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…CONNECTION IDENTIFIER Each slow log entry now contains a connection identifier, so you can trace all the queries coming from a single connection. # Thread… are the InnoDB usage statistics. MySQL currently allows you to see…look like this: # User@Host: macko[macko] @ localhost [] # Thread_id: 4 # Query…
Post: Living with backups
November 6, 2008 By 28 Comments
… -z -v -f – mysql | ssh backup@storage-host /root/backup-tools/write_backup.sh This will read /mnt/snapshot/mysql directory at 15000000…= 1; } … 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 sends…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… for new connections as in MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections. Now… vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26 # User@Host…_verbosity=full: # Time: 111229 3:11:26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding…you’re running replication Slave as slave thread will issue single IO request most …any “Cluster” having SAN you can always “connect” the storage to another node – if server…
