… of processes / threads available to the MySQL user, typically by adding a line like this to /etc/security/limits.conf: mysql soft nproc 4096… happened to the process/thread limit: (root@revolution 23:59:37)# service mysql restart Shutting down MySQL (Percona Server)… SUCCESS! Starting MySQL (Percona Server).. SUCCESS…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the …thread_cache_sizeblogpercona.commanual thread_concurrencyblogpercona.commanual thread_handlingblogpercona.commanual thread_stackblogpercona.commanual Threads_cachedblogpercona.commanual Threads_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…” limitations Postgres has overcome for specific use cases. I decided to write a series of blog posts on MySQL‘s unsolved severe limitations. I mean limitations that really hobble it for major, important… the replication events to the appropriate thread. A pool of threads on the replica, and a coordinating thread that hands work to each…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…dist/5.6.10 | | BACK_LOG | 50 | 80 | | OPEN_FILES_LIMIT | 1024 | 5000 | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_…SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread_concurrency. Our advice is: stop wasting your…/24/tuning-innodb-concurrency-tickets/ innodb_thread_concurrency places a limit on the number of threads that can be running inside InnoDB. The…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
…on operating system size to allow MySQL to handle spikes. Although MySQL connections are quite fast compared … which means even very short stall in main thread which is accepting connections will cause for …getting pretty close to what could be the limit and you should consider techniques to reduce …
Post: SimCity outages, traffic control and Thread Pool for MySQL
March 16, 2013 By 16 Comments
… Thread Pool for MySQL. We want to provide this kind of throughput: This is achieved by limiting the amount of working threads inside MySQL. So Thread Pool for MySQL…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… to build indexes in parallel by running sorts in different threads – using multiple cores becomes increasingly important as their number per… a lot of “Gotches” while many of them come from MySQL limits at the time when Innodb was first implemented. Many other… to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance such as multiple purge threads or…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though… a good idea. It also often helps with monopolizing replication thread. For example if I need to delete old data instead…
Post: Implementing Parallel Replication in MySQL
November 8, 2010 By 3 Comments
… considering implementing a limited form of parallel replication. Single-threaded replication is one of the most severe limitations in the MySQL server. We have… lift some of the restrictions. We will initially impose these limitations to keep things simple, and make sure we can actually…
