… with the codebase but not with the development process, would implement a feature. In short, the fact … of this is classic MySQL replication, which was implemented by Sasha Pachev at MySQL AB around 1999, paid … having been added in a sloppy way. He showed how, when done differently, it didn’t have …
Post: Percona Server on the Nexus 7: Your own MySQL Database Server on an Android Tablet
February 28, 2013 By 11 Comments
…as a regular Android App. The process is easy, but time consuming. …have binaries in /usr/local/mysql, which we start mysql> show variables like ‘version%’; +————————-+——————————+ | Variable_name | Value | +————————-+——————————+…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… -n 1′ and ‘uptime’. That shows me what processes are running, but it also shows me load average, memory sizes,… Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ |…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL… localhost | test | Query | 0 | NULL | show processlist | …
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… about that: http://dev.mysql.com/doc/refman/5….binary log So now, the process is the following: take … | Variable_name | Value | +—————+——-+ | gtid_executed | | +—————+——-+ slave1 > show global variables like ‘gtid_purged’; +—————+——-+ | Variable_name | …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…sets of data for the hardware to process from even small tables. Therefore often the…: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table | Rows_read | Rows…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…log and executing them on the SLAVE. Since MySQL 4.0 this process is a bit more involved having events passing …make another one you need to use SHOW SLAVE STATUS which provides much more information. mysql> show slave status\G *************************** 1. row *************************** Slave_IO…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW…. The server is allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and…-check-mysql-status is also very flexible and can be used to trigger an alert on almost anything from SHOW VARIABLES and SHOW…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… about beating data processing limitations of current systems. This raises valid question how fast can MySQL process (filter) data …`c` char(128) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1 mysql> show table status like “m4″ \G *************************** 1. row *************************** Name: …
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
… detailed performance analysis of what I’ve coined “distributed set processing”. Please also read this post’s “sister post” which describes the distributed set processing technique. Also, remember that Percona can help you get up… and 16 nodes (inclusive) are shown as lines. This chart shows the same data in another way: Concurrency testing is important…
