…/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… KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT a…’]==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… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort… Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend framework libmemcached PECL module Zend…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… threading and internal queues) that accepted connections from the app (php, java, python, etc) and then passed the traffic over to… aim to show just how far things have come with MySQL clustering performance: http://themattreid.com/wordpress/2013/03/01/building-a-mysql-private-cloud-step-1/ — this will be a series of posts over time (as I have…
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: Why MySQL Performance at Low Concurrency is Important
March 29, 2013 By 8 Comments
… to be posting more SSB results which are low concurrency, as well as ones at higher concurrency too, but mysql currently has… the same data degrade very quickly under concurrency. http://bugs.mysql.com/bug.php?id=68079 (Dimitri is working on it 
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… post is the sixth of a series that started here. From the previous posts of this series, we now have an HA MySQL… instance) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW… option would be to change the IP address in a php configuration file.
Post: Dot-Org Pavilion at the Percona Live MySQL Conference
February 8, 2012 By Leave a Comment
… a cross-post from my personal blog. Are you involved with an open-source project that’s interesting to MySQL users, such as Nginx, PHPMyAdmin, Drupal, Jenkins, PHP, and so on? Percona just published… have a free expo hall booth in the Percona Live MySQL Conference in April. Please submit your applications now, and tell…
Post: Life Beyond MySQL
September 27, 2006 By 3 Comments
… be doing some Web projects on my own, besides doing MySQL Consulting. I think some people thought I am just using… view NewsGroups as blog, meaning threads starts are showed as posts and replies are shown as comments. It is quite early… what this size is developed on – it uses Linux/Apache/PHP/MySQL of course plus Sphinx for full text search.
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… process SBR changes from a MySQL master. I’ll talk more about that in another blog post. FlexCDC does not implement a…. FlexCDC is written in PHP so it is portable. Setting up FlexCDC FlexCDC has some basic requirements: MySQL 5.1+ row based… 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: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… Cluster nodes in parallel with MySQL asynchronous calls [/caption] This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona… MySQL using a new MySQLnd driver for PHP. In this post I’ll only show how to make these calls, and in following posts…)); As conclusion, we see that using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different…
