hi peter, I would like to run MySQL5.5.14 with InnoDB … 12 GB DDR3 RAM My question is: how much RAM should i give to MySQL? 4GB? 6GB? 3GB? Please advise. Many thanks in…
Post: Join me for 'MySQL 5.6: Advantages in a Nutshell.' Webinar. March 6 at 10 a.m. PST
March 4, 2013 By Leave a Comment
… overview of the advantages MySQL 5.6 offers. My focus is a practical one – to identify the … by registering for this free webinar. Please feel free to ask questions, as this will be an interactive …. For recent and related posts from Peter on MySQL 5.6, please check out “Percona Welcomes MySQL 5.6…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… interesting follow up questions out of this. I had added my comments to some of the questions. HT will … not match the WHERE condition in a search. Please use this with care: you MUST use row…are your suggestions here? HT: According to tests by Peter Zaitsev, O_DIRECT works well to remove double …
Comment: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…Peter. According to my math, in the single thread case, 1-331…is inconsistent with our experience, hence my follow up question: Could you post the my.cnf relevant config for the … box configuration was used, please clarify that, or if something else was used, please indicate the details. Thanks, — …
Comment: 3 ways MySQL uses indexes
January 22, 2013 By 28 Comments
Hi Peter, I have a question. I have a table ‘t_table1′ include 3 fields : `field1` … rows: 1042 extra: Using where I think it say that my index useless in this case. But when I run this… rows: 1 extra: Using where This case it used my index. So please explain for me: 1. why SQL1 can not use…
Comment: mysql-proxy, urgh performance and scalability ?
June 10, 2009 By 44 Comments
… the past). As Peter points out: It is interesting to look at the overhead curve across different applications. My rule of thumb… find any bugs, please report them at http://bugs.mysql.com in the Proxy component. If you have additional questions, we are…
