June 19, 2013

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

… probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction… benchmark does not require these properties and so they are tuned away…. though I bet the over vendors do the same thing of tuning database options for benchmark rather than running production reasonable options…

Filed Under: Benchmarks

Comment: The ultimate tool for generating optimal my.cnf files for MySQL

August 21, 2008 By 34 Comments

… think there is a difference between “better than default my.cnf” and “optimal my.cnf” – It is indeed possible to automate things, often by… values, to get configuration which will be better than default my.cnf in 99% cases. However it is not possible to get… config file automatically. This is in particularly so because during tuning there are many questions which human needs to answer. For…

Filed Under: Insight for DBAs Tagged With: ,

Comment: When is it a time to upgrade memory ?

December 9, 2009 By 11 Comments

… am doing some tuning reading articles like this one (by the way this website is awesome). Well I think my server can… the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql… default-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file…

Filed Under: Insight for DBAs Tagged With:

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

… not ‘pc.bootstrap=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post or webinar recording…’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may want…’t store or serve data. Q: Is the configuration file my.cnf ? A: Yes. Q: If the cluster blocks write while it…

Filed Under: MySQL, XtraDB Cluster

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

February 26, 2013 By 1 Comment

… 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll explain below) – the… people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the case… initial states, run some queries, and compare the output. Stay tuned, it gets rather curious.

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

Comment: Why you should ignore MySQL's key cache hit ratio

March 1, 2010 By 28 Comments

Patrick, can you substantiate that assertion more? In my experience, “tuning by ratio” leads to wildly stupid results that consume large … of such “tuning,” I’d say most of those people would’ve been better off not touching their default my.cnf at all… better result, so I’d say in 80% of cases, tuning by ratio is pure FAIL. Actually I’d say more…

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

Comment: How Percona does a MySQL Performance Audit

November 25, 2008 By 17 Comments

… problem seems to be that we’ve done all the tuning (perhaps even provided a bandaid as such), and so no… changes are made, the only “breathing room” came from the tuning. Then, the wall of scability is hit again, loads go… ssd and dedicated appliances) hardware you can buy, an already tuned infrastructure (my.cnf, hardware, kernel patches, the works), and still doesn’t…

Filed Under: Insight for Developers Tagged With:

Comment: The ultimate tool for generating optimal my.cnf files for MySQL

August 28, 2008 By 34 Comments

… understanding that the suggestions they provide are simply that; suggestions. tuning-primer.sh is a very nice little script which does help less inexperienced DBAs get started with tuning. I would argue that a lot of installations will fare… a few of the suggestions than sticking with the distributed my.cnf.. Denis

Filed Under: Insight for DBAs Tagged With: ,

Comment: Is MySQL 5.6 slower than MySQL 5.5?

February 18, 2013 By 23 Comments

… in their default settings. I did not do anything to tune performance schema comparing it out of the box. when I… “skip-performance-schema” to my.cnf I think you guys in development team grossly overestimate how much tuning the general user is going…_5_6_10/data/msandbox.log # # additional options passed through ‘my_clause’ # log-error=msandbox.err #skip-performance-schema

Filed Under: MySQL Tagged With: , , ,

Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2

May 3, 2011 By 13 Comments

… scripts and results are on Benchmark Wiki and the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file… very experimental and is likely to receive a lot of tuning in the future. In fact, as of the time of… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I…

Filed Under: MySQL
« Older Posts
Newer Posts »