… to log file once php mysql_slow_log_parser.php mysql-slow-queries.log Options: -T=min_query_time Include only queries which…_rows_examined Include only queries which examined min_rows_examined rows or more -iu=include_user Include only queries which contain include_user in… in the user field [multiple] -iq=include_query Include only queries which contain the string include_query (i.e. database or table name…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… the fact table, respectively. There are nearly 400 major airports included in the data set. mysql> select count(*) from dim_airport… to examine a large amount of data. Shard-Query includes a loader (loader.php) which can be used to either split a…-Query. The author has previously worked in cooperation with Infobright, including on benchmarking. These particular tests were performed independently of Infobright…
Post: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… -q install Percona-Server-server-55 Percona-Server-shared-compat php-mysql Installing: Percona-Server-server-55 x86_64 5.5… -shared package, providing the older libmysqlclient.so.16 required by php-mysql. However, this has proved non-intuitive and problematic, since…. Installation instructions for Percona Testing repositories. We’re aiming to include these fixes in our next releases of Percona Toolkit 5…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…_fetch_array (here I use PHP functions but they are common or similar for all APIs, including C). Consider table: CREATE TABLE…’s look mysql_query function: http://www.php.net/manual/en/function.mysql-query.php. Unfortunately there is nothing interesting for our… slow down things a bit. So script with prepared statements: < ?php $mysqli = new mysqli(“localhost”, “root”, “”, “test”); /* check connection */ if (mysqli…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… ODBC with escaping code that is mature and thoroughly tested. PHP‘s PDO library does something similar, interpolating parameter values into… injection risks could affect the database. The DBA should be included in the review process, but it’s not her responsibility… server. Their MySQL server became CPU-bound, while their multiple PHP application servers were often idle, waiting for the database server…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… from its vantage point, which in many cases does not include network communication time which can be very important. Tracing should… requests, though it needs to be detailed. Typically you would include the calls to the lower level services together with timestamp… for nice example framework for instrumentation, check out instrumentation for PHP – It has everything mentioned by tracing which is trivial to…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1.37 as a base… also http://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php?id=42101 The builds for RedHat4…/5.1.37-7/ The latest source code of XtraDB, including development branch you can find on LaunchPAD. Please report any…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… stick with MyISAM) 1500M. See http://mysql.rjweb.org/doc.php/memory For InnoDB, innodb_buffer_pool_size = 5500M might be… mind the issues raised in http://mysql.rjweb.org/doc.php/myisam2innodb , starting with “Disk space for InnoDB is likely to… will greatly speed up INSERTs. > PRIMARY KEY (`ObjectClass`, `ObjInstance`, `UTCTime`), Including a time in a PK is usually a mistake, unless…
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
… an amazing effort from the (volunteer) AV team. I’ve included links to a selection of talks below that I especially… the database servers we all love and use. Migrating to PHP 5.4 Probably quite useful if you’re dealing with… I wasn’t in this session). Finding vulnerabilities in PHP code (via static code analysis) This one is for our …
Post: New Keynote Speakers and Sponsors and Applications Open for DotOrg Pavilion for Percona Live MySQL Conference and Expo
January 22, 2013 By Leave a Comment
…MySQL Conference and Expo 2013 keynote speakers and new sponsors including Amazon Web Services, Google, Clustrix, Scalebase, PalominoDB, Database Trends & …Sponsors: Database Trends & Applications, Linux Journal, O’Reilly, Web and PHP Magazine 2013 MySQL Community Awards Nominations are now open …
