… Kopytov). Percona Server for MySQL was built with YaSSL which could cause some of the programs that use it to crash. Fixed… bug #49169 by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability… #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
Hi Zoe, yes – all of our MySQL webinars are recorded and available for viewing afterward. You’ll find this one here: http://www.percona.com/webinars/using-mysql-56-performance-schema-troubleshoot-typical-workload-bottlenecks
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… contents must be fully recalculated.. An incrementally refreshable view (that is, one which uses the incremental method) can be updated much more…_API Unlike views which use the complete refresh method, incrementally refreshable views are not built directly from SQL. Instead, Flexviews includes a MySQL stored… the view. This is much more convenient than trying to read from the dictionary directly to determine the contents of the view. mysql…
Post: Using VIEW to reduce number of tables used
September 28, 2007 By 12 Comments
… tempting to use VIEWs to reduce number of tables dramatically – merging say 1000 of users to the same table as VIEWs are significantly… of the views. You could think MySQL would look at the WHERE clause to figure out which value should be used but unfortunately… is not part of the view so would not be available even if MySQL would support triggers on VIEWs (which it does not…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… screens use a DVI-D connector, not a DVI-I one). Alternatively, if you really do end up needing to view the… start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES… it? A few other points: This setup uses Percona Server for MySQL with the latest mysql client, which is untested, but should be…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… mention them separately. Running MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the… all MySQL and MySQL-fork vendors – Oracle, MariaDB and Percona. By my observations RedHat and CentOS are also much more frequently used with MySQL…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… the platform you’re using. Other times you need a custom build with special compile time settings. Using Percona MySQL Server Development Services… broad view of your MySQL server needs. Chances are custom MySQL server development should be one pillar of your strategy, and Percona MySQL Server…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… see applications being built utilizing VIEWs functionality which appeared in MySQL 5.0 and quite frequently VIEWs are used to help in writing the… with complexity hidden away in VIEW definition. Just another day I worked on optimizing application which uses VIEWs and was looking at the… we solve the same problem having things more modular and using MySQL VIEWs ? mysql> create view user_counts as select user_id,count(*) cnt from…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… in). Let’s keep using views so this dynamically updates as our schema changes over time: mysql> create view all_indexes as select t…. I can now select my droppable (unused) indexes from this view: mysql> select * from droppable_indexes; +————–+—————+—————————–+ | table_schema | table_name | index_name…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…you test to use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id …, } joined { 7e6d285b-d56d-11e1-0800-2491595e99bb, } left { } partitioned { }) to view: view(view_id(TRANS,7e6d285b-d56d-11e1-0800-2491595e99bb,2) memb { …
