…in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables…MySQL is up and running. That said, there are plenty of other MySQL and OS-level status…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…of all, we used a smaller dataset for this benchmarks round, since reportedly Dimitri was using 8 tables…of updates to the database, all SELECT queries, even those participating in…of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… new connections as in MySQL. This is …Databases” section of the output also shows the name of the databases…Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_terms’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_terms`\G # SHOW TABLE STATUS…of selecting every column from all the tables involved in …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…table, or the database itself. Likewise, if a system administrator leaves a temporary file in the database…mysql-status is also very flexible and can be used to trigger an alert on almost anything from SHOW VARIABLES and SHOW STATUS…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…of the database was a single table…in which they were defined, and the PRIMARY KEY is always going to be considered as being defined first. So, MySQL…localhost) [test]> show status like ‘handler%’; *** some rows omitted *** …all sorts of related unpleasantness. There is, of…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…status variables. It’s important to note that this reflects the status of a single PXC node in…database operations. cnf This is wserep_cluster_conf_id — the version # of…at all. Conflct Replication conflicts, as described in …of my three nodes, and more slowly on the third. I had to decrease my table…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In a lot of…In fact this is often one of the first things I do as it is least intrusive. Run SHOW ENGINE INNODB STATUS…Database pages 8252672 Old database…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
…of time. Instead of manually looking for the right line in the output of SHOW ENGINE INNODB STATUS…table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…MySQL keeps two global variables with GTID numbers on it: gtid_executed: it contains a representation of the set of all transaction logged in… from the master: # mysqldump –all-databases –single-transaction –triggers –routines –host…table-checksum and pt-table-sync. How to restore a slave in…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…database server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL…of time, so it reflect natural state of the table as it would be in the production over time: mysql> show table status…
