…ib_log* files; I know that innodb writes files in the log file group in… There have been several MySQL bugs opened about multi-core scalability (concurrent queries, … whole table, it may last way too long for your 150 GB table… keep tables small enough, “sharding” to many tables before they become so …
Page: Presentations
May 3, 2006 By
… systems, file systems etc. Large number of benchmarks with little explanations on the slides. Explanations were just spoken. In many cases results… time. Does not have too much meat about MySQL Performance. Download MySQL and PHP for Web Applications Open Source Revolution 2002, Stockholm…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… the file was open(2)ed with O_APPEND, the file offset is first set to the end of the file …revision) – this will probably build fine against 5.5 too, but I haven’t tested. To build it …atomic<> implementation. My solution to log file rotation is to basically count how many people may be using it …
Comment: Opening Tables scalability
March 20, 2007 By 27 Comments
… in “show processlist” is “opening tables”. We have many php and system tweaks but…subdirectories in one directory. Reiserfs supports too, but it’s terribly unstable within…many tables into one database – this cause worse performance problems – like hosting >10 000 000 files in one directory (3 files…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… replication system have been reused many times (including for two of … general, percona.zz gendata file. This file is used by the randgen to…= [["--innodb-dict-size-limit=200k --table-open-cache=10"]] Granted, these are …, schemas, and –parallel threads. Not too shabby for about 30 minutes of …
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…issue – storage engine which is specified in .frm file is not available and give user friendly error …another example. So Innodb has limit of 1023 open transactions which perform writes. I’m not …slot for an undo log. Do you have too InnoDB: many active transactions running concurrently? I hope with…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…a client who has MyISAM tables with many columns (the same one Peter wrote about …give Infobright a try. They have an open-source community edition, which is crippled but…it. You can talk XQuery to it, too. I’m not sure if you …hour, I believe it uses memory-mapped files to hold the data in-memory. If…
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 12, 2010 By 48 Comments
…of open MySQL bug reports, and I even contributed a fix to a serious replication bug in MySQL too. I… implies that there should be a lot of bugs filed on a database product and a large number …release change list. Given that every database release includes many bug fixes, I tend to look at the number…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
…getting too much people feedback on what would… would be hard to prepare so many good presentations if they are so…different CPUs, Operation systems, RAID Configuration, File Systems to assist you with your… We’re looking at performance at Open Source Transactional Storage engine MySQL – Innodb, Falcon…
