… 1.1.8-x which is not 100% compatible with 1.1.7-x see this…distribution update, I prefer to use CMAN as recommended. First as we have 2 nodes of 3…establish cib_ro connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running:…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot…’ve been recommending for a while. innodb_stats_on_metadata = off Yet another change I actively recommended max_connect_errors = 100 10 or 100 does not make much difference if you get some sporadic network errors both can give problems. I would recommend…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… problem, also benefit from persistent connections can be much more modest. … background. Things are different with MySQL. There are many successful applications, … catch. It is very traditional recommendation to normalize your data however …would rather use IN() than do 100 of queries in this case. …
Post: Percona Toolkit by example - pt-stalk
January 3, 2013 By 3 Comments
… in all examples, so I recommend you to read the documentation…7, because problems such as MySQL lockups or spikes of activity… more than 10 (–threshold 10) connections opened. You can use any …more than 100 (–threshold 100) $ pt-stalk –function ./pt-stalk-function \ –threshold 100 — –defaults…
Comment: Database problems in MySQL/PHP Applications
August 14, 2006 By 13 Comments
… do many thousands of queries per second from single connection. From multiple connections it will be many tens of thousands per second… is getting so popular or MySQL Cluster can exist. Now you probably do not want to do 100 of the queries instead of one. Please take a close look at my recommendation I recommend using 2-3 queries when MySQL…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, … Idle connections for example will consume significantly less memory than connections doing…but if you’re doing 100+ pages per second of swap… work better than 70-80% recommendation and of course you should…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… char(5) DEFAULT NULL, `OriginCityName` varchar(100) DEFAULT NULL, `OriginState` char(2) DEFAULT…that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD… sense count of direct connected cities for different diapason of years… (5-Oct-2009): James Birchall recommended to use hint COMMENT ‘lookup…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…bits physical, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1… with 100 Warehouses (about 9.5GB datasize). The result is: Here the result grows up to 16 connections,…per box is not something rare already and recommendation to fit at least active dataset in memory…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…performance problem, also benefit from persistent > connections can be much more modest. …background. > Things are different with MySQL. Good design will help …catch. It > is very traditional recommendation to normalize your data however it… would rather use IN() than do 100 of queries in this case. …
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
… value (e.g. 0) is not recommended for performance. If you don’t… performance.) * innodb_ibuf_accel_rate (default 100(%)) – This parameter is additional tuning the… new established connection, which is problem if you have pre-established connection pool, say… patches here http://www.percona.com/mysql/5…
