…mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql php… $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent… Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL module Zend…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…you are not going to have good performance results. Prior to 5.6 foreground threads were …02/mysql-56-is-much-faster-on-io-bound.html) but that patch can’t be used …mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…you are not going to have good performance results. Prior to 5.6 foreground threads were …02/mysql-56-is-much-faster-on-io-bound.html) but that patch can’t be used …mysql.com/bug.php?id=68658 http://bugs.mysql.com/bug.php?id=68588 http://bugs.mysql.com/bug.php?id=68555 http://bugs.mysql.com/bug.php…
Post: Handling big result sets
June 26, 2006 By 13 Comments
… way is send query via mysql_query and than handle the result in loop mysql_fetch_array (here I use PHP functions but they are… second one is result mode : MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT. (Also there can be used pair mysql_real_query / mysql_use_result or mysql_store_result, which are the…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… can use mysql_unbuffered_query instead and mysqli and PDO have their own way to reach similar behavior. This call users underlying mysql_use_result API call which does not store all result set in memory but instead streams it… you can’t use mysql_num_rows() and mysql_data_seek() if you use this method but this is told in PHP manual and so…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… new asynchronous call to send a query to MySQL using a new MySQLnd driver for PHP. In this post I’ll only show… as $k=>$link) { if ($result = $link->reap_async_query()) { $res = $result->fetch_row(); # Handle returned result mysqli_free_result($result); } else die(sprintf(“MySQLi Error…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…000005 | | preparing | 0.000006 | | executing | 0.000001 | | Sorting result | 0.000002 | | Sending data | 0.000040 | | end |…a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata …using MySQL version < 5.5 as the datastore. There was another interesting case this time with how Active MQ uses MySQL…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… these tests. Tests were done with PHP 5.2.5 and Apache 2.0.59. Results were a bit surprising: Running “TightLoop… is unfortunately very serious limitation in practice when you’re using MySQL with PHP as you can have single runaway query which takes… PHP script is aborted). UPDATE: There are some comments saying experimenting with sleep() function is wrong and if I would use real MySQL…
