June 20, 2013

Post: What I'm looking forward to at Percona Live (MySQL Users Conference)

April 4, 2013 By 1 Comment

…these technologies can be applied in practice. I learn what works and what…share their deep technical insights, holding back no secrets. Reconnect with Old Friends… me to reconnect and catch up. [caption id=”" align=”alignright” width=”336…as well as to give the best possible advice to my customers as …

Filed Under: MySQL, Percona Live Tagged With: , , , ,

Comment: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

… something smaller it was because of long experience backed up by testing that showed smaller was a better … at high connection rates. max_connections was the best proxy we had for expected high connection rates …makes it desirable not to be too big. In practice we tend to see query cache sizes that …

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: The Math of Automated Failover

September 18, 2012 By 9 Comments

… the system working correctly until you have it working in practice. This is where my like for Manual failover comes in… never fail back without manual intervention. We also will failover only when replication is caught up (wait for slave to catch up before… small case, have little discipline and, implement solution not following best practices and do not test in properly. Lots of unfortunate downtime…

Filed Under: Insight for DBAs, MySQL

Post: EuroOSCON 2006 - High Performance FullText Search

September 22, 2006 By 4 Comments

…’m now back from EuroOSCON 2006 which was the reason I was not…such as Zak. We had good chat. There was MySQL Best Practices BOF on the conference which surprisingly attracted very few …and active growth of smartphones market we might soon end up with main function of Mobile operators to be provide …

Filed Under: Events and Announcements Tagged With: ,

Post: Why you don't want to shard.

August 6, 2009 By 34 Comments

…Partitioning by Application Function – This is usually the best way to fix any of the problems … will equally distribute the data equally. In practice this method can be really hard to … as HiveDB.) Operational issues become more difficult (backing up, adding indexes, changing schema). I think that …

Filed Under: Insight for Developers Tagged With: , , ,

Post: Announcing Percona Live MySQL London

June 27, 2012 By 6 Comments

…Architecture and Design Tools Utilizing Hardware New Features Best Practices for Businesses Replication High Availability Strategies Each …practical technical knowledge.  I want them to leave after my talk saying, “I can’t wait to get back… of their colleagues to attend.  So join up now, and submit a …

Filed Under: Events and Announcements, MySQL

Post: InnoDB thread concurrency

June 5, 2006 By 4 Comments

…/srv/srv0srv.c) So what is the best value for innodb_thread_concurrency? The value…practice however this values might be suboptimal, especially with large number of active threads. So, for certain workloads you might end up…_commit=1 and do not have battery backed up cache on your log volume you might…

Filed Under: Insight for DBAs Tagged With: , , ,

Post: Recovery beyond data restore

August 2, 2008 By 11 Comments

…but we can get all the data back… or sort of. In practice you have to be very careful … delayed replication (which you already could have set up with mk-slave-delay from Maatkit. Delayed slave …timely fashion over long distance network, meaning it is best to have local backup (and delayed slave if …

Filed Under: Insight for DBAs Tagged With: ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… tell you what we think is best for you, which is our job)…. 17g virtual size, and there’s practically nothing else running (this is a …get information about the all-important battery-backed write cache, how it’s configured… we can frequently help customers set up much more efficiently and with better …

Filed Under: Insight for Developers Tagged With:

Post: The Optimization That (Often) Isn't: Index Merge Intersection

December 14, 2012 By 6 Comments

… a problem) but probably not the best way to go for a permanent solution… query execute more quickly may end up creating unintended negative consequences elsewhere. We… as a whole. When I came back the next day and we looked … involved have good selectivity (a good practice in general, to be sure). As …

Filed Under: Insight for DBAs, Insight for Developers, MySQL
« Older Posts