… it is not MySQL problem, might be even not problem with your MySQL configuration, queries and … writing to database. Introduce Throttling Sometimes even single process overloads system too much in this…. It also often helps with monopolizing replication thread. For example if I need to delete …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22… innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ##… with each instance of iiBench writing 200 million single row inserts, for a total of 1 billion …
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities, which also had a number of other limitations… be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the following…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… “single file” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1 thread: 87 MiB/sec ext4 4 threads… get: ext4 4 threads: 120 MiB/sec xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to… use value 2 or 4, to avoid scheduling overhead from single thread, but it does not seem critical. In conclusion ext4 looks…
Comment: PHP Sessions - Files vs Database Based
April 10, 2012 By 38 Comments
With suggested mysql backed memcached as session handler, there still exists problem with … mysql, but on using the $_SESSION that can be operated only as a single entity. It’s good for reliably locked simple single… split data on small enough fragments to reduce risk of threads overwriting each others data.
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…. I decided to write a series of blog posts on MySQL‘s unsolved severe limitations. I mean limitations that really hobble… wastefully compared to its potential. The first glaring problem is single-threaded replication. It is severe and getting much worse as servers… going to have to default to single-threaded as replication currently does, and only enable the multi-threaded behavior if the user configures…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all databases… OLTP web database too. MySQL replication is one of the core, fundamental features — and it’s single-threaded and relies on the binary…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… to be longer, because it has to happen in the single thread. In the worse case scenario you might be looking at…) are frequent cause of concern. Remember replication runs as a single thread and something which might not look like a lot of…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on… project, I thought it would be interesting to measure the single-threaded insert throughput as sysbench ran the “prepare” phase and filled… single-threaded insert workload is not very revealing. To understand the sustained write performance of an RDS instance, we need a multi-threaded…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… sensitive). I wonder how many of MySQL Users are running applications of these scale, for single MySQL Server ? Please comment if you do… I believe is ability of MySQL to use powerful system (including powerful storage) – Is quite limited with single thread replication as well as…) and as MySQL is making its way into Enterprise Developments I expect us to see more and more Large Single Instance developments…
