… to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal… innodb_flush_log_at_trx_commit=0 max_connections = 10000 open_files_limit = 32768 The desktop is running Ubuntu 10.04, has 8GB… benchmarks, the CPU load on the laptop was never above 10%. I also hacked a bit the “run_mysql.sh” script to…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_names=1 general_log = ON max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128 … 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> …
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
… mysqld`/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… MySQL (Percona Server).. SUCCESS! [~] (root@revolution 23:59:45)# cat /proc/`pidof mysqld`/limits | egrep “(processes|files)” Max processes 1024 unlimited processes Max open files… to modify these resource limits on the fly, without a MySQL server restart…. As it turns out, we do. On kernel 2.6.32…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security …limit on undo segment size. Another possibility is to use queries which use large temporary tables or sort files…are implemented as temporary tables, so by opening large amount of cursors which are …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… have something like 1000+ db connections since every user clicks on a link, refreshes his/her browser every 10 secs or…_used_connections’, ’651′ ‘Not_flushed_delayed_rows’, ’0′ ‘Open_files‘, ’95′ ‘Open_streams’, ’0′ ‘Open_tables’, ’512′ ‘Opened_tables’, ’183240′ ‘Qcache_free_blocks’, ’136′ ‘Qcache…=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144…
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
… posted a comment on http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/ asking about open_file_limit. One thing …”open files“, mysql setting “open_file_limit” affects the OS/MySQL and I believe is non-biased to MyISAM and InnoDB table types. If the max open_file_limit is…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit… master – required #master-password = # # The port the master is listening on. # optional – defaults to 3306 #master-port = # # binary logging – not required…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… [...] /dev/loop0 985M 961M 0 100% /tmp Lets see which files has MySQL opened: # lsof -p 6112|grep ML mysqld 6112 root 38u… system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are not visible on the EXPLAIN or SHOW STATUS… your system. If your tmp partition is limited you should check the free space on it with a monitoring system like Nagios…
Comment: Why MySQL could be slow with large tables ?
June 21, 2006 By 141 Comments
… kept open permanently which can waste a lot of memory but it is other problem. Speaking about “open_file_limit” which limits number of files MySQL can use at the same time – on modern operation systems it is safe…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL…XtraDB used to print the open read view list … innodb_changed_pages_limit. MySQL option handling would … were caused by missing files. Bug fixed #1099809 (Alexey …
