…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…load growth and need to have system handle another 1000 of such queries per second ? I will need to do…balance of CPU vs IO utilization as well as as simple as how much does it cost to…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…load by half through the load balancer did not restore proper response time, so it wasn’t load… for Daniel figuring out how to make mk-query-…to catch in action as it happens, but we’re thinking about ways to do just that. Catching a server…’s where improvements to the MySQL source code are necessary…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…I’d like to share my experience. The article does not cover MMM installation nor how to do this …masters Once standby servers (only db2 in our case) have caught-up, we are ready to upgrade …. you must change application to use different IP for MySQL or ensure some load balancer/proxy does this, …
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…load balancing and fall back I would like to be able to pass list of servers system can connect to and let it handle load balancing…to be able to run multiple queries for multiple MySQL connections at once. For scale out applications data to…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…server, so you can use DNS for load balancing without worrying about TTL and similar things. If Active server…to remove READER role from the server if it gets too delayed with replication (or if replication breaks) so you do not have to do…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
…how to handle it, or be able to learn it. It is also important to adjust processes as required to…doing is wisely. It complicates operations tasks (backups, balancing, performance analyzes) as well as it exercises not so common paths in the MySQL server…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…load balancing, using something like img23.domain.com to serve some of the images. I’m not big fan of purely DNS based load balancing…to using some server modules for access control or hacking one if you need some special functionality, few people however have skills to do…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…do not forget to readjust it later. This is also valid approach as if it is Dedicated MySQL Server…load. Idle connections for example will consume significantly less memory than connections doing…balancing…
Post: Progress with ClickAider project
October 24, 2007 By 21 Comments
…load balancing between “gathering” servers in Europe and US which seems to work very well both providing level of HA if one of the servers…to do some of it for certain most common queries. At this point however we’re looking how…
Post: Percona is hiring a consultant
December 16, 2009 By 7 Comments
…MySQL. Not just “certified” — years of production experience with it. You need to know server internals, for example. You need to be able to do…
