…Using multiple databases Honestly I do not see application using one database per table that often. I however often see applications using multiple databases…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…use > mysql_ functions directly as well – I would go for using…Using multiple databases Honestly I do not see application using > one database per table that often. I however often see applications > using multiple databases…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…The incremental method is somewhat conceptually similar to using mysql binary logs for point-in-time recovery… the query. convert.php This script takes as one argument the default database. Notice in the … have been collected. You can use this to refresh multiple incremental refresh views to the same …
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… on “Read/Write Splitting with PHP” for Percona Webinars. If you missed …MySQL Proxy (RW-splitting)? A: Most solutions with MySQL Proxy I see have stern disclaimers against using…database instance, and you need to scale out to multiple database instances. Q: Isn’t opening multiple database…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…though they are much faster with MySQL than with most other databases. Not only connects are expensive … is of course to use multiple IPs on your MySQL server (you’re probably using Intranet range IPs anyway…connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes …most common buzzwords used together with MySQL is Scale Out, but to say the truth MySQL does not …need to manually chop your data to the multiple databases and handle data merging on application together …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…possible to distribute splitting and/or loading among multiple nodes as well. Note that in the… avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G … shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access memcache extension from pecl was used. All applications were running… applications, which tend to access same data read from database multiple times. Examining MySQL full query logs from many applications seeing several exactly…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… query parameters in order to make sure you can use ODBC in a database-agnostic way. Vendor differences in parameter naming are… onto their database server. Their MySQL server became CPU-bound, while their multiple PHP application servers were often idle, waiting for the database server. It…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar to the… delimited flat files using mysqldump. I started by loading the raw data from the BTS into a single database table called ontime…. Shard-Query includes a loader (loader.php) which can be used to either split a data into multiple files (for each shard, for…
