… rows in tens of thousands tables) Innodb was better choice mainly because of thouse other behaviors … well table locks was the problem at…/Session tables (you can throw them away if it server crashes). You can use multiple of cache tables to avoid concurrency issues. Temporary tables used…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… when an in-memory temporary table will be converted to an on-disk table, which is an expensive…find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (… and where there’s quicksand to be avoided. The changes Percona’s performance audits typically …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…problem is avoided when upgrading to Percona Server by converting the affected tables or columns…Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the server to crash in …Fixed: #704216 (Laurynas Biveinis). Querying INNODB_SYS_TABLES after an ALTER TABLE statement leaded to a …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…recovery, for example dealing with temporary tables (unless they are used to populate normal tables using SQL). On … one table or another this would not work. Though this is rather easy to avoid, but … altering tables. If you have Innodb tables you’re normally OK because you can use –skip-innodb on …
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
…. Computing the entire contents requires a temporary table and many more rows may be … query. As long as a view avoids aggregation, DISTINCT, GROUP BY, ORDER BY, etc…table params ( view_name varchar(250), param1_val int, connection_id bigint, primary key(connection_id, view_name) ) engine=innodb…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
… problem is avoided when upgrading to Percona Server by converting the affected tables or columns to…#61790 in MySQL (Alexey Kopytov). Querying global_temporary_tables caused the server to crash in some…Using the innodb_lazy_drop_table option led to an assertion error when truncating a table in some …
Comment: ORDER BY ... LIMIT Performance Optimization
February 8, 2009 By 100 Comments
Is there anyway to accomplish the same thing as this query, avoiding a temporary table? select ID_MEMBER_STARTED, COUNT(*) as hits from smf_topics group by ID_MEMBER_STARTED order by hits desc limit 20; There is an index on ID_MEMBER_STARTED and the table type is InnoDB.
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… So one way or around you can avoid such limit but creating connections will …will continue press reload. Plus, especially for Innodb tables throughput may drop dramatically – you may see… have these queries doing large sorts, using temporary tables or having other significant memory requirements you…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…UPDATE, and to avoid optimistic locking errors. This makes PBXT’s behavior identical to InnoDB in REPEATABLE READ …rebuilt, which can be done by REPAIR TABLE. The table data page size does not require a… addition, an UPDATE or DELETE only acquires a temporary row-lock. This lock is released when the…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… that don’t really indicate problems. To avoid this problem as much as possible, I …or drop a table, or the database itself. Likewise, if a system administrator leaves a temporary file … pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as …
