…=0, rarely used option which as per manual will chose best value automatically. Making this change I …as default value would not impact them. For people who have more than 7 tables in join I think … likely to get even better handling joins of many tables as optimizer heuristics are improved so much …
Post: How We Got Here
April 9, 2012 By 6 Comments
… event balances community, business, and technology, not just open source. Many key decisions were even made outside of Percona’s control…. We have the best selection of speakers and topics ever at any MySQL conference, bar none. Attendees will hear from people who use…. These are the people who are uniquely qualified to talk about how MySQL works in practice. Sponsors will have an engaged and active…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
Many people use mysqldump –single-transaction to get consistent backup…ALTER TABLE. When ALTER TABLE is Performed in many cases it will Create temporary table with modified structure, copy data…-all-tables instead which does not have this problem at the cost of having database read only for the …
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… we are honored that these compliments come from people who’ve been attending the conference for …a “maybe.” We have committed to running the conference in 2013 and it will definitely happen. 2013 …to the dot-org booths and book signing. Many companies announced new product releases and partnerships …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… a look into solving this problem. You will be thanked by a lot of people running MySQL in wild. I also wanted… usage shrinks can be very helpful in diagnostics. If you have many applications it might make sense to shut them down one… (0.98 sec) This however will not cover TEMPORARY tables some of your connections might have created and forgot to remove (or…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…We found that people were using it eagerly even without advertisement. However, it had many limitations and …In addition to pt-online-schema-change, we have completely redesigned and rebuilt the pt-summary… on Tuesday Daniel will talk about using it to verify replication Peter will discuss using it…
Post: How many people will leave MySQL now ?
March 21, 2008 By 7 Comments
… will still enforce complicated legal, financial and informational procedures especially as it is public company. What always surprised me in such people… how many people hate new policies/management/culture compared to amount of people who actually decide to take this step. Risk of not having…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… interactive applications with large data sets being sorted. On many web sites you will fine top tags, recently registered users etc – which…) assuming most people will have gender specified, as well as (country_id,city_id,last_online) assuming in most cases these will be specified… you would have ORDER BY col1, col2 DESC MySQL will have to use filesort. Classic for solution for this would be to have index…
Post: Can having information public hurt consulting business ?
April 30, 2008 By 9 Comments
… think it also have significant negative effect because people find information on … to for advice. There are many things which causes such symptoms…will have possibility to discover and try all possible recipes. Besides experience you really need the constant practice. Doing MySQL Optimization I have…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… size web sites which have millions of page views per day. Typically single Apache server in this configuration will have rather high MaxClients… limits. Sometimes I see people to use the following formula to count optimal number of children – I have Page generated in 1… example to display affiliate goods and you have timeout of 3 seconds you better have enough apache children (fast-cgi processes etc…
