… s0 has crashed, and that s1 has not received all writes (and therefore s3 and s4 are also lagging behind). s2… broken. Scenario #3: The master has crashed before sending all writes If the binary logs of the master are no longer…-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? Unfortunately, there is no –start-gtid-position option…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… of production database servers and will perform the backups. The write load is not excessive so a single server can easily… snapshot, like LVM but… since it is a copy on write filesystem, the snapshots are free, no performance penalty. You can… to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…() directly instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under… hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect schema…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… /var/www/schemaspy/ The -o directive tells SchemaSpy where to write the output to, make sure this is a directory that… implicit constraints that you might have missed and can then write into your metadata file. Donate – This is free software and… SchemaSpy? Feel free to answer via the comments. Thanks for reading!
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… at Launchpad. New Features: Percona Server has ported the Atomic write support for Fusion-io devices patch from MariaDB. This feature… write support for directFS filesystem on Fusion-io devices. This feature implementation is considered BETA quality. Percona Server has introduced innodb_read…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… an empty LSN range and thus does not need to read any bitmap files. Bug fixed #1184427. Incorrect schema definition for… hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… 16KiB, these numbers equate to over 110,000 write IOPS and almost 205,000 read IOPS. When we switch over to synchronous… the asynchronous performance: Synchronous read reaches peak capacity somewhere between 32 and 64 threads, and synchronous write tops out somewhere between 64… with MySQL? Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but overall…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, the server is reading a lot (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing… to 20 on a 48GB server, allowing nearly 10GB of “write cache”. A quick survey of the servers I have access…. I simply set the dirty_ratio to 2 (1GB of write cache) and the issue is gone since. So, add to…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… Simply speaking: flow control makes replication stop, and therefore makes writes (which are synchronous) stop, on all nodes until flow control… the cluster might have applying cluster transactions. Therefore, it keeps reads more up to date without needing to use wsrep_causal… nodes will be the slaves with no writes coming from them. However, with multi-node writing, larger queues will make certification more…
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
…” mode (maxperformance reserves some additional space internally to provide better write performance). In “maxcapacity” mode, the device tested provides approximately 2200GB…%. Finally, we take a look at synchronous random read. At 256 threads, read throughput tops out at 2090MiB/sec, which is about…
