… plugin that monitors the names and number of active cluster nodes in order to …[MAIN ] parse error in config: Can’t open logfile ‘/var/log/corosync.log’ for reason:…_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… of that post makes a connection between a free account in a cloud-based service and Open … their products on a closed-source version of MySQL… and you know their fate – sold for… not reach a sustainable number of customers. As for TokuDB: after its Open Source announcement, as anecdotal evidence…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of… scan in read_view_open_now() which …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Kravchuk, we have received a large number of questions on why the benchmark results … 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=…–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL… = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…. I recently had to work with many customers having large number of connections opened in MySQL and although I told them this was not optimal… number of idle connections was varied from 0 to 1500. I was expecting an influence, because those idle threads are presents in internal MySQL…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…of connections which is rather unrelated to number of connections. You can get 1000s of connections a second even from as little as 100 connections, hence max_connections…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does not make much difference. Systems with high number of connections/sec will still need to increase it much further. open_files_limit is 5000 by default…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…). This post is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple… large number of application servers can lead to a situation where the database server has a very large number of connections open to it, most of which…
