June 20, 2013

Post: Working on "High Performance MySQL, Second Edition", how you can help?

… on the market… which is getting old though. We’ve been slowly working on the book for over … also did fair amount of MySQL Support and Consulting while working for MySQL so he can offer us another … so we would appreciate hearing your comments on it and what is the most important we would …

Comment: Where to get recent MySQL version ?

consulting company could gain a lot of fame (and customers) if it starts to provide “well made” binaries for free. Not much work I guess if you have the experience, but a lot of atreaction. If you don’t do it, you’ll be just one of many consulting firms, getting some plus work from MySQL’s bad-move, but this way, you could get

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

…and some observations that I’ve made while getting it configured. The second part will compare query results… simply to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to performance …I will get back the same results; if this equivalence doesn’t hold, then as a consultant, I…

Post: Site was down today, support and web hosting.

… offended customers. In our Consulting Work we also follow the same principle – if customer requests second opinion he always gets it. So what is the best way to deal with clueless support stuff working for big companies/big… being cheap. Well it is true I’m trying to get good value at good price, and it really works in most cases. I…

Post: Are you designing IO bound or CPU bound application ?

… but it is extremely important for MySQL Performance Optimization. In fact I probably have to touch it in every second MySQL Consulting work or even more frequently. IO Bound workload is quite different from CPU bound one, which happens when your working set… sharp performance drop and complex changes may be required to get your application back to speed. The cases when going from…

Post: Database problems in MySQL/PHP Applications

… things about objects is you can easily overload methods and get debugging and profiling tools, as well as have tools which… little work and formating, so database connection may become the issue. Caching should be good help in this case though. About Consultingit is worth to mention it was my group which was Dell DVD Store…

Post: Testing STEC SSD MACH16 200GB SLC

… latency though, as it appears there is no a reliable way in the Linux asynchronous IO library to get time metrics for… I have very good experience with this card, and it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks… the webinar. Disclaimer: This benchmark is done as part of consulting work for STEC, but this post is totally independent and fully…

Post: Gathering queries from a server with Maatkit and tcpdump

…installed, and copy it to another machine for analysis, or send it via email to your friendly consultant, or do … the profile synopsis so you can see how it works. sudo tcpdump -i lo port 3306 -s 65535 -x… summary profile here to illustrate that you can get really compact results to see what’s going …

Post: Detailed review of Tokutek storage engine

…Review was done as part of our consulting practice, but is totally independent and fully reflects our …only SELECT queries. What this practically means it that you can’t get benefit of multi-core boxes running …6.0, but I can’t yet say how it will work with mix of storage engines. – The Tokutek …

Post: How to estimate time it takes Innodb to Recover ?

… ups quite frequently in Innodb talks and during consulting engagements. It is well known to get better performance you should normally set innodb_log_file_size large. We however usually recommend caution as it may… time you better to understand how Innodb recovery works. When Innodb recovers from logs it finds the last checkpoint time. Innodb has…