…to complete. Here is example how… Sending data | select count(*) from A,B | 0…that very nasty “full join” select to…to the database at all (use mysql -A in this case, to…stored procedures etc (which are stored in MyISAM tables anyway) you can consider using –no-lock option with Percona Xtrabackup. Many…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…to update the snapshot to reflect the changes that have happened in the database…stored procedures to modify the dictionary. Do not modify it directly. convert.php You are probably unfamiliar with the SQL_API. In order to…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…how fast they are in different queries. First favorite query for any database benchmarker is SELECT count…that MonetDB does not like to scan many records, there is query select year,count(*) as c1 from ontime group by YEAR which shows how many…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table. Avoid comment (and space) in…to be cached. Query must be deterministic – Query might provide same result no matter how many…
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
…to write binary logs in statement mode. Â The row-based format does offer advantages particularly if triggers or stored procedures…to the database…in particular that the server is trying to find is c1=1, but how can we find that…
