… [/caption] This post is followup to Peter‘s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was… an interesting question: If we have N nodes, can we send queries to nodes to be executed in parallel? To answer it… to MySQL using a new MySQLnd driver for PHP. In this post I’ll only show how to make these calls…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…, who attended my webinar, I got many questions and I wanted to take this opportunity to answer them. Q: Even ntp has a… full data is copied when you SST again. Q: Thanx Peter, I loved the webinar! Especially the fact that that everything… am glad you liked it:). Thanks everyone for all these questions, feel free to ask additional ones in comments.
Comment: COUNT(*) vs COUNT(col)
April 11, 2007 By 45 Comments
… that simple. The whole situation is more complex. The points Peter makes about use of indexes, covering indexes and NOT NULL… one at a time). Now one must also ask the question whether or not it is a valuable thing to know… rows in a table. This discussion is a good example of Peter‘s other comments today … simple answers are fine as far as…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… bias as possible (but see also Peter‘s post on bias) based on … consumer of their product or service. This happens through the grapevine, or through … lying by omission, so to speak. The answer is that vendors might not be …work is uncompromised. If you have any questions or comments, I invite you to …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… stable and predictable performance. I refer you to Peter‘s post, Performance Optimization and Six Sigma. …flushing”. This post shows the differences between them and MySQL. The post also answers the question of whether…on the MySQL 5.5 code line. The answer: Yes, we are. My benchmarks here are …
Comment: Small things are better
July 6, 2007 By 15 Comments
peter, coming back to your answer to sean’s question. When I do an alter table (to add a new … to add the new column. (BTW, why does it do this? Experience with MSSQL is that an alter table takes merely… in data as soon as the task is finished. Is this not true?
Comment: Why do you need many apache children ?
February 5, 2007 By 15 Comments
Hi Peter! Very interesting stuff. I was wondering if you could comment (either in this post or perhaps in another) about a question… better to use persistent connections (specifically for MySQL) and my answer has been the following (based on my understanding of Apache… consumed by processes that are not actively running. I recommend this partly because I know that MySQL itself keeps a thread…
Comment: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
Peter, This is the case when benchmarks have little value as it … happen. The question is whenever moving to UTF8 is REQUIRED when you upgrade to MySQL 5.5 and the answer is – not…
