…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=16384 I got about same crash recovery speed though with no warnings. So it looks like innodb_open_files_limit…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal…_method=O_DIRECT innodb_flush_log_at_trx_commit=0 max_connections = 10000 open_files_limit = 32768 The desktop is running Ubuntu 10.04… in `seq 0 4` do numconn=$((i*20)) echo “Doing $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…limiting factor for this system quite soon, so I decided to check what is limiting MySQL…MySQL but this would make replication to be delayed few more hours because of the time Innodb takes to open…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Max_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_free… softirq iowait idle total 15.0% 0.0% 9.5% 0.0% 0.3% 6.5% 68.4% cpu00 22.1% 0.0% 11.1% 0.1% 1.1% 6…=/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…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
… writes to 1MB file using SysBench on Ubuntu, ext4 running on VirtualBox 4.0.4 running on Windows… of threads: 1 Extra file open flags: 0 1 files, 1Mb each 1Mb total file size Block size …write test Threads started! Time limit exceeded, exiting… Done. Operations performed: 0 Read, 33900 Write, 339 …
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5.0 XA …files or .frm being unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4…from _table_ limit 1 for each table or any other statement – it is table open which is important…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…1 siblings : 4 core id : 3 cpu cores : 4 fpu : yes …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852 26909 0… The stock MySQL server’s limitation of …openings in chess — the great chess players study openings…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…place, we can begin. Open command line (shell) …mysql-5.0.51a) % patch -p1 < ../patch-mysql-5.0.51a-msl.diff patching file include/my_time.h patching file scripts/mysqldumpslow.sh patching file… –param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘CXX=…log_slow_rate_limit=# Rate limit statement writes to …
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… important for MySQL. To prepare small 128MB single file working…4.8: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Extra file open flags: 16384 1 files…Time limit exceeded, exiting… Done. Operations performed: 773835 Read, 0 Write, 0 Other …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… after issuing LOAD DATA on 180MB file ( for 1989 year, 1st month) very… Year, Month); ERROR 122 (HY000): Cannot open table handle for ontime. As warning… ORDER BY c DESC LIMIT 10; 4.96 sec Query Q4: mysql> SELECT Carrier, count(*)….1.39-community InfiniDB Community Edition 0.9.4.0-5-alpha (GPL), so I…
