Hi all, I…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: 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…
Comment: Multi Column indexes vs Index Merge
February 24, 2010 By 30 Comments
Hi 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
Hi 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…
