… on its input to complete. Parallelism is embarrassing and the maximum degree of parallelism is easily enforced with queue. Today I… cores are connected to my bus, and because I chose to create six hash “buckets” in the table. This allows MySQL to… this set has a cardinality of 3088896. This is the maximum theoretical degree of parallelism that this data set can achieve…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…it in the end of the post) which connects to one node in the cluster, performs …to pretty significant load. sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –num-threads…in this case both in average and the Maximum one. This tells me from data propagation …
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
…Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2…in amount of internal and external hard drive connections they provide. Some Newer Adaptec Controllers also offer…0/0 SSDs assigned to MaxIQ Cache pool : 0 Maximum SSDs allowed in MaxIQ Cache pool : 8 …
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… to connect to the current master. With EC2, you can’t do this. There’s no customization of the memory. The maximum…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… past 2M but still a bit too big for the maximum possible speed for OLTP that tends to involve lots of… or using connection settings if that’s not possible. More on this at https://blogs.oracle.com/supportingmysql/entry/mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based on max_connections, just to…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout = 60 …of connections and so remains for a few minutes, but then so sopresiva connections to the database increases reaching the maximum of connections and…
Post: 5.0.75-build12 Percona binaries
January 23, 2009 By 18 Comments
…the insert buffer until the insert buffer reaches its maximum size. 1 makes the each user threads positive to… visible only on new established connection, which is problem if you have pre-established connection pool, say in Java or… and sources with patches here http://www.percona.com/mysql/5.0.75-b12…
Comment: Wishes for new "Pure PHP" MySQL driver
October 30, 2006 By 17 Comments
… PHP/MySQL world that persistent connections were a bad thing. I would think with appropriate limits on the maximum number of persistent connections, Apache itself would essentially act as a connection-pooling daemon. Am I totally…
Comment: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
You can limit the number of maximum concurrent connections to mysql server and proactively kill idle connections with HAProxy, check this : http://flavio.tordini.org/a-more-stable-mysql-with-haproxy/comment-page-1
Post: How Web Services world affect LAMP Stack
May 22, 2006 By 1 Comment
… Web services might get slower themselves or network connectivity to them might slow things down so … thus avoid having each page generated with maximum allowed response time. Graceful failure. Web services … cache data on Disk – in files or MySQL tables. There are multiple solutions available out …
