…I get up to speed a lot faster and can contribute to the …is the properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…schema name information. Viewing SchemaSpy output A completed Relationships view of these three …
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and…. It turned out this solution was 150x faster for this case, so your suggestion is a good one! Thanks again for attending… and Europe. Join Percona and the MySQL community at our events. The next one is in London on November 11-12, 2013…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug #49169… few times to orders of magnitudes faster than a list scan. You may be curious if MySQL 5.6 brings any notable…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… an empty transaction list when creating read views. However, the more general descriptors optimization in…s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In … features even higher QPI speed (and thus, faster inter-process/node communication). Results: First of …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… will completely rebuild a view based on the SQL which defines it, each time the view is refreshed. This is not much different from…, 1 row affected (0.00 sec) When the view is ‘enabled’, the contents are created: mysql> call flexviews.enable( -> flexviews.get_id(‘demo…, 0 rows affected (7.01 sec) The second one is 365x faster because it examines only the rows that changed. This exceptional…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
… all relational algebraic statements is a table, so conceptually so too is the output of a SQL statement. MySQL even includes a SQL… obvious benefits which include: Refreshing large views is orders of magnitude faster than complete refresh. When updating the view, only a subset of the…
Post: Derived Tables and Views Performance
August 31, 2006 By 16 Comments
Starting MySQL 4.1, MySQL had support for what is called derived tables, inline views or basically subselects in the from clause. In MySQL 5…) Query using view is fast again: mysql> create view v as select * from test; Query OK, 0 rows affected (0.08 sec) mysql> select * from…: Avoid derived tables – If there is other way to write the query it will be faster in most cases. In many cases…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
…is “minor release” if you look at the number, it is major release in practice (and you can view… with MySQL and scripting languages very well, it is simple, it performs well and it is easily … the new version. First is about “EXTENDED2″ matching mode – which is faster and more feature full search…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… for subselects, inline views, parts of the UNION. This is also common missunderstanding. Works on packet level – This is one of the reason… how it works with MySQL to add caching but you can enable query cache so it works faster. Low load applications – If you’re building application which is not designed for extreme load…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…is greater than 128 ms, NTP won’t work. So far for background and theory, from the practical point of view…slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I… to a few nodes is faster then writing only to 1, the reason for this is that only 1…
