… 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: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… recommends to have space reservation to get sustainable write performance (Tuning Techniques for Writes). I took FusionIO ioDrive 160GB SLC card… tuned by Virident engineers, while FusionIO card was tuned only by me and I may not have all knowledge needed for FusionIO tuning. First…
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…
