…peter” where c=”andy”; Query OK, 0 rows affected (0.00 sec) Again, you can…you can‘t update/delete that row, because it doesn’t exist anymore. I hope this example clarify your questions, if not, feel free to ask…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, we take a brief look at the server beforehand, so we can ask more intelligent questions and skip…months after Peter helped a client. Now, if Peter worked with the client 6 months ago, you …can then tell me how much total gain I can get from it. Queries are not just “bad” or “good” — it’s a question…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…questions you asked Heikki. If you have not seen the first part it can be found here. Same as during last time I…a mechanical disk. I do not know how it is for sequential writes, like log flushes. A question is why to use a…
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
…a product or a service can expect that Percona will make recommendations with as little bias as possible (but see also Peter…can, and ensuring that the integrity of our name and work is uncompromised. If you have any questions or comments, I invite you…
Comment: Multi Column indexes vs Index Merge
February 24, 2010 By 30 Comments
… Peter, I have a similar question as to what Chad asked about having multiple column keys. We need to build up queries based on columns a… column ‘a‘ will always be there. So the queries can be like WHERE a= AND b= AND c= AND d= OR WHERE a= AND… WHERE a= AND b= AND d= Would you recommend one composite index like KEY ‘my_key(‘a‘,’b',’c',’d') which can server my…
Comment: Why do you need many apache children ?
February 5, 2007 By 15 Comments
…Peter! Very interesting stuff. I was wondering if you could comment (either in this post or perhaps in another) about a question I get quite a bit in my seminars. I often get asked…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
Can Shard-Query scale to 20 nodes? Peter asked this question in comments to to my previous Shard-Query benchmark. Actually he asked…a relational algebra equation. In Algebra you learn that some operations are “distributable”, that is, you can…applied to distributed computation I maintain another open …
