…to keep open file descriptor when table is open – open table is purely logical state and appropriate .ibd file may be open or closed. Furthermore besides MySQL…open_files_limit=300 is not being that large liability even with large number of tables and you can also safely increase…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
…mysql” user, those limits will not be honored because of the existence of this file. If you actually want to increase the thread/process limit…limits | egrep “(processes|files)” Max processes 22888 22888 processes Max open files 6000 6000 files But let’s say that a new version of MySQL…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…/loop0 985M 961M 0 100% /tmp Lets see which files has MySQL opened: # lsof -p 6112|grep ML mysqld 6112…, the best solution is to monitor your system. If your tmp partition is limited you should check the…a very good option to know how and when the size of your temporary tables increases. We have our…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…how do you determine the memory consumption per connection in average? This leads to the next question c. Can we have a limit…mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit…_size=10M # Might be increased thread_cache_size=40 …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to very significant ones. Also do not forget you may need to increase size of your Innodb log files to be able to…have been several MySQL bugs opened about multi…to quantify what are the limits of different operations for different levels of concurrency, specifically around mutexes and contention? How…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… how to use this info to improve MySQL Performance. To… need to look at the log files to find…to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to… you may want to increase it. You …how many threads are waiting and being active. How many read views are open…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 18 Comments
…only one) to demonstrate how much improvement could be made to MySQL so …open source. In the future, Shard-Query can be extended to…queries in a file (or stdin) and a config file. It…t see any advantage after increasing the number of workers past… Origin ORDER BY c DESC LIMIT 10; Q4 – SELECT carrier, …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…Openings I like to ask them a … database directory to get more efficient backup. EXT3 file system…large blobs to Innodb in this case increase it a …Innodb Scalability Fixes having limited concurrency helps. The … and even more to come with MySQL 5.1 and … like to review your table structure and see how …
