… post by Konstantin Osipov we should finally get Query Cache working with prepared statements in MySQL 5.1 The interesting thing Konstantin notes… query cache or no prepared statements with it. Would this make me use/advice Query Cache more ? Not really. There are enough of over limits with Query Cache which makes it best for small…
Post: MySQL Query Cache and prepared statements - support comming ?
March 15, 2007 By Leave a Comment
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… allocated for Innodb Buffer Pool or Query Cache but amount of memory used for example for Table Cache can be only guessed. Not… addition to monitoring it which I’m sure hosting providers, MySQL as a Service vendors will especially appreciate as currently they… able to limit memory usage by individual MySQL users or even track how much these users are using. Now as MySQL 5.6…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…a sharp memory increase after executing a particular query. Or, maybe mysqld is seemingly using too … If you self compile, and those Valgrind-internal limits are still too small, you can easily …event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql-5.5…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… query_cache_limit = 10M open_files_limit = 8088 back_log=128 max_allowed_packet = 50M # performance sort_buffer_size = 8M read_buffer_size = 2M query…open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table_size=128M
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… As MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional. The limits which exist are not really helpful as they do not define query complexity… overload IO system and wipe off both MySQL and OS caches which can cause other users queries to perform order of magnitude slower…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…, query_cache_size. If you’re using MyISAM seriously you can also add the size of Operation System cache you would like MySQL to… for OS, File Cache and other applications. For 32bit envinronment you also should keep 32bit limits into account and probably limit “mysqld” size… values to run some queries. There can be mutiple key caches. Multiple key caches can be created to accomodate query executions Query Parsing and optimization…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…=100000 COUNT=0 while [ "$NUMROW" -gt "$COUNT" ] do UUID=`uuidgen` mysql test -e “insert into sorttest value (‘$UUID’);” let “COUNT=COUNT… required to perform 12 queries like ‘select * from sorttest order by data limit 78000,1′ with, of course, the query cache disabled. I also verified that during the whole process, the computer never swapped and I pre-warmed the file cache before…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…HEAP for in memory tables. So first MySQL versions did not bother naming variables with…temporary tables. key_cache_age_threshold, key_cache_block_size, key_cache_division_limit Key Cache/Key Buffer replacement… and Innodb. Some SQL level items as Query Cache also could use this feature. low_priority…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… is similar to storing the results of a query in Memcache. When the cache “expires”, the contents must be fully recalculated.. An… view, making it available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41… line items from orders: mysql> delete -> from order_lines -> where order_id -> between 1 and 100 -> limit 500; Query OK, 484 rows affected…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… name. In certain version it even does not work for LIMIT boundaries Inconvenient list handling. Unlike in for example PEAR emulated… great future ahead for MySQL Prepared statements – many of the problems such as extra round trip, non working query cache or non working prepared statements for some of the statements as well as most of other problems can be fixed. MySQL…
