June 20, 2013

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

August 31, 2007 By 20 Comments

… 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 …

Filed Under: Events and Announcements Tagged With:

Comment: Where to get recent MySQL version ?

January 1, 2007 By 86 Comments

… 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…

Filed Under: Insight for DBAs Tagged With:

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

February 26, 2013 By 1 Comment

…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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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

August 31, 2007 By 27 Comments

… 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…

Filed Under: Events and Announcements Tagged With:

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

December 20, 2006 By 10 Comments

… 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…

Filed Under: Insight for Developers Tagged With:

Post: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

… 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 Consulting – it is worth to mention it was my group which was Dell DVD Store…

Filed Under: Insight for Developers Tagged With: , ,

Post: Testing STEC SSD MACH16 200GB SLC

April 25, 2012 By 9 Comments

… 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…

Filed Under: Benchmarks, Hardware and Storage, MySQL

Post: Gathering queries from a server with Maatkit and tcpdump

July 1, 2009 By 23 Comments

…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 …

Filed Under: Insight for DBAs Tagged With:

Post: Detailed review of Tokutek storage engine

April 28, 2009 By 21 Comments

…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 …

Filed Under: Uncategorized Tagged With:

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

May 9, 2007 By 7 Comments

… 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…

Filed Under: Insight for DBAs Tagged With:
« Older Posts
Newer Posts »