…’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to create this once… any host:port or schema name information. Viewing SchemaSpy output A completed Relationships view of these three tables should look like this…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…“MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view … equivalent solution. If you’re talking about using a temporary table to store an interim result… secondary index. But the result was that it created a temporary table to count the movies …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… bug #49169 by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on… caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bug #49169 by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on… caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
…in InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this …the reason for notable MySQL performance drop. Now in Percona Server, for each connection we use a preallocated read view structure, reuse …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… with an empty transaction list when creating read views. However, the more general descriptors… communication). Results: First of all, we used a smaller dataset for this benchmarks…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… have changed since the view was either created, or last refeshed. The incremental method is somewhat conceptually similar to using mysql binary logs for…, 1 row affected (0.00 sec) When the view is ‘enabled’, the contents are created: mysql> call flexviews.enable( -> flexviews.get_id(‘demo…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…create_eventblogpercona.commanual Com_create_functionblogpercona.commanual Com_create_indexblogpercona.commanual Com_create_procedureblogpercona.commanual Com_create_serverblogpercona.commanual Com_create_tableblogpercona.commanual Com_create…use_native_aioblogpercona.commanual innodb_use…_views_…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… Drizzle), produce a CREATE TABLE statement that took over four minutes to execute and get a more complete view of how the…_type(). In MySQL 5.1, for some reason yet unknown to humans, it lives in sql/sql_view.cc as mysql_frm_type…) An example of how this is used is that in the DROP TABLE code path, MySQL uses this magic byte to work out…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…you recommend creating an index in every table you create? Example: CREATE TABLE user_…view ? Is there any management required or server does everything itself. Especially when using a CMS where DB structure is prepdefined A: MySQL…mysql use index for group by? A: If you have Index on the column MySQL…
