…in most cases you would have beautiful page rendering as well as much more queries per page…multiple tables gives some very important benefits – your data becomes managable, your ALTER TABLE or OPTIMIZE TABLE now locks small table for…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…/Write Splitting with PHP” for Percona Webinars. If you…. For example tables used for logging less critical information. In this… it in production. Even the official manual page for …for a single database instance, and you need to scale out to multiple database instances. Q: Isn’t opening multiple…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’…this information in the log. For debugging I’d like to be able to get a table below page …to run multiple queries for multiple MySQL connections at once. For scale out applications data to generate the page may be…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…for me however. Other ways to workaround this problem is of course to use multiple…press reload. Plus, especially for Innodb tables throughput may drop …page and everything on your site uses same charset and does not use per session variables in… with new “mysqlnd” driver for PHP effort by MySQL …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…in most cases you would have beautiful page > rendering as well as much more queries per page…multiple tables gives some very important benefits – your data > becomes managable, your ALTER TABLE or OPTIMIZE TABLE > now locks small table for…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…for example you may have different response time guidelines for pages which are requested for…in your work. For small and medium size applications you can log all requests to MySQL table for…for complex applications using mutliple components (like sphinx and MySQL) or multiple MySQL Servers because in…
Comment: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…page has queries going to multiple database servers. 2) I’m more speaking about something simple and easy to use for… and get nice table with your query …for my application chance of going from MySQL to something else is probably less than rewriting them from PHP… be well build in into the driver as…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… MySQL 4.1 and PHP 5.0. For memcached access memcache …page load is not an exception. For caching these associative array can be considered. Second baseline was selecting from MySQL table…multiple levels of caching for your application. In different circumstances different layering may make sense. For…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…multiple nodes as well. Note that in the demonstration each node will contain redundant, but non-accessed data for…– — Table structure for table `ontime_fact` — CREATE TABLE `ontime_fact…for 20 shards (adjust to your number of nodes) php genconfig 20 > shards.ini Running the test For…sample-pages=…
