Dear Peter, I finished the Python version, which is usually 3-5 times faster than the … 3 seconds, remove duplicates and save result to file php mysql_filter_slow_log.php -T=3 -eu=root –no-duplicates… root and test tail -f -n 0 linux-slow.log | python mysql_filter_slow_log.py -T=3 -R=10000 -eu=root…
Post: Alternatives of PHP ?
September 9, 2006 By 28 Comments
… refresh my mind. List of my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good…, Erlang, Python, Ruby, LISP, Scheme, Lua, Eiffel, C#, SML, Perl, TCL and rest. Unfortunately my first requirement of support MySQL narrows the list to Perl, Ruby, Java, C, C++, even Python supports only old mysql protocol (am I…
Comment: New patches, new builds
September 10, 2008 By 24 Comments
…@record mysql_highperf]# rpm -ihv MySQL-percona-highperf-3-5.0.68-0.rhel5.src.rpm 1:MySQL-percona-highperf-########################################### [100%] [root@record mysql_highperf]# rpmbuild -ba /usr/src/redhat/SPECS/mysql-percona.rhel5.spec error… you could let us know what to do 
Versions: rpm-python-4.4.2-48.el5 rpm-libs-4.4.2…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… indexes, changing data type, converting data to different character set – MySQL master-master replication especially accompanied by MMM can be very… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication… one can just enter commands from cli, execute some php/python/ruby script or anything else. Most importantly – this must actually…
Comment: Slow Query Log analyzes tools
February 3, 2007 By 84 Comments
… a Google Code project for the MySQL Slow Query Log filter: http://code.google.com/p/mysql-log-filter/ You can access the initial PHP5 script here (requires the PHP extension BCMath): http://mysql-log-filter.googlecode.com/svn/trunk/mysql_filter_slow_log.php I am planning to provide a Python version, too…
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
… used SAN block-level replication to maintain a standby/failover MySQL system, and there was a failover that didn’t work… of data that were obviously from other files, such as Python exception logs. The SAN snapshot was useless for practical purposes… way. At a higher level, MySQL replication has the same weakness. If you rely on a MySQL slave for a “backup,” you…
Comment: Watch out for your CRON jobs
October 19, 2009 By 19 Comments
…/perl/php/python/ruby scripts that are cron jobs that only do database reads/writes, and can be converted to MySQL Events. Obviously if there are actions outside MySQL, it’s not useful as a MySQL Event. Pythian actually…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… of these bugs!) This brings us to our first bug: mysql process crashes after setting innodb_dict_size The basics of… command to execute the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to/Percona-Server –suite=randgen_basic innodbDictSizeLimit_test… create multiple schemas and we did via a little randgen / python magic: # populate our server with a test bed test_cmd…
Comment: MySQL Master-Master replication manager released
April 6, 2007 By 27 Comments
… some scripts written in Perl or Python and some cron scripts in shell simply calling mysql to run some queries. Regarding Master… is however making it 100% clean way if you care. MySQL replication is async which is first part so you will…
Comment: Alternatives of PHP ?
September 9, 2006 By 28 Comments
you’re right, python‘s connector does not support server-side prepared statements yet. neither does the pure ruby connector (ruby/mysql), but the one built on top of libmysql (mysql/ruby) does. jim
