…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
… practice to offload traffic 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 users, recent posts… 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
…_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving….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… bad, as Percona has a fix for it – http://bugs.mysql.com/bug.php?id=45892
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving….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… bad, as Percona has a fix for it – http://bugs.mysql.com/bug.php?id=45892
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
…://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs Memcache is hard to… simplistic PHP command line tests. However, apples and oranges – think of features… see also http://de.slideshare.net/nixnutz/nosql-in-mysql Independent YCSB results would be interesting but require significant time to do.
Comment: Why MySQL Performance at Low Concurrency is Important
March 29, 2013 By 8 Comments
… be posting more SSB results which are low concurrency, as well as ones at higher concurrency too, but mysql currently has a… the same data degrade very quickly under concurrency. http://bugs.mysql.com/bug.php?id=68079 (Dimitri is working on it 
Post: Handling big result sets
June 26, 2006 By 13 Comments
… $result = mysql_query($query) or die(‘Query failed: ‘ . mysql_error()); // retrive result while ($line = mysql_fetch_array($result, MYSQL_NUM)) { } // Free resultset mysql_free_result($result…Let’s look mysql_query function: http://www.php.net/manual/en/function.mysql-query.php. Unfortunately there …
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… asynchronous call to send a query to MySQL using a new MySQLnd driver for PHP. In this post I’ll only show… to MySQL, and we do not wait for result but rather get response later. The MySQLnd driver has been available since PHP 5…)); As conclusion, we see that using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo...results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… | | statistics | 0.000005 | | preparing | 0.000006 | | executing | 0.000001 | | Sorting result | 0.000002 | | Sending data | 0.000040 | | end | 0.000003 | | query… as such I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that…
