Percona's MySQL & InnoDB performance and scalability blog
… the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one … database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql … separate ALTER statements, and it appears to work fine. But here’s where things start to get …
…a probability as long as you write to the database. They may be rate but it is rather hard…two things about defaults for Innodb. First Depending on MySQL version they may be somewhere from suboptimal to …file_size. There are a lot more options for fine tuning but make sure at least these are right…
…was popularizing an offsite delivery model for database architecture, consulting and infrastructure management before anyone… of delivery model requires a lot of fine-tuning to work well, which I’m … (while not everyone knows Augusto, he led MySQL infrastructure for Brazil’s most heavily trafficked…
One of our MySQL 5.5 installation runs on a single PC. There are …_size should I keep? What other parameters to fine tune? Is there any MySQL database profiling tool through which it is possible to monitor…
… also typical in most systems such as database servers. As a result, completion times … a bit longer. This is common in MySQL servers I work with when they’… some “static”, sort of like de-tuning the radio just a little bit (…, and as you slice it more finely, you see jagged edges. Most servers have…
… buying new hardware or making significant changes to database architecture is needed). What Percona can’t …to go asking around, sometimes guess. That’s fine though, just keep a record of the …moving to better hardware, optimizing indexes or queries, tuning MySQL etc. which we can offload 80-90% from…
…’m using PHP 5.1.6, MySQL 5.0.24a default installs from…the commit() occurs. I thought the database would rollback – but instead it remains… rollback(). This seems to work fine. public function begin_transaction() { $ret = self::$… that’s standard (I haven’t tuned anything). So your script could loop…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.