June 19, 2013

Post: Open Source, the MySQL market (and TokuDB in particular)

… to avoid being locked in to one product. For example, I believe there is no way a closed-source software product will ever be deployed in a Facebook data center. No service provider lock-in. Customers should be… Open Source, by itself, is by no means enough to have a successful business. There are two examples: First, the PBXT storage…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

…. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing … feature has been optimized to make sure no additional work is done when userstat is disabled…. Bugs can be reported on the launchpad bug tracker. UPDATE[18-04-2013]: There was a …

Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2

… glibc) this will notably slowdown MySQL-transaction creation and many threads will get …and then creates requested block(s) there. That optimization helps to avoid … and in some cases can be the reason for notable MySQL performance… and such we have almost no difference in results between runs …

Comment: Open Source, the MySQL market (and TokuDB in particular)

… ratio of paying customers to be in business. The competition also matters – for many market areas there are no good open source software so people use proprietary licensed software as there is no choice. I think… and unless you get to the large data sets you will not see large benefits. The Cloud might change a lot…

Post: Is your MySQL buffer pool warm? Make it sweat!

be at the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there… option via –dispatcher-plugin-thread-pool that will allow connection reuse. This is necessary when … that match no rows or insert statements that have duplicate key errors may be faster than …

Post: Percona Server for MySQL 5.5.30-30.2 now available

…. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing … feature has been optimized to make sure no additional work is done when userstat is disabled…. Bugs can be reported on the launchpad bug tracker. UPDATE[18-04-2013]: There was a …

Post: High-load problems? Investigate them with 'pt-query-digest'

… of diagnostics information to review even if we couldn’t be logged in to the server at the time the problem… per line, and it will do it’s aggregation job on that. Granted, this means there is no run time data available, but… started, there are good recorded webinars on the subject, and the upcoming Percona Live conference’s tutorials and sessions will include a…

Comment: Open Source, the MySQL market (and TokuDB in particular)

…. The exception might be for something that is truely and totally a standard with no custom extensions. I’…types where the first thing they ask is – “Is there a way we can do that for free?” … source stuff – say subscribing to RHEL. Your money will go towards supporting a significant number of open …

Post: What I'm looking forward to at Percona Live (MySQL Users Conference)

…me it does not get tiring. So what is there in this conference for me as an attendee, …who all share their deep technical insights, holding back no secrets. Reconnect with Old Friends. Over the years …I might be going too deep. This year in addition to my Keynote and Panel sessions I will give an…

Post: MySQL and Percona Server in LinkBench benchmark

… to setup and run this benchmark, can be found here. We decided to run this….5.30 and check how these servers will handle such OLTP workloads in the CPU… CPU-bound case. As you can see there is a very slight difference between servers… to 8k,16k,32k but that had no notably impact on result. In the best…