…view) is that performance bugs don’t receive very hi priority. Yet, a lot of us are using MySQL because it seems to…to InnoDB’s buffer pool. For this, you need to find a way to tell Linux to…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…way to report exactly which rows matched, without doing additional searches for each keyword. Jessy B. asked: Q: With respect to…to add documents to, either individually as you add new data to the MySQL…to use one technology or the other, and some may compare one technology to…
Post: What’s a good buffer pool read/write ratio?
May 31, 2011 By 6 Comments
… the most useful way to approach the graphs. It really comes down to the difference between discovery and diagnosis. In general, it’s best to use the graphs for diagnosing problems that you already know about, not for trying to discover problems. Your monitoring… — maybe once a week I’d look at the monthly view — to see if there were any sharp changes during the past…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…to mention them separately. Running MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the heart of Linux operating system – which in principle will behave the same way… annoying at best. Resolving problems can easily lead to …
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…to use than Mini Computer systems from IBM. Directly attached storage is more simple to use than SAN, MySQL is more simple to use…way to complicated and outdated, plus it is not expressive enough for many modern application needs. I would expect solutions to…
Post: Beyond great cache hit ratio
May 19, 2010 By 2 Comments
… and caused MySQL queries. The hit ratio is 90%. Imagine now you have found a way to store the …to less than 10% but performance will likely be a lot better. The answer in many cases is to use… page views per user per day would really need to have items shared by multiple users to get best hit rate…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…view – system needs to process transactions and you want it to… users, database, the way users use the system but…every transaction which is best and easily achievable…MySQL Query Log. What is important is however to be able to connect the data from these logs – glue them together. The easy way to…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…to view the recording and my slides. Thanks to everyone who attended, and especially to… tolerance mode, but another way to design it would be … MySQL Proxy to assure stability, given that its intended use encourages developers to…was solely due to updating the session table. For best scalability, I…
Post: MySQL Community Needs
August 15, 2007 By 3 Comments
…view on recent MySQL Community Announcements. This however raises very interesting point what MySQL…used same way with MySQL – even if MySQL is used on Desktop by end users it is typically for development in which case you try to…
