…’t been keeping up with them lately.) His session will be about benchmarks of replication alternatives for MySQL… one of them understands the value in that request. Take a look at the speakers, titles, and … to find the top N most important rows per group of rows, distributed across a cluster of …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…simple shell script, which accepts HTTP requests, and checks MySQL on incoming request. If the PXC node is …IPs that need # to connect exclusively (security purposes) per_source = UNLIMITED } Also, we should add the …running. If you look at Cur column under Session, you can see, that c1 has 2 threads …
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… affect the speed at which InnoDB can log. You can request that InnoDB force its REDO records to the transaction log… guarantee it will be per second) NB: Percona Server with XtraDB actually allow you to control this at session level. This allows… later rolled back do to an error or a specific request, as part of the DO-UNDO-REDO protocol InnoDB also…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… have seen 50MB sequentially written once per certain amount of time which takes …| Key_blocks_used | 7248 | | Key_read_requests | 2051451 | | Key_reads | 198208 | | Key_write_requests | 469220 | | Key_writes | 185808 | … but it does not affect current session. A little gotcha which still catches me…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…Quote] “However, you can reach better through put (inserts per second) with less threads. So after dropping number … by 50% initially – taking it to 20-20 sessions. The problem almost disappeared and when we further … it imposes a time limit on I/O request so flushing would not have to wait on …
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… the slow log output, and INDEX_STATISTICS). Despite having many requests to port these patches to 5.1, we simply haven…_STATISTICS which show similar information to USER/CLIENT_STATISTICS but per THREAD granularity (it’s useful if you have connection pool… with results I show amount of TradeResults transactions per 10 sec during 3600 session (more is better) As you see with percona…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… We can also get query_cache_ttl as session variable, which is very helpful for connections opened…from query cache and there are multiple connection requesting the same item. What MySQL will do ? It… Invalidation Can we get something less coarse than per table invalidation ? It is tricky but I …
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… the documentation. There was discussion about making innodb_file_per_table a session variable. There was discussion on a bug that makes… the same too.) There was a confirmed and high-priority request to provide Windows packages for XtraBackup. XtraBackup tests were augmented…
