…: memlock already works – it is global MySQL Server option, though it may have problems on Linux if you lock very large portion… InnoDB log flush with a mutex in 5.1, to implement XA, and switching off the XA will not remove that serialization. MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… writes to the first file in the log file group and the SSD dynamic wear leveling…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql… also on the OS version. In our tests, removing one bottleneck moves the contention to another place….
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
…the problem disappeared!” “Also writing the redo logs, binary logs, data files in different physical disks is … scheduler is not the default schedualer of linux but was recommended for ext4. If they …it would remove this problem? Including/improving some sort of cache to disk not ram for mysql …
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… /data/vadim/mysql/export//tpcc/order_line.ibd >> log scanned up to (3 770393658) … >> log scanned up to…5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql/export/ xtrabackup: This …ENGINE=InnoDB DEFAULT CHARSET=latin1 Next step is to remove created .ibd file, it’s done by command…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 84 Comments
… seconds, remove duplicates and save result to file php mysql_filter_slow_log.php -T=3 -eu=root –no-duplicates mysql-slow-queries.log # Start… users root and test tail -f -n 0 linux-slow.log | python mysql_filter_slow_log.py -T=3 -R=10000 -eu=root -eu… permanent filtering kill `ps auxww | grep ‘tail -f -n 0 linux-slow.log‘ | egrep -v grep | awk ‘{print 2}’`
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… see some examples: [root@DB01 mysql]# du -h ib_log* 257M ib_logfile0 257M ib_logfile1 [root@DB01 mysql]# perl /tmp/fincore –justsummarize…, perhaps second log file is being written now and there is a “tail” of pages which just were not removed from the… IO to log files on Linux because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… -9 is run. Our mysql db contains a mix of innodb and myism tables and run on linux with 16gigs or ram. Here is our my.cnf # sammple MySQL config file for very large…_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…53-12.4 is based on MySQL 5.1.53. Â New Features …log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev) Bug #673567 – Compiler could produce spurious warnings when building on non_Linux…libmysqlclient16 and percona-server-common was removed. (Aleksandr Kuzminsky) Bug #693415 – The test…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… status to be periodically printed into MySQL error log. You can later disable logging by simply dropping the table….file system. However on many systems such as Linux or Solaris, but possibly also others, there is…but not-yet-closed files (file is physically removed only after it is no longer open by…
