…on “Read/Write Splitting with PHP” for Percona Webinars. If you missed…a write-through cache? A: The InnoDB buffer pool is effectively a …inserts) on multiple MySQL servers? Or is it possible to split only read queries (select… in North America and Europe. Join Percona and the MySQL community in…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…CREATE TABLE db.schema … AS SELECT” and/or “INSERT INTO db.schema … AS SELECT” statements from standard input,…); The script (convert.php) supports basic queries which use select/group by/join/where. You may not… used to prevent wide innodb primary keys on the MV. mysql> select mview$pk as rank, …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…) in nearly (emphasize nearly) every InnoDB table can have very … add processing time to inserts, updates, and deletes but there …SELECT * FROM articles WHERE user_id IN (SELECT id FROM users WHERE featured=1) Ouch! Use INNER JOIN…to crawl. > So developing you PHP applications use test database with…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…an MV can pre-compute joins and may aggregate and …. php ./setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php setup… metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot …> ) > engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into…
Comment: Why MySQL could be slow with large tables ?
January 31, 2008 By 141 Comments
… a web project using MySql, Apache and Php. The database has a relatively acceptable size, … DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB; The capital letters are INDEXes and some … preform simple SELECTs in them (not joining them with other tables). Once again, I use multiple inserts into the…
