… of that post makes a connection between a free account in a cloud-based service and Open Source software. I think it… product. For example, I believe there is no way a closed-source software product will ever be deployed in a Facebook… and Kickfire, two companies that based their products on a closed-source version of MySQL… and you know their fate – sold…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…trx_list (i.e. the list of currently open transactions) and copies IDs of transactions that … optimization in Percona Server 5.5 is fairly close in terms of scalability, while the cost … provides stable throughput even at 4096 concurrent connections. So both the general “trx descriptors” optimization …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… hardware and dataset sizes, including the ones that are as close as possible to Dimitri’s environment. To put a long…, the more general descriptors optimization in Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server…_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… HDD-only setup, but it doesn’t even really come close to the numbers obtained with vCache. There may be ways… = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet…
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 30 Comments
… 4. apache connections start to wait on slow mysql queries 5. apache connections take longer to close 6. more apache connections are opened 7. with each apache request a new sleeping mysql connection is made… the time a mysql connection is open during script execution – don’t open a mysql connection in the header and close it in the footer…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… use persistent connections by default, so that a connection isn’t really closed when it’s closed; it’s kind of like a connection pool, except that the connection is persisted… really hard or impossible to avoid it. And with 5000 connections open, you get 5000 threads in the server. That increases the…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… application connects to the database using persistent connection technique to avoid creating new connections for every request so it just recycle old connections. The… the name ML*. Here is the problem. Until the connection is closed those files won’t disappear, even after committing the transaction… system that can help you avoid these situations. I’ve opened a bug report to follow this issue: http://bugs.mysql…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… of which might open a connection to MySQL server… this ends up with very high number of up to 10K connections and potentially…, which are quite likely to come from 1000 or more connections. This is when performance at High Concurrency is the difference… of MySQL Enterprise Edition with Thread Pool plugin remains very close to the peak. In practice this will mean one server…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK Note… with backup you can skip this step. 2) While holding connection open run: lvcreate -L16G -s -n dbbackup /dev/Main/Data – This… continue, which is done by running UNLOCK TABLES or simply closing connection. 5) Mount backup Filesystem: mount /dev/Main/dbbackup /mnt/backup…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…commanual connect_…Open_filesblogpercona.commanual open_files_limitblogpercona.commanual Open_streamsblogpercona.commanual Open_table_definitionsblogpercona.commanual Open_tablesblogpercona.commanual Opened_filesblogpercona.commanual Opened_table_definitionsblogpercona.commanual Opened…
