…_spin_wait 467974 8.1511 mysqld rec_get_offsets_func 376898 6.5648 mysqld buf_page_get_gen PMP 10 libaio::??,os_aio…_p cur_open_with_no_init_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::index_read,handler::read_ra…_func,row_sel_get_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read _multi_range_next,QUICK_RANGE_SELECT::get_next…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
…of people are running MySQL Master-Master replication pairs in Active-Passive mode for… for the same row to get different updates on master and slave and replication will get silently out of sync. So back of our topic of auto_increment_increment and auto_increment_offset – …
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
… From the manual, here is how MySQL handles timezone locality with timestamp fields…offset | +———–+ | -04:00:00 | +———–+ Node1 is configured in PDT time while node2 is configured in EDT time. Now, lets insert some rows…get the actual rows in need of syncing, it will not find those rows…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… are in your MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview…% Binary logging ROW Slave status 0 seconds behind, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version…, running, no errors Slave mode STRICT Auto-increment increment 1, offset 1 InnoDB version 1.0.6-unknown +- [redacted].compute-1…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…file to another MySQL server. If you try to very often you’ll get an error in …’s indexes: mysql> select * from INNODB_SYS_INDEXES WHERE TABLE_ID = 13G *************************** 1. row *************************** TABLE_ID: …_PREV 4 offset of previous page in key order FIL_PAGE_NEXT 4 offset of next…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… approximately which binary log and byte offset to look in? That would have … my laptop to illustrate: mysql> select * from heartbeat\G *************************** 1. row *************************** ts: 2011-08-03T18:… be running pt-heartbeat already to get a reliable indicator of actual replication …
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
…write workload is very non uniform, you can easily get very different numbers if you are not taking …write workload (a mono-threaded script that inserts one row at a time in a table, as fast …completely different logics. The LSN simply shows the byte offset, so when you write 100 bytes to the log…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… data. These are going to get more attention as people run into… — here’s the magic — the byte offset of the worst performer in the…_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0 Rows_read: 0 # administrator …and that’s where improvements to the MySQL source code are necessary. But …
Post: Should MySQL Extend GROUP BY Syntax ?
August 17, 2007 By 11 Comments
… row matching some value in the group: This is one illustration of group by limitations in SQL language which is not offset by any MySQL specific extensions,yet As you can see if you want to get one row from the group… enough in MySQL they would have rewrite a lot going to other database anyway while they would love to get features which…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…, not different MySQL configurations, I didn’t try out different MySQL versions or …_recover skip-grant-tables Amount of rows used was 20M, transactions were not …IO alignment yourself. In this case offset is correct, but file system … see what benefits we can get there from proper alignment. You …
