… compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the BLOB/TEXT columns… you with true data size and performance gains, especially for Innodb tables. With Innodb tables BLOB gets its own page (allocated outside…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot… difference is join_buffer which reduces number of passes MySQL had to perform and so number of row combinations really examined. LIMIT… known – for example BLOB fields can’t work with in memory temporary table. The other thing – since MySQL 4.1 sorting can…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
…-VARCHAR support for MEMORY tables for MySQL 5.0. Although this patch did not add the BLOB and TEXT support, it refactored… not included in MySQL in 2008): The key columns must come before any non-key variable-length columns. For performance reasons, the…-length format, either wasting space (VARCHAR) or outright impossible (BLOB). Indexes on BLOB columns are not supported. While we do not consider…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however… increase memory consumption for given thread, however if table will perform complex operations such as full table scans, sorts, or need… have unbound memory requirements retriving result sets from remove queries. Blobs may require 3x time of memory. This is important if…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
…about archiving best performance in your application using MySQL you should learn about prepared statements. These do not neccesary provide performance beneft but…conversion and copying Avoid SQL Injection Save memory on handling blobs There are also drawbacks and chewats of using prepared statements…
Post: Percona Server 5.5.15-21.0
August 31, 2011 By 9 Comments
… milestone at Launchpad. Improvements Improved MEMORY Storage Engine As of MySQL 5.5.15, a Fixed Row Format (FRF) is still…, TEXT and BLOB fields in MEMORY tables. This implementation is based on the Dynamic Row Format (DFR) introduced by the mysql-heap… of those columns and making possible BLOB and TEXT fields and real VARCHAR and VARBINARY. For performance reasons, a mixed solution is…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… which is scheduled to be fixed before stable release but performance effect of it is yet unknown – how transactional system implements… the blobs which are never fragmented and handled efficiently. PBXT team even leads the project to add scalable blob streaming to MySQL which would be fun for many applications if implemented well. It is too bad MySQL Users Conference…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… and good performance innodb_log_buffer_size=4M 4M is good for most cases unless you’re piping large blobs to Innodb… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server…. If you have update activity spikes however or work with blobs a lot you might want to increase it. Do not… decrease performance. I normally leave per session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… and performance of MySQL is often the problem even for medium scale sites. As response to these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough to solve all performance… on scalable blog streaming to make it possible store large blobs such as images in the database efficiently. The other Wave…
