…: http://phptechnicalgroups.blogspot.co.il/2013/05/simple-mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql php CREATE TABLE `menu` ( `id` int(11) NOT NULL auto…’]==0) { echo “” . $row['label'] . “”; } else; } echo “”; } display_menu(0, 1); ?> Posted by bikash ranajan nayak at 10:30 AM
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static pages) Full objects (user… Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL module…
Comment: Percona MySQL Webinar: Really Large Queries: Advanced Optimization Techniques, Feb. 27
March 25, 2013 By 2 Comments
Hi Tony, You can also post this to our MySQL discussion forums http://www.perconaforum.com/index.php?t=thread&frm_id=10& I’ll be adding a general MySQL category in a few weeks but in the meantime this would be the best place to post it.
Comment: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 13, 2013 By 5 Comments
Anthony, that’s an excellent question. The supported method is to use the Galera arbitration daemon and you can find documentation on that here: http://www.codership.com/wiki/doku.php?id=data_backup This is a good topic for a followup blog post, stay tuned…
Comment: Why MySQL Performance at Low Concurrency is Important
March 29, 2013 By 8 Comments
I am going to be posting more SSB results which are low concurrency, as well as … degrade very quickly under concurrency. http://bugs.mysql.com/bug.php?id=68079 (Dimitri is working on it 
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… parallel with MySQL asynchronous calls [/caption] This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona XtraDB… MySQLnd driver for PHP. In this post I’ll only show how to make these calls, and in following posts how to measure latency to all nodes. PHP…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… a demonstration of the utility. As a reminder, the first post covered the following topics: What is a materialized view(MV… master. I’ll talk more about that in another blog post. FlexCDC does not implement a full binary log parser. Instead… capture the initial binary log position. php ./setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php setup starting setup completed If the setup…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Combating “data drift” In my first post in this series, I described materialized views (MVs). An MV …_id) group by customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo', 'dashboard_customer_sales... 'complete refresh' section. I'll discuss others in future blog posts. Enable the view to use it The SQL_API call…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… large amount of data. Shard-Query includes a loader (loader.php) which can be used to either split a data into… loading. The splitting/loading process will be described in another post. Complex queries Shard-Query was tested with the simple single table version of this data set in a previous blog post. Previous testing was limited to a subset of Vadim’s…
Comment: Alternatives of PHP ?
September 10, 2006 By 28 Comments
… is Sunday\’s piece of flame. I\’m still using PHP for next bunch of XMLs. 1) Speed. I\’m speaking… debugging cli php scripts? 3) memory: I\’ve posted bug report about memory consumption in libxml: http://bugs.php.net/bug.php?id=38604… I\’m not Rasmus, but IIRC I started to use PHP in 1997 when I made my first website for my…
