… MySQL Audit Plugin and would like to share my experience in this post. Auditing user activity in MySQL… the log (all the lists in these variables are comma separated). As pointed here, anything …, which has made using MySQL in PCI or SOX compliant environments, to name just two, artificially …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…anything you find in standard async MySQL replication. It is my belief …via the wsrep_provider_options global variable. gcs.fc_limit This setting …certification more expensive replication conflicts more likely and therefore time-consuming to the… Bytes Flow Conflct time name P cnf # name cmt sta Up Dn …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…? mysql> select version()\G *************************** 1. row *************************** version(): 5.5.25a-27.1-log 1 row in set (0.00 sec) mysql> show variables like ‘%thread_handling%’\G *************************** 1. row *************************** Variable_name: thread_handling Value: one-thread-per-connection…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… rows in set (0.00 sec) mysql> select * from information_schema.global_status where variable_name like ‘%innodb%read%’; +—————————————+—————-+ | VARIABLE_NAME | VARIABLE_VALUE | +—————————————+—————-+ | INNODB_BUFFER_POOL_READ…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…the slave. MySQL keeps two global variables with …variables like ‘gtid_executed’; +—————+——-+ | Variable_name | Value | +—————+——-+ | gtid_executed | | +—————+——-+ slave1 > show global variables like ‘gtid_purged’; +—————+——-+ | Variable_name…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5…rows affected (59.80 sec) session10 > show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 0 | +—————+——-+…
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
… expect we will have binaries in /usr/local/mysql, which we start mysql> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | +————————-+——————————+ | version | 5.5.29 | | version_compile…
Post: Actively monitoring replication connectivity with MySQL's heartbeat
December 29, 2011 By 2 Comments
… MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable… status variables do I have? The heartbeat check period time and the number of beats received. mysql_slave > SHOW STATUS LIKE ‘%heartbeat%’; +—————————+——-+ | Variable_name | Value…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… them. Then, I go through it line by line, like this: +———————————–+———————-+———————-+ | Variable_name | Value | Value | +———————————–+———————-+———————-+ | Aborted_clients | 205174 | 6 | Here we can… Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL …lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared …_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: tmp ENGINE: MEMORY NAME: #sql516_1c42_1 TABLE_ROWS: …
