… it is not needed (I will refer to it as “sync fix”). In this post I however will focus on innodb… will be performed That is case …D…D…D..DDDPD….D….D…D….D only following pages will be flushed: …D…D…D..FFFFF….D….D…D….D (marked as “F”) Beside “cont”, in… dips than MySQL. So this is to show effect of “sync fix”, let’s compare Percona Server 5.5.18 (without…
Post: Using pt-table-checksum with Percona XtraDB Cluster
October 15, 2012 By 2 Comments
… \ –recursion-method dsn=h=127.1,P=4000,u=root,D=percona,t=dsns Not checking replica lag on node4000 because… was detected. Since we’re still “PXC-approving” pt-table-sync, it’s best that a DBA manually investigate any differences… check Any differences should be investigated manually until pt-table-sync is “PXC-approved” There are other limitations when using pt…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… transfer from ‘*any*’. Selected 1 (ip-10-112-39-98)(SYNCED) as donor. 120619 13:20:19 [Note] WSREP: Shifting PRIMARY…:19 [Note] WSREP: Member 0 (ip-10-244-33-92) synced with group. 120619 13:21:19 [Note] WSREP: Shifting JOINED… xinetd The servie itself should be configured in /etc/xinetd.d/mysqlchk. # default: on # description: mysqlchk service mysqlchk { # this is a…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
…=fileio –file-num=1 –file-total-size=${size}G prepare sync echo 3 > /proc/sys/vm/drop_caches for numthreads in…=sync –file-block-size=16384 –report-interval=10 run | tee -a run$size.thr$numthreads.txt done done Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… includes an example of pt-table-checksum and pt-table-sync, among others. Q: Which options were used to get this… –review S=/tmp/mysql_sandbox5527.sock,u=msandbox,p=msandbox,D=percona,t=reviews –report-all master/data/telecaster-slow.log…, it is possible that new differences are introduced while the sync is happening. In other words: bad data usually leads to…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… creating about 10-15 tables every second which means we’d take a very long time to create 30,000. After… closer to the libeatmydata performance. I also want to disable syncing of the FRM file to disk and set log flushing… initial test with MySQL, probably due to not writing and syncing FRM files. If I run the same program with libeatmydata…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…, restart it, then ensure the master and slave are in sync (once the test load is stopped). The team at Percona… hitting a rule that will issue a SET SESSION debug=”d,crash_commit_*”. The test will then continue to issue DML… also haven’t dug into partitions or blobs >: ) If you’d like to try these out yourself, they are in lp…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…: Q: If the Sphinx index isn’t in sync, will the out-of-sync rows not be found? No, only the documents… individual features, not in the context of application types. You’d have to evaluate how relevant the search results are for… benchmark can tell you. Thanks for all the questions! I’d like to see some of the folks who viewed my…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…, it was a possibility that the indexes were out of sync and we weren’t seeing new errors in the log… 5.6 (if the manual is to be trusted). I’d probably consider this on a newer version of Percona Server…, it turned out that the indexes were not out of sync, so I didn’t have to do anything to fix…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… in single-threaded MySQL replication. Therefore all nodes stay in sync much more reliably. Also, you can enable wsrep_causal_reads… due to updating the session table. For best scalability, I’d recommend storing $_SESSION in an in-memory data store such… hazards of multi-writing by keeping all the instances in sync continuously. Q: If a slave is slow because of bandwidth…
