Truncating big tables, with millions of rows, in InnoDB can be really slow. Luckily there is a small trick to speed this up.
The trick is to first create a table that has the same structure as the table you are truncating:
CREATE TABLE `new_table` LIKE `bigtable`;
Then you can swap the to be truncated table for the empty table:
RENAME TABLE `bigtable` TO `old_table`, `new_table` TO `bigtable`;
After this your system will use the new (and empty) table, and you can do a quick drop of the old big table:
DROP TABLE `old_table`;
Done, you have succesfully truncated your huge table.
Sometimes the edges in our MySQL database are referring into the wrong direction. In those case...
MySQL is one of the most popular databases for websites. The main reasons are price and speed :-...
The MySDQL Reference Manual for almost all MySQL versions that are now in use.
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application develope...
Sphinx is a full-text search engine, distributed under GPL version 2. Commercial license is also ...
MonetDB/SQL and MonetDB/XQuery, fast query language support in an open-source column-orienated da...
This tutorial is an attempt to help you become familiar with multi-threaded programming with the ...
PrimeBase XT (PBXT) is a transactional storage engine for MySQL. As illustrated below, a MySQL st...
GeSHi - Generic Syntax Highlighter for php. Highlight many languages, including PHP, CSS, HTML, S...
The Man in Blue showcases the writing and Web design of Cameron Adams.
This is a method t...
Sometimes the edges in our MySQL database are referring into the wrong direction. In those case...
This tutorial is an attempt to help you become familiar with multi-threaded programming with the ...
GeSHi - Generic Syntax Highlighter for php. Highlight many languages, including PHP, CSS, HTML, S...
The Man in Blue showcases the writing and Web design of Cameron Adams.
This is a method t...
The MySDQL Reference Manual for almost all MySQL versions that are now in use.
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application develope...
Sphinx is a full-text search engine, distributed under GPL version 2. Commercial license is also ...
This tutorial is an attempt to help you become familiar with multi-threaded programming with the ...
Sphinx is a full-text search engine, distributed under GPL version 2. Commercial license is also ...
MonetDB/SQL and MonetDB/XQuery, fast query language support in an open-source column-orienated da...
PrimeBase XT (PBXT) is a transactional storage engine for MySQL. As illustrated below, a MySQL st...