…latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show…operations. This will have a direct impact in our query response times and throughput. Setting … shard-query #generate a config for 20 shards (adjust to your number of nodes) php genconfig …
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
…mysql> /* comment*/ select count(*) from fact where val like “%c%”; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> /* another comment…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…a presentation on “Read/Write Splitting with PHP” for Percona Webinars. If you missed it, … given query‘s slave lag tolerance. Perhaps embed the application’s choice in an SQL comment? Q: … stored $_SESSION in the MySQL database for persistence, but when we measured query load with pt-query-digest, …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…is written in PHP so it is portable. Setting up FlexCDC FlexCDC has some basic requirements: MySQL 5….The file is well commented. The example settings file should work for most MySQL installations which allow… delete data in a second transaction: mysql> delete from test.demo where c1=1; Query OK, 1 …
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…so I decided it is worth commenting: 1. Using mysql_* functions directly This is probably …in MySQL you might be better of using several queries than doing complicated ones. Of course you would rather use IN… populate List for IN on your PHP application: SELECT * FROM articles WHERE user_id IN(23,545…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
…have several connections to MySQL server and right now running query which takes that long ? In any case … can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the … tools which could be helpful in this regard would appreciate your comments. There might be some …
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… has posted comments about them since more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0… in slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we propose Linux (AMD64 / Intel EM64T) binaries in tar…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…in the review process, but it’s not her responsibility alone. Brian P. commented: Q: If you’re writing Dynamic SQL in…. Their MySQL server became CPU-bound, while their multiple PHP application servers were…in the database must be protected again if you use query results in a subsequent SQL query…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… unfortunately very serious limitation in practice when you’re using MySQL with PHP as you can have single runaway query which takes a lot… PHP script is aborted). UPDATE: There are some comments saying experimenting with sleep() function is wrong and if I would use real MySQL queries…
Post: mk-query-digest, query comments and the query cache
… the LAMP stack. Instrumentation-for-php collects information about the PHP process such as wall time, cpu time, mysql query times, etc, and automatically… executed 1000 times in each iteration of the loop. The queries differ only by comments. In the best case scenario where comments are stripped we…