…, the signal table and other tables, using the oldest change required by any incremental view. I’m working on Shard-Query improvements…: set sql_log_bin=0; delete from flexviews.mview_signal; Don’t do the following if you have any views that you… uow_id at which it was created! Simply refresh a view once, immediately after creating it, to ensure there is no…
Comment: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended… the application’s choice in an SQL comment? Q: Can the solution you proposed be used with Percona Xtradb Cluster. Or are… probably a good reason to redesign my prototype to use hints embedded in SQL comments, instead of instantiating different wrapper classes. Q…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… queries only – Meaning it does not work for subselects, inline views, parts of the UNION. This is also common missunderstanding. Works… you can set query_cache_type to “DEMAND” and use only SQL_CACHE hint for queries which you want to have cached…=5. If you run in default mode you can also use SQL_NO_CACHE to block caching for certain queries, which you…
Post: Where does HandlerSocket really save you time?
March 16, 2011 By Leave a Comment
… audience at Percona Live asked about the profile results when using prepared statements and I’m just getting around to publishing…(void*,void*) 1626831.6824alloc_root 1318231.3632read_view_open_now 1227951.2699mysql_select(…) – Parsing SQL is slow HandlerSocket (Akira’s Numbers…(…) 53251.2215mysql_execute_command(THD*) – Still lots of time with SQL overhead (not parsing) HandlerSocket (5.1.56) samples%symbol name…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… is bigger to help queries that don’t use indexes and that do use some of the new optimizer features. query_cache… expect most tables to be InnoDB and use innodb_file_per_table. sql_mode also uses STRICT_TRANS_TABLES by default. You were… improve the general quality of configuration overall. Views are my own. For an official Oracle view, consult a PR person. James Day…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… You’re a corporate application developer who wants a small SQL development & test box You’re a Internet startup that just… screens use a DVI-D connector, not a DVI-I one). Alternatively, if you really do end up needing to view the….service’ Start Percona Server [root@alarmpi ~]# systemctl start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… the atomic data as CSV files and use the CSV engine so you have an SQL interface to it (the meta-tables…, even to think of things that seem “less advanced” than using a database. Sharding and Partitioning Sharding is inevitable if your… many rows as you have unique ads per day. Viewed this way, suddenly you start to hate the ads that…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… you updated the index. You can use the DataImportHandler to import the result of any SQL query, and if you can form… different application types. There are books that describe how to use one technology or the other, and some may compare one…! I’d like to see some of the folks who viewed my Full-Text Search Throwdown webinar when I present the…
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
You can use Flexviews to build materialized views, then easily query those with HandlerSocket. Incremental refresh takes a … maintaining the materialized views (giving you a persistent query cache with controlled invalidation) and HandlerSocket lets you avoid SQL parse overhead when…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…, and from the glance view it is indeed great to provide users with same top level SQL interface allowing them to store… strategies storage engines may have and if we venture into using cross storage engine transactions we’re up for a lot… get rid of SQL level table locks and using Innodb internal data dictionary instead of Innodb files. We would use Innodb transactional log…
