…COMPRESS/UNCOMPRESS functions or compressing/decompressing things on the client. This choice of server side vs client size compression…compression (some XML data) while in practice table size reduced over 5 times and performance…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…set_client_…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…slave_compressed_…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… with MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL… such light compression in addition to zlib we could stream compressed results directly from storage and only de-compress it on the client. Delayed…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…or database About the cluster For best performance, there should be an even data …compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression…my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…tool kit which helps improve the performance of queries against a MySQL database by distributing the work … for the virtual machines. Baseline: The MySQL command line client was used to execute the a … was approximately 23GB of data. After loading, ICE compressed this data to about 2GB. The test …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to provide the freshest data to their own clients, with no delays. Finally, the analysis is usually…files don’t store as compactly on disk as [Compressed] MyISAM or Archive. These are just some ideas…star schemas. The problem is that MySQL doesn’t tend to perform well on a data warehousing workload….
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… degraded the performance when using compressed tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi… was on the FEDERATED engine and a replication environment, its client connection to the remote server was closed leading to an…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…. Also, a gzip compression potentially compresses the database more than just prefix compression. The downside in gzip… you’re performing INSERT with multiple values? We build up INSERTS on our clients and insert…out you can get better performance by using couple of MySQL Servers on single node. You…
Comment: Full text search for all MySQL Storage Engines
June 28, 2006 By 37 Comments
… to count I leave out the mysql codes needed to store these bytes… compressed with LZF since its sparse vectors (actually you can use any compression algorithm…how the search itself will be performed is changed. With a regular lookup… return top 200 back to the client the internal processing might use …
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… possible and today I worked with client which used character keys, in my… this to shorten some internal buffers MySQL has to allocate for key comparison…Performance degradation can range from few percent to couple of times for Innodb tables MyISAM Tables may suffer significantly if key compression…
