… created and then INSERT INTO new_table SELECT * FROM old_table is done and then RENAME old_table to tmp_table, new_table to old_table and finally DROP tmp_table… Locking and Table Cache No matter if a connection accesses a table that is already in the Table Cache, any query to a table that has…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…stuff like dropped packets… Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use…and bring big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index structures, and…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…TABLE. When ALTER TABLE is Performed in many cases it will Create temporary table with modified structure, copy data to that table and when drop original table and…OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… get extremely poor response time and will continue press reload. Plus, especially for Innodb tables throughput may drop dramatically – you may see it… support command which resets connection and guarantees it will be the same as freshly created connection, so the fact connection is persistent can be…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…tables and queries. The script and instruction are available here: http://www.mysqlperformanceblog.com/files/benchmarks/phptestsuite.stable.tar.gz We used table “normal” table…page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read…case with 4 threads but drops down very fast. READ_…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…being used at all and could be candidates for dropping. All the patch features… 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time: 20 Busy_time: 1 … in set (0.00 sec) The statistics for tables and indexes can be cleaned with the …
Post: Resyncing table on MySQL Slave
June 29, 2008 By 11 Comments
…. Alternative would be not to drop the table but rather raname them. Unfortunately you can’t rename locked tables (ERROR 1192 (HY000): Can… may rename table instead of locking – for many applications this works better anyway as having table locked causes connections to pile up and either MySQL runs out of connections or Apache out of children…
Comment: Best kept MySQLDump Secret
March 25, 2012 By 13 Comments
… dump file (correct table contents and binary log coordinates), no other connection should use the following statements: ALTER TABLE, CREATE TABLE, DROP TABLE, RENAME TABLE, TRUNCATE TABLE. A consistent read is not isolated from those statements, so use of them on a table to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…which allow connections as root with no password from localhost. It is possible to read from and/… it a HUP signal. The script will drop a .pid file so you know what …`flexviews`.`mvlogs` metadata table, and it creates the changelog table itself. $ php add_table.php –schema=test –table=demo success …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…drop_table option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#798371 (Yasufumi Kinoshita). Other Changes Improvements and…
