… also a 2 second minimum for the query to get written, that is when you set long_query_time=1. After applying the patch…’ (…) From that output you can learn how to run configure command, which needs to be done prior to compiling the sources. It should be… than long_query_time microseconds to execute to file. This option is standard MySQL, however after you apply the patch, it will no longer…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…memory in some edge cases. Percona patches though provide innodb_dict_size_limit to restrict growth of data dictionary. …files and applying logs took about 9 minutes in this setup. This number of course can change a lot …open files in the list. I guess Heikki knows how to implement LRU in the end 
…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…these are merging a lot these days). From my standpoint the question is when or how to use MySQL not … MySQL differently and if you’re try to apply same patterns to MySQL as you used for Oracle or …example Google still has a lot of stuff on MySQL 4.0… looking at the patches they designed themselves …
Comment: MySQL 5.5.8 and Percona Server: being adaptive
December 22, 2010 By 25 Comments
… not able to test ) I’ve get a look on LP – there are only patches, without any info what to do and how to apply them.. so…-mysql: there is no README either how to run it ) I may suppose that I have to compile tpcc_load and tpcc_start… params) – how do I run the test (exactly params) (when I think that you told me that dbSTRESS is hard to setup…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… tasked to fix are actually bugs in MySQL which the Oracle MySQL development team has not fixed. This does not only apply to “community reported bugs” as we had a number of customers who had an Oracle… Dev Team Augmentation – A number of companies maintain an in-house MySQL build which can include community patches from various sources as…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… of the ways to measure it: 1) Use “UserStats” functionality from Google patches, which is now…a lot on many things including how fast do you need to be able to recover from backups and how much your load variance is. A… hour worth of binary logs takes 2 hours to apply, your replication capacity is …
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…to be investigated Patching Slow Query Logging – First thing we did is created a Patch which allows you to… After this patch is applied your slow query log starts to look like this:…to execute, for example if plan is different based on constants. How to use this tool set ? First be aware this patch to…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
…to show the effects of the new patches applied to Percona HighPerf release. As you see from the following graphs, there is significant difference to…patches. Then, how the patches contribute to the improvements in this case. split_buf_pool_mutex_fixed_optimistic_safe.patch The patch…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… chosen over the fixed one, how to request it explicitly and how to set the data block size … this feature added. For that we run a few experiments, described next. These tests are …Fixed-row format (FRF, Percona Server without this patch applied): Insertions in 900 seconds: 25962452. VmPeak: 6267692 …
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
… I’m wondering how much the opposite applies as well – this would leave small companies to seek for other ways to get the service… to deal with needs of lower end customers. This especially applies to Professional Service Companies. Let me give you an example This shows how… we do a lot of work with performance analyzes and Scaling. Proven Scaling is well known for contributing SHOW PROFILE patch and…
