… the release of Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add … of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * …without SSH (bug 1050537) * ss_get_by_ssh.php didn’t timeout commands that hang (bug 1160611) …
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… get response later. The MySQLnd driver has been available since PHP 5.3, and in most part it mimics the standard MySQLi driver…) { $link->query(“SELECT something FROM tableN WHERE “, MYSQLI_ASYNC); } $processed = 0; do { $links = $errors = $reject = array(); foreach ($all_links as $link…, we see that using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different nodes of Percona…
Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…-shared-compat x86_64 5.5.29-rel29.4.401.rhel6 percona 3.4 M php-mysql x86_64 5.3.3-14.el6_3 updates 79 k Installing for dependencies: Percona-Server-client-55 x86_64 5.5… if the user wants to install PS 5.5 alongside packages that depend on 5.1/5.0, the -shared packages will work together. For…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a statement…@1=2 /* INT meta=0 nullable=0 is_null=0 */ ### @2=0 /* INT meta=0 nullable=1 is_null=0 */ ### @3=’bar’ /* STRING(…a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for…
Comment: Read/Write Splitting with PHP Webinar Questions Followup
January 24, 2013 By 4 Comments
… repo for CentOS only supports PHP 5.3.3. The mysqlnd_ms plugin requires at least PHP 5.3.6, and preferable PHP 5.4.x. I found an alternative repo at Webtatic that offers a package for PHP 5.4…: undefined symbol: mysqlnd_globals in Unknown on line 0 Probably the binary of PHP 5.4.10 I installed from Webtatic was built…
Post: PHP vs. BIGINT vs. float conversion caveat
January 10, 2008 By 27 Comments
… running Linux with PHP 5.1.6 or 5.2.2, and also with PHP 4.4.2 on SPARC64 under NetBSD 3.0: s1=1125899906842625 s2=1125899906842625 However 32-bit FreeBSD with PHP 4.4… FreeBSD box with PHP 5.2.5 starts to emit all digits but still incorrectly: s1=1125899906842600 s2=1125899906842625 And PHP 5.2.2 on…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… running the SELECT portion, adding LIMIT 0 to the SELECT part of the query. convert.php This script takes as one argument…_id) group by customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo', 'dashboard_customer_sales... | 770793 | 3811 | | 2 | 6543 | 754138 | 3740 | | 3 | 5337 | 742034 | 3674 | | 4 | 5825 | 738420 | 3593 | | 5 | 5803 | 733495 | 3670 | | 6 | 1579 | 732507 | 3666…
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 49 Comments
…) FROM services WHERE id = 3 GROUP BY id; +—-+————————-+ | id | GROUP_CONCAT(client_id) | +—-+————————-+ | 3 | 5,6,7 | +—-+————————-+ Handling in PHP: old way: with group_concat: This should work faster, as we remove loop from PHP to…
Comment: MySQL Query Cache WhiteSpace and comments
June 5, 2009 By 9 Comments
… a PHP script and a table with ~400k rows. After restarting Mysql, to delete the cache, this is the result. Mysql : 5.0.51a-24 (Debian) PHP : 5.2.6-1+lenny2 with Suhosin-Patch 0.9.6.2 (cli) (built… 2 */ SELECT count(*) FROM `mytable` WHERE `myfield` LIKE “%c%” 0.00090503692627 seconds /* comment 3 */ SELECT count(*) FROM `mytable` WHERE `myfield` LIKE “%c…
Comment: Cache Performance Comparison
January 24, 2007 By 74 Comments
…: 146546 Gets/Sec: 682379.594121 eaccelerator 0.9.5 Time: 384131 Gets/Sec: 260327.856903 apc Cache 3.0.12 Time: 538942 Gets/Sec…($key); } echo (“eaccelerator Cache “); benchmark(“cache_eaccelaror”); config standard in php.ini for APC and eaccelerator extension=”eaccelerator.so” eaccelerator.shm….16-2-686 (Debian 2.6.16-16bpo1) (gcc version 3.3.5 (Debian 1:3.3.5-13))
