… distribution’s repository instead of Percona’s which could lead…the log reads needlessly, potentially limiting performance on write-intensive workloads. …result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL… very rare circumstances, deleting a zero-size bitmap file at the …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of…log reads needlessly, potentially limiting performance on write-intensive workloads…to indicate an incomplete result set. Bug fixed #1185040. … around 500KB tablespace size. Bug fixed #1169494. Fixed…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_…the result of some brief performance issue on a given node, or perhaps the effect of some… the cost of certification depends only the size of the transactions, which translates into number of unique key…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…limits. I think the results…of the work, due to the multiple levels of result set reduction. Finally, Shard-Query can automatically partition sets…of compute resource which speaks SQL, but right now only MySQL…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…size variable which allows you to limit size of MEMORY tables (the limit… | 126984 | +——————————-+ 1 row in set … result…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… in the right way. But vanilla MySQL does have its limitations, it reports only a subset of stats, however if you compare that… used by MySQL. The end result might be that you end up limiting the number of results returned by the query, by using a LIMIT clause… tmp_tbl_size variable is set to 32M on the server, so on-disk tables are probably being created because of blob columns…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results…of connections/sec will still need to increase it much further. open_files_limit…size of 1MB while in MySQL 5.5 and before it was “ON” by default with query cache size of…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… sure it handles large data sets as part of the process we work on generation test database of significant size as testing your application… memory_limit PHP config variable because that only controls memory which passes via PHP memory management which does not apply to MySQL result set…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…of your application, otherwise garbage-in, garbage-out and you risk dropping necessary indexes. To accomplish merging multiple result sets…see my indexes: mysql> select * from all_indexes limit 1 \G *************************** 1. row … to the reader. 
Estimating the size of these indexes But, what …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… engines. Lets start with a bit of history. When MySQL was just written there was not …size). Other storage engines such as Innodb to not use this variable. sort_buffer_size Buffer used to sort result set…to on disk MyISAM table. It does not limit size of temporary table, neither it applies to tables …
