… | test | Sleep | 49 | | NULL | | 2 | msandbox | localhost | test | Query | 35 | Waiting for table metadata lock | RENAME TABLE test to test_2 | | 3 | msandbox | localhost | test… I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…) made a good candidate for testing, as it had been tested before:Another MPB postLucid DB testing The raw data is a completely… the previous baseline test. This VM was rebooted between tests. A SQL script was fed to the run_query.php script and the… testing was limited to a subset of Vadim’s test queries (see that post). As this new test schema is normalized, Vadim’s test…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… the table: < ?php $link = mysql_connect(‘localhost’, ‘root’, ”) or die(‘Could not connect: ‘ . mysql_error()); mysql_select_db(‘test‘) or die(‘Could… things a bit. So script with prepared statements: < ?php $mysqli = new mysqli(“localhost”, “root”, “”, “test“); /* check connection */ if (mysqli_connect_errno()) { printf…
Comment: Read/Write Splitting with PHP Webinar Questions Followup
January 24, 2013 By 4 Comments
… is kind of suspicious. Then I tried running “make test” and PHP threw: PHP Warning: PHP Startup: Unable to load dynamic library ‘/root/mysqlnd… run into similar problems: https://bugs.php.net/bug.php?id=60706 https://bugs.php.net/bug.php?id=62276 I conclude that to… to take on the work of installing custom builds of PHP or other platform technology. They want to use an official…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… real tables so I’ve got the script and ran tests for MyISAM and Innodb tables on ext3 filesystem. Here is… ~]# for i in 1 10 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create… time update is a lot of overhead. During this last test box felt really sluggish responding 10+ seconds for as simple…
Comment: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
…::$db in /home/html/QDU/libs/Database/Database/pdo.php on line 166 PHP Notice: Undefined variable: errorinfo in /home/html/QDU/libs/Database/Database/pdo.php on line 177 PHP Fatal error: Can’t connect to the database server. (test@:/) SQLSTATE[HY000] [2005] Unknown MySQL server host ‘localhost:3306′ (0) [#2005] in /home/html/QDU/libs/Database/Database.php on…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… (dual core with HT enabled). Since my goal is to test concurrency, I decided to use only one warehouse for DBT2…` do numconn=$((i*20)) echo “Doing $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2…` do numconn=$((i*100)) echo “Doing $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2…
Comment: Cache Performance Comparison
August 4, 2009 By 74 Comments
… only access the memory cache from the local PHP process. Â I have not tested it but I am unsure if that means you can access it from CLI PHP as well as via PHP running… memcached is possible but not with APC as it is PHP specific. Â For more information on performance and advice on…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
… do some tests on the matter: I did the test two ways. First using command line client and second using little PHP script… can see the comments are actually skipped: | 798009298 | root | localhost | test | Query | 4 | Sending data | select count(*) from fact where val… not use MySQL Command Line Client for any tests involving comments Repeating queries from PHP instead we can learn the following about…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… as well as > other complex conectors. I have not yet tested PDO but would not > expect it to beat MySQLi in…’s not as common. > I would also note for many PHP applications abstraction layer is > not the main performance problem, also… it will however start > to crawl. > So developing you PHP applications use test database with reasonable > amount of data in it. And…
