… + spares + OS partition mirror) and I limited the ARC size to 4GB. … be more zealous. Pretty interesting to speed up point in time recovery when…the task. Snapshots work best with InnoDB, with MyISAM you’ll have to… is a very interesting solution for MySQL backup servers. All backup solutions have…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… third one features even higher QPI speed (and thus, faster inter-process/node communication…some data updates into the mix, limitations of read-only transactions become obvious…. –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… are, both in terms of size and spindle speed. I need to know how many physical spindles … that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The … the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide …
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… if InnoDB cannot log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log. You can request that InnoDB force its REDO…, Percona Server with XtraDB allows much larger logs beyond the InnoDB limit of 4G. As a side effect of logging there is…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…for MySQL – Innodb. Innodb Storage Engine was covered in a lot of talks, many of them done by Innodb users… larger than table itself) The index build speed is however not only reason I can’…Innodb is being blamed for a lot of “Gotches” while many of them come from MySQL limits at the time when Innodb…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…, will the index have any impact on the speed of the query? A: If you extend the …table in recent MySQL versions. However it is often too many. Instead of thinking about hard limit of indexes …for “order by desc” indicates a double linked list. Innodb has double linked list – each leaf page contains …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… run MySQL with innodb_flush_method=O_DIRECT in most cases – it… double buffering and I can save the limited amount of file system cache I would … Processors | physical = 1, cores = 2, virtual = 2, hyperthreading = no Speeds | 2×1200.000 Models | 2xIntel(R) Pentium(R) …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb_buffer…tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed …write transactions. innodb_thread_concurrency=8 Even with current Innodb Scalability Fixes having limited concurrency …
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with… could just restart MySQL but this would make replication to be delayed few more hours because of the time Innodb takes to…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances …MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited…at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support …
