June 19, 2013

Post: MySQL Query Patterns, Optimized - Webinar questions followup

MySQL Query Patterns, Optimized” for Percona MySQLperformance, but it returns a better random choice. Another workaround may be to add a columnproblem if the keywords were returned in a different order from

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2

… you want to perform a planned failover. … is the same problem for s0 (which…mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from…event executed: s1> show slave status\G [...] Executed…A ‘Last_Executed_GTID’ column would have been …

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

… available for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be …would fail in case mixed CHAR and VARCHAR columns would be used in foreign key definitions. …We did our best to eliminate bugs and problems, but this is a software, so bugs are…

Post: ORDER BY ... LIMIT Performance Optimization

MySQL Performance problems. Here is what you need to know about ORDER BY … LIMIT optimization to avoid these problems… * FROM tbl WHERE c=5 ORDER BY a,b limit 10 – In this case first two columns from … 1 row in set (0.03 sec) See – “rows” is showing us there are estimated 1.6 million …

Post: Death match! EBS versus SSD price, performance, and QoS

…can see performance throughout the day. If you’re not familiar with the diskstats tool, the columns … for example. But the samples I’ll show are from an array of 10 x 100GB EBS volumes… causing acute performance problems for the database, manifested as epic stalls and server lockups which show up as …

Post: Testing MySQL column stores

… my independent testing from an objective viewpoint. I performed two different types… developing such cases for MySQL column-based storage engines in the… a problem would be “select avg(char_column) from table” where the column … Infobright that would be “show stoppers” for typical OLAP analysis…

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

column is done is this one, which discusses improving bulk insert performancecolumn, however, MySQL apparently has no problem with either of the following statements: mysqlmysql> select * from

Post: Find and remove duplicate indexes

column. To take benefit from a composite index MySQL doesn’t need to use all the columnsproblem. Conclusion Indexes are good for our queries but too many indexes or duplicate or redundant indexes can hurt the performance

Post: Edge-case behavior of INSERT...ODKU

… database performance that dropped…columns from the INSERT part of the statement corresponding to the columns…. So, MySQL checks our…PRIMARY’ (root@localhost) [test]> show status like ‘handler%’; *** some rows omitted *** +—————————-+——-+ …column to use a BIGINT, and problem

Post: Why MySQL could be slow with large tables ?

from in-memory data size and expect gradual performance decrease as database size grows you may be surprised by serve drop in performanceshow benefit from using indexes. In fact even MySQL…. “val” column in …problem in MySQL is lack of advanced join methods at this point (the work is on a way) – MySQL