June 19, 2013

Post: Percona XtraBackup 2.0.7 for MySQL available for download

May 6, 2013 By 1 Comment

…open-source, free MySQL hot backup software that performs non-blocking …ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables… of tables and slow IO then XtraBackup can spend a lot of time… is being taken which speeds up the backup process. Bug …

Filed Under: MySQL Tagged With: , , ,

Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size

June 27, 2012 By 4 Comments

…. I used 10mil row table which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G… over 20x performance improvement to the speed of ALTER TABLE, as this is not only step which ALTER TABLE does the improvement to the index creation speed itself…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…tables by separate phase of building Indexes ? Will be UNIQUE indexes built by sorting in case of ALTER TABLE (the big Gotcha for MyISAM tables…larger than table itself) The index build speed is …of them to MySQL 5.0+ Heikki also mentioned there are more things inside Innodb to unleash performance…

Filed Under: Events and Announcements Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…table that has never had a full-text index on it, and then I create one, the following warning is generated: mysql> alter table…performance. At the very bottom, the page claims that you can speed…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…of size and spindle speed…Performance MySQL… | 255868807 | 11893 | | Com_alter_db…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE… of upgrading to 5.6 and running ALTER TABLE foo ENGINE…of this series, we will take a look at performance. How does the speed of…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

… not expect it to beat MySQLi in speed. It is however bad idea to use mysql_ functions directly as well – I would… of tables per host and archiving great performance by doing so. Using multiple tables gives some very important benefits – your data becomes managable, your ALTER TABLE…

Filed Under: Insight for Developers Tagged With: , ,

Post: MySQL EXPLAIN limits and errors.

July 24, 2006 By 6 Comments

…MySQL has triggers which can make updates very different. Also there is no way to tell you how ALTER table…of the operation – full table scan of table in memory may be done at speed of millions of rows per second, while retrieval of large rows from uncached table…

Filed Under: Insight for Developers Tagged With: ,

Post: Is disk Everything for MySQL Performance ?

April 25, 2008 By 7 Comments

… of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance… be helpful solving replication delay or speeding up this 3 hours reporting query or 5 hours ALTER TABLE command. Let me also comment… is where a lot of roads meet and you have to consider a lot of topics – security, manageability, performance. I tend to advice…

Filed Under: Hardware and Storage Tagged With:

Post: The Optimization That (Often) Isn't: Index Merge Intersection

December 14, 2012 By 6 Comments

…performance win, perhaps. Sometimes it is. Other times, it is a major performance killer. It’s fairly straightforward to tell when MySQL…altering the table…

Filed Under: Insight for DBAs, Insight for Developers, MySQL
« Older Posts