June 19, 2013

Comment: Percona build7 with latest patches

Dim, To provide optimal my.cnf we should know your workload and server characteristics. And what is much worse – can you show some numbers ?

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

Apachez: “The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many …

Post: How Percona does a MySQL Performance Audit

… than my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimization…/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way to… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without…

Post: Profiling MySQL Memory Usage With Valgrind Massif

… user mysqld will now run under (check ‘user’ setting in my.cnf also) (see here if this is not clear) Now, before… (downloaded ‘GA’ [generally available] packages may contain optimized or stripped binaries, which are optimized for speed rather than debugging). If the binaries…}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld…

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

… likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that … +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1028261 | | last_optimized_word | | | deleted_doc_count | 0 | | total_word_count | | | optimize_start_time | | | optimize

Post: Review of MySQL 5.6 Defaults Changes

… are any specific benchmarks which point to this as an optimal value or is it just looking to reduce number of… also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring to amounts of memory we have in the phones these days, I made in my Optimizing

Comment: Why MySQL could be slow with large tables ?

I need to optimize mysql server to manage a big tables (now about 78Mb, … change mysql vars and restart server, my configs are not applied, defautl mysql applied, and my.cnf are not modified. Why? Where are… best performance?) – what parameters i need to insert manually in my.cnf for best performance & low disk usage? – may i remove old…

Post: Heikki Tuuri answers to Innodb questions, Part II

… dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible… difficult to figure our what the problem is. We can OPTIMIZE the table, but how long will this take? Is there… any table / index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it may last way too…

Post: Why not make a tool to improve existing configurations?

… have submitted feedback such as “I’d love to input my existing server settings and get suggestions on how to improve…. Every approach we considered carried a high risk of de-optimizing a server so it performs worse than before. So in… tool is excellent for creating a starting my.cnf, my old blog post about the ultimate my.cnf tuner tool, which claims that an expert…

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

… buffer hit or miss takes. If you approach application performance optimization from the standpoint of response time measurements, which you should… causes people to mistake counter analysis for a true performance optimization method. I’ve shown that if we make some assumptions… shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite, mathematical…