June 19, 2013

Post: Percona XtraBackup 2.0.7 for MySQL available for download

…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 Tablesof tables and slow IO then XtraBackup can spend a lot of time… is being taken which speeds up the backup process. Bug …

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

…. 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…

Post: MySQL Users Conference - Innodb

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

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

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

Post: How Percona does a MySQL Performance Audit

of size and spindle speedPerformance 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

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

mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLEof 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

Post: Database problems in MySQL/PHP Applications

… 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

Post: MySQL EXPLAIN limits and errors.

MySQL has triggers which can make updates very different. Also there is no way to tell you how ALTER tableof 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

Post: Is disk Everything for MySQL Performance ?

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…

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

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