… it can look: mysql> show processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State … you’re not actively changing users, stored procedures etc…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… very useful. With simple MySQL SHOW command it gives you the basic statistics on the database activity broken down by users, tables or indexes… catch users causing the most traffic to help you with some strategic decisions. Sample outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… always look at SHOW ENGINE INNODB STATUS to see if there are any transactions spending very long time in ACTIVE state. In… enough ACTIVE transactions which have some locks, like in this case: MySQL thread id 2059, query id 1014425 10.10.10.10 user…), undo log entries 1 MySQL thread id 1720, query id 1011283 10.10.10.10 user —TRANSACTION 2 1418397881, ACTIVE 317 sec, process…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…? Is the machine swapping actively? (This is more important…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name |…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G …innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb-import-table-from-xtrabackup…table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued …
Post: MySQL on OSCON
July 26, 2007 By 13 Comments
…show to much interest in the MySQL, and Databases for that reason. Our talk comparing performance of MySQL… of familiar faces. MySQL booth was not to active ether – in …MySQL go to Users Conference. This is surely true but I would expect significant Overlap between “Open Source Guys” and “MySQL Users…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
… tokens near by but little details: mysql> select * from user oder by pwd; ERROR 1064 (42000): …InnoDB: many active transactions running concurrently? I hope with pluggable storage engine interface Sun/MySQL spends some … related but you also need to run SHOW INNODB STATUS to see what exactly Innodb …
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…connection is active typically involves a call to the ‘ping’ or ‘statistics’ command at the MySQL protocol level,… problem is that the bad pseudo-code I showed above penalizes the common case in favor …0xA873BBC4583C4C85 278.4533 1.9% 6985 0.0399 SELECT users user_devices That’s right, 73% of the …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…with a lot of connections mysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | db | Command |…when you’re doing this activity anyway. Using this way you can…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…mysql> show processlist; +——+——————+—————-+————- | Id | User | State | Info +——+——————+—————-+————- | 7 | debian-sys-maint | NULL | CHECK TABLE tableA… | 739 | user | | NULL | 4776 | user | | NULL | 6318 | user…
