…. [root@sb logs]# /root/bin/lvmsnap.sh snapshot Taking a new snapshot .. done Trimming excess snapshots .. Logical volume “mysql-data-201202230135…, 0 rows affected (0.49 sec) mysql> alter table employees add column age smallint unsigned not null default 0; Query OK, 300024… for every MySQL restart, the logs are flushed and a new binary log is created, looking at the current binary logs…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
Post: Percona Server version 10
April 13, 2010 By 3 Comments
… can be bigger 4G New patch innodb-fast-checksum. It adds new faster checksum algorithm used in InnoDB tables New supported platforts are added….45+xtradb-10 compilation fails on Ubuntu Karmic Bug #547230:Add new columns to innodb_table_stats Bug #548442:INFORMATION_SCHEMA.TABLE_STATISTICS…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…: 0 Let’s trigger a table rebuild by adding a new column and see what execution time is like when the default…, 0 rows affected (0.00 sec) mysql> ALTER TABLE t ADD COLUMN v VARCHAR(1); Query OK, 4194304 rows affected (1 min… slower; mysqldump –innodb-optimize-keys ignores indexes on AUTO_INCREMENT columns, because they must be indexed, so it is impossible to…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…single query is single threaded in MySQL, the new optimizations don’t really help with this …Query was initially conceived as a utility to add parallelism to horizontally partitioned data sets by … queries to use the FlightDate column instead of the Year column. See the “full disclosure” section …
Comment: Small things are better
July 6, 2007 By 15 Comments
… alter table (to add a new column), I see that a new table is being populated at the same time to add the new column. (BTW, why does it do this? Experience with MSSQL is that an alter table takes merely seconds to add a new column…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
…=9320 test Reading table information for completion of table and column names You can turn off this feature to get a…=9323 test Reading table information for completion of table and column names You can turn off this feature to get a… server_requirements list is a server. You can add new servers by adding a new list. If you want specific options, put them…
Comment: Fixing column encoding mess in MySQL
January 29, 2008 By 32 Comments
… collation as latin1_swedish_ci.. But as I had to add new field to the system to show Chinese info to employees… store anything anywhere Chinese. however I have only about 10 columns in whole database which use Chinese. So is this the… UTF-8, collation UTF9_general_ci 2.> keep all English columns as latin1 with collation as latin1_swedish_ci and chinese…
Comment: ORDER BY ... LIMIT Performance Optimization
September 2, 2006 By 93 Comments
… is no sequential integer ids, you can use other approach. – add indexed column called “random” and populate it with random values – do… rand() – once you’ve selected the row update “random” to new random value – periodically run process to resent random values for…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… server crashed at a precise moment when other columns were being updated in an InnoDB table. (Bug #…before the mtr_commit() of the update, the new BLOB pages could have overwritten clustered index B…_mark_freed_leaves(nonfree=TRUE). btr_page_alloc(): Add the parameter init_mtr, allowing the page to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…_customer_sales’, ‘INCREMENTAL’); SET @mvid := LAST_INSERT_ID(); CALL flexviews.add_expr(@mvid,’GROUP’,'customer_id’,'customer_id’); CALL flexviews… the new MV (dashboard_top_customers) to list the top 10 customers nearly instantly. Note that every MV gets a special column…. In cases where this is not useful, simply ignore this column. It is used to prevent wide innodb primary keys on…
