… network traffic would really slow down transactions. You may …affected (0.00 sec) Now, on two different nodes we will… transaction on node1 updating row 1 in our table. Note we haven’… transaction node1 mysql> select * from autoinc; +—+——-+ | i | j | +—+——-+ | 1 | node3 | | 4 | node2 | |…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…from even small tables…slow…updated: 240 Select_commands: 1759 Update_commands: 254 Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…how to run pt-table-checksum and pt-table-sync from slave? This was … –report-all master/data/telecaster-slow.log Slide 45 is the… you have data differences between two (or more) servers, if using …table-sync if the damage is contained (i.e. one or a few tables, in rows that probably won’t be updated…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…mechanism was an optimization for slow drives: if you can …from a latency perspective, not dollars), this is still an optimization because the longer we delay updating…dirty buffers. These two numbers are relevant from the BUFFER POOL…if you have relatively few tables and/or use the global …
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…-time=5 log-slow-queries=/apps/log/slow-query interactive_…, you can choose between # two methods : # # 1) Use the …^32 – 1 # (and different from the master) # defaults to …update = /path-to-dedicated-directory/hostname tmpdir =/mysql_tmp/:/tmp/ # Uncomment the following if you are using BDB tables…
Comment: Sharing an auto_increment value across multiple MySQL tables
October 12, 2010 By 9 Comments
… updating a primary key to be slow. I’d retest senario number two with an update to a non primary key column. Like: CREATE TABLE… option2 VALUES (1,1); # start from 1 # each insert does two operations to get the value: UPDATE option2 SET id=@id:=id+1; SELECT @id; At one point that was a lot faster than updating the primary…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… you want GTID support log_slave_updates will need to be enabled in…it on the slave. MySQL keeps two global variables with GTID numbers on it…Error: Got fatal error 1236 from master when reading data from binary log: ‘The slave…table-checksum and pt-table-sync. How to restore a slave in a good and slow…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… click analyzing schema, in two modes – 1. data size …Despite Inserts and Deletes are fast, updates are not expected to show…backup, as it applied TABLE LOCK on copying table. When recovery logs… application, it can be from simple apache logs put into…waste of RAM memory and slow inserts. This is where …
Post: Descending indexing and loose index scan
May 9, 2006 By 6 Comments
… read-ahead which may slow it down a bit. Or… you want to order by two colums in different directions: … ORDER…updates so it becomes less ugly. In fact this is for example why you would see “reverse_timestamp” field in Wikipedia table… applications or porting ones from other databases. Designing the …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…table_cache=2000 Percona Server 5.1 Results For better presentation let’s also slice this data the other way: From… and results) and here are the updated 5.6.2 results. The difference …slow the growth of the history list. But, TPS in the second half of the experiments is stable. Finally, the last two…
