…lock(s), undo log entries 1 MySQL thread id 3972, OS thread handle 0x7fddb84e0700, query id 16408 localhost …this problem, quite simply, is the tradeoff to multi-node writing in a synchronous replication system… pretty easy to rig up with an HAproxy configuration or similar so if your main writer node…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… is wserep_cluster_conf_id — the version # of the cluster configuration. This changes every time a node joins or leaves the… — This is a general indicator of how many parallel replication threads you could use. In practice I haven’t found this… detect replication lag, and this really just tells you if multi-threaded replication could help improve replication speed at all. Conflct Replication…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…-mysql-5.6.html These improvements sound interesting to page flush and i/o problems? Explicit Partition Selection, Split Kernel Mutex, Multi-Threaded Purge, Separate Flush Thread, Pruning the InnoDB Table Cache This article was for… is a good practice with a bigger gain than server configuration” [End Quote] This is another article on log file sizes…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
… what swapping does for concurrent (multi CPU, multi client) processing. Database Locks…The less portion of execution time thread spends holding exclusive locks the …. The bottom line: You should configure system so no swapping activity … to see slowdown instead of MySQL being killed because of out…
Post: Percona Server scalability on multi-cores server
September 29, 2010 By 14 Comments
…. The disks are 270GB in total, with the underlying configuration RAID10 over eight 2.5″ 15K RPM disks. To make… factor as the result with 10 threads divided by the result with 1 thread.) Above 10 threads, the rate of increase is not… these results with the latest MySQL 5.5 releases, and especially in cases with the number of threads is > 100. I’m…
Post: FusionIO 320GB MLC benchmarks
January 11, 2010 By 19 Comments
…into software RAID0, and tried 100GB filesize in this configuration. Block size is 16KB in all cases. The …concurrency To get most from card you need multi-threaded IO (4-16 threads) With RAID0 you can get doubled space…these cards and numbers, I am going to benchmark MySQL with FusionIO as storage…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…is a dangerous setting in multi-master setup, but should…:30 [Note] WSREP: applier thread exiting (code:7) 120723 23:…Ignoring possible split-brain (allowed by configuration) from view: view(view_…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…. Because of features like multi-threadeded apply, changes are executed more promptly than they would be in single-threaded MySQL replication. Therefore all… replication in master side vs slave side? A: You can configure filtering either on the master or the slave. Master-side…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with…, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (duration… is specific Falcon’s way to handle multi-versioning. I think this is a …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…available RAM as its file cache. The ideal configuration in a dedicated server is: set …size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement,… the development process? HT: Contention and thread thrashing depends very much on the hardware…
