…of the query. convert.php This script takes as one argument the default database. Notice in…number of lines in the order_lines table, three orders of magnitude more quickly than COUNT(*). mysql…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine what rows have changed. Because of…table. This is generally only useful if you have a small number of tables, and you want to track changes on all of…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…database background. Things are different with MySQL. There are many successful applications, using tens of thousands of tables…number of indexing missing which requires queries to do full table scans. Funny enough this is often not the problem in…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…database background. > Things are different with MySQL. Good design will help dictate how many tables are required in order to get…in this table?” An index that has very high cardinality (as high as the number of rows in the table…
Post: PHP Sessions - Files vs Database Based
March 27, 2007 By 38 Comments
… on database level. If you change to store PHP sessions in MySQL instead this effect may be no more true and you may have number of… can get back your old file based session behavior with MySQL Sessions ? If you have dedicated connection to session database and use Innodb tables… tables for session you can use GET_LOCK to get same behavior. In the start of the session you can do SELECT GET_LOCK(”,10) and in in…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
…of course reducing number of connects which are rather expensive, even though they are much faster with MySQL than with most other databases…in case of “overload”. In case your number of connections is limited you start getting connection errors which are easy to handle, in case of large number of…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…number of the flight. Some data hand updated.’; — – Table structure for table `ontime_fact` — CREATE TABLE…mysql> use ontime1; Database changed mysql> show table…of 1 to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… performance of queries against a MySQL database …table). In order to demonstrate the power of …of queries which have to examine a large amount of data. Shard-Query includes a loader (loader.php…degree of parallelism is controlled by the number of shards. …can get Shard-Query (currently in development …
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If…Database Conference in November so I thought it would be good idea to gather some wish list for things nice to have in… get a table below page output listing all the queries, their exec times and number of…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to Oracle’s main database…of table online. Q38: Seems that adaptive hash indexes are not used for primary key lookups or not showed up in…
