… this opportunity to answer them. Q: Even ntp has a delay of 0.3-0.4 between servers does that mean a 0.25 as… fail with the tar stream being from the future. The 0.3 – 0.4 second delay seems too much to me. According to… full data is copied when you SST again. Q: Thanx Peter, I loved the webinar! Especially the fact that that everything…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…a blog post that will both answer their question, so I can just…physical id : 1 siblings : 4 core id : 3 cpu cores : 4 fpu : yes fpu_…| | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This output is very …about 6 months after Peter helped a client. Now, if Peter worked with …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… track down where the bottleneck is… I’ve read Peter Z two guides but cannot really convert the gained …600 connections when every connection consumes X mb. If the answer to ‘b’ is 2mb then the total amount of … iowait idle total 15.0% 0.0% 9.5% 0.0% 0.3% 6.5% 68.4% cpu00 22.1% 0.0% 11.1% 0.1% 1.1% …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…do this without splitting the file? The answer lies in the Unix fifo. I … “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data …-bound. vmstat showed from 1% to 3% I/O wait during this time. (… log entries being written to disk. (Peter arrived at the same guess independently.) …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… predictable performance. I refer you to Peter‘s post, Performance Optimization and Six…MySQL 5.5 code line. The answer: Yes, we are. My benchmarks …5.8 we have regular dips (3 times per hour) from 24900 NOTPM… requires setting innodb_flush_neighbor_pages=0 , to disable flushing of neighborhood pages…
Post: devops webinar - follow up Q&A
November 6, 2012 By 5 Comments
… similar problem as in the story of Peter and the Wolf Q: Did you hear…usually using the French pronunciation. So to answer your question, Liquibase is probably the …to make it easier to understand: 1.0 1.1 1.2 Application use column … will wait for the next release (1.3) to really delete the column …
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 31 Comments
…Peter I had a question regarding index merge (intersect). …query executed in 0.03 secs whereas the second SQL query when using index merge executes in 3.8 secs…using a single index. I would greatly appreciate your answer. First explain —————– explain SELECT LinksTbl2.id, LinksTbl2.title, …
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
…1 So, in sum, we see that about 3/4ths of InnoDB log file writes on …setting of 1. If it’s set to 0, the distribution may be quite different — the writes…really? We’d need to benchmark and see. Peter and I were just talking, trying to remember…returns from vacation and already know all the answers by…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
…caption] This post is followup to Peter‘s recent post, “Investigating MySQL… be executed in parallel? To answer it, I decided to try …has been available since PHP 5.3, and in most part it… something FROM tableN WHERE “, MYSQLI_ASYNC); } $processed = 0; do { $links = $errors = $reject = array(); foreach…
