…where improvements are expected. This is the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find… So we will suppose that we can read the binary logs of the crashed master. The…219be3a9-c3ae-11e2-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…find an answer to these questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL…mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log…mode is ON? I can‘t think of …where gtid_mode is ON with servers where …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…3. My node is crashed and I have this error in my log : 07:53:55 UTC – mysqld… pointer: 0x7f9234000990 Attempting backtrace. You can use the following information to find out where mysqld died. If you see…file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes on…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…MySQL 5.6. In order to understand more about differences between results we have rerun tests on several our boxes. You can find…_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 … avg(id) from sbtest$i force key (primary) select count(*) from sbtest$i WHERE k like ‘%0…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… the query in the processlist, and you can track down where it’s coming from in the source code…. First, I identify which transaction is blocking others. Next, I find out the TCP port for that connection. I then … to convert this into a query log, and examine the log. In MySQL 5.1 and newer with the …
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… ever wondered what servers are in your MySQL replication hierarchy? We have, too. As …-slave-find (it was actually born as mk-slave-find, ages ago before I even …_wild_ignore_table=foo%.mount% Binary logging ROW Slave status 0 seconds behind, ….8 So that’s how you can quickly find out what’s in your …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… question I often get is how one can find out queries which should be optimized. By looking at pt…. In this case if I index the table I get the following record in the slow query log: # Time: 120911 17:…a,sbtest b where a.id=5 and b.id=a.k; mysql> explain select * from sbtest a,sbtest b where a….
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql and it’s reading from /etc/my.cnf. I‘ve seen a lot of cases where there’s a /var/lib/mysql…pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-…build can give you. Having found the desired information about the queries by any means necessary, I find …
Post: Find unused indexes
June 30, 2012 By Leave a Comment
I wrote one week ago about how to find duplicate indexes. This time we’ll learn how to find…mysql> SELECT INNODB_INDEX_STATS.TABLE_NAME, INNODB_INDEX_STATS.INDEX_NAME from INNODB_INDEX_STATS WHERE… partitioned tables, you can‘t get index …log# pt-index-usage slow.log slow.log: 11% 03:58 remain slow.log…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…) is using, where (i.e. for what… can print stack traces that show where…Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…find that the default options will perform well in most scenario’s. For the technically advanced, you can…
