… are overloading the system causing user experience to degrade. The first thing you need to know it is not MySQL problem… these does help in many cases. Whatever powerful and well tuned system you have if you put too heavy of concurrent…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… and tuned for the benchmark. I will show you the tunings. It should be also tuning procedure for general heavy writing workloads. At first, <tuning peak performance>. The next, <tuning purge operation…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
… additional concurrency check (there is always one when a thread first enters InnoDB) while the 900-row SELECT statements will always… itself than the possibility that it may become queued). Your first instinct may be to increase innodb_concurrency_tickets to >=900…_concurrency (which is why these two variables are most often tuned in concert). To continue the example, if innodb_thread_concurrency…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question… explained during our conversation. Have realistic expectations about configuration The first thing to know is that server configuration itself really isn… configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, with…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… of counters are virtually meaningless for two major reasons. The first is that ratios obscure magnitude. Look at the following and… tuned is because, even if you know the absolute numbers, you are missing the element of time, in two important ways. First… the statistics on those two servers. Maybe I measured the first server immediately after starting it, and that’s why its…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… non-leaf nodes, and the other for leaf nodes. The first 32 pages of a segment are allocated from ‘fragment extents… tuning” or prefer to expose tuning options to be available to the user. HT: I favor self tuning. PZ: I also like self tuning… fields (needs more info) According to the documentation, InnoDB put first 768 chars of each text/blob in the page and…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… any additional locking overhead that we should be aware of? Firstly, PBXT does not acquire read locks. A normal SELECT does… affect is that the init function returns quickly, but the first queries that access PBXT tables may hang waiting for recovery… values. On the other hand, I aim to provide expert tuning parameters for installations that need to extract maximum performance from…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… which usually define best solution are economics , resources and risks . First lets talk about optimizing application vs getting better hardware. With… upgrade the first time, because it even can take less time than moving the application. On reasonably tuned applications when further tunings are…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had… with these commands: date uname -a cat /etc/*release The first command is invaluable for later reference. The others will show… interaction In all cases, the customer’s guidance is our first rule. The customer determines the depth and complexity of the…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… well but beware of random writes to RAID5. Operating System First – run 64bit operating system. We still see people running 32bit… options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background there would… some changes you would like to do with your application. First make sure you’re using transactions when doing updates, both…
