June 19, 2013

Post: The two even more fundamental performance metrics

… In other words, there will be a steady but variable “white noise” of incoming requests, and most requests …microseconds, maybe a bit longer. This is common in MySQL servers I work with when they’re running a …where we get some “static”, sort of like de-tuning the radio just a little bit (if you …

Post: Should we give a MySQL Query Cache a second chance ?

… also get query_cache_ttl as session variable, which is very helpful for connections …external script which can have application-specific tunings to prioritize which queries are more … is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources to…

Post: Configuring MySQL For High Number of Connections per Second

… size to allow MySQL to handle spikes. Although MySQL connections are quite… be refused. What back_log variable specifies is second parameter to listen… understand your application workload and tune specifically to your needs. This… and potentially connecting to different server, but that can be fixed…

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

MySQL 5.6 server, rebooted and verified again.  Same issue.  This was very different from MySQLmysql> select * from information_schema.global_status where variable_name like ‘%innodb%read%’; +—————————————+—————-+ | VARIABLE_NAME | VARIABLE

Post: Economics of Performance Optimization

… moving the application. On reasonably tuned applications when further tunings are expensive you may well upgrade …you would just need another server a bit later. However if you have 100 MySQL servers to deal with …As project moves to the higher end another variable comes into the play – even if your …

Post: Tuning for heavy writing workloads

tuning peak performance>. The next, <tuning purge operation> to stabilize performance  and to avoid decreasing performance. Server… using by the partitioning of MySQL. Added the following clause to the…. The current XtraDB has the variable to tune the contention. innodb_stats_update_…

Post: kernel_mutex problem. Or double throughput with single variable

…in MySQL 5.1 and MySQL 5.5 is known: Bug report. In fact in MySQL 5… the result for different threads (against Percona Server 5.5.17): Threads Throughput, q/s…variables that affects mutex loops: innodb_sync_spin_loops and innodb_spin_wait_delay. I actually think that tuning system with these variable

Post: How Innodb Contention may manifest itself

…becomes inefficient. Reducing innodb_sync_spin_loops variable to smaller values is known to help…while you’re upgrading to Percona Server or newer MySQL version or doing application/architecture changes…. adjusting innodb_thread_concurrency and doing other server tuning should be first on your list. I…

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to set innodb… comes back: mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_myisam_stopword’; ERROR 1231 (42000): Variable ‘innodb_ft_server_stopword_table’ can… sec) mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT…

Comment: What to tune in MySQL Server after installation

MySQL Performance Blog » What to tune in MySQL Server after installation Even though you can tune quite a lot of variables in MySQL Servers only few of them are really important for most common workload (tags: mysql performance database tuning