… work and formating, so database connection may become the issue. Caching should be good help in this case though. About Consulting… MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality This is right. With some exception however. For example Innodb tables do…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…, MySQL always uses Nested Loop Join to join two or more tables. What this means is that, select rows from first table participating…=off’ optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment: NULL Create_time: 2011-05-10 04:26:14 Update…_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… Software Repositories). Based on MySQL 5.1.66, including …privileges to modify a table (any non-temporary table) can inject …Temporary files created by binary log cache were not purged after transaction…INCREMENT columns. Bug fixed #1039536 (Alexey Kopytov). In cases where indexes with AUTO_INCREMENT…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with an AUTO_INCREMENT column could result… ANALYZE TABLE is run for each table. Bug fixed #890623 (Alexey Kopytov). A server acting as a replication slave with the query cache…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
…cache name FROM people WHERE age in(18,19,20) AND zip IN (12345,12346, 12347); +—-+————-+——–+——-+—————+——+———+——+——+————-+ | id | select_type | table… MySQL 5.0 you do not have to any more. SHOW STATUS now will show per session counter increments…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… some MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE actor ( actor_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, first… of name ‘./sakila/customer.ibd’ InnoDB: to the tablespace memory cache, but tablespace InnoDB: 15 of name ‘./sakila/actor.ibd’ already…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…cache, and using O_DIRECT to bypass OS caching) mysql> explain select count(*) from wp_comments; +—-+————-+————-+——-+—————+———+———+——+——–+————-+ | id | select_type | table…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… we get bigger table (so smaller portion of table will fit in CPU cache) the filtering speed stays about the same: mysql> select count… in-cache scenario I created a table with just 10000 rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE…_data_length: 948528873 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… this solution compared to others: Innodb Tables – This table is getting much more reads than writes … for number of benefits – caching data and index in memory -so cached lookups are very fast, …MySQL/System crash is painful and great to be avoided. Long primary key – why did not I use auto_increment…
