… newer version of iiBench (the python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench…
Comment: High Rate insertion with MySQL and Innodb
March 29, 2012 By 16 Comments
Thanks Peter, it worked! 
I am using python and MySql 5.5, I have an XML file which I parse …
Post: Percona is looking for a Perl and Python expert
June 24, 2008 By 6 Comments
If you’re a Perl and/or Python expert (preferably both), Percona may have a job for you. … sponsor significant development efforts for some open-source tools for MySQL, including but not limited to Maatkit and the Master-Master…. You can expect expert guidance and help (especially with the MySQL-specific parts), but a significant amount of freedom and autonomy…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 83 Comments
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: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL and Web Servers is rather good practice. It is more…’re running 500 Apache children with mod_P (php,perl,python) per box (which is probably bad idea anyway). The good…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… unfortunately, no tests have been created for the main MySQL branch. The MySQL at Facebook branch has a number of tests that… two reasons: My attempts at copying the Facebook multi-threaded python load-generation code seemed very, very slow I just like… master has crashed and restarted: $ ./kewpie.py –suite=innodbCrash –basedir=mysql-5.5 –test-debug crashCommitAfter_test 20111221-142500 INFO MASTER…
Post: Looking for High Performance MySQL Interns
September 2, 2007 By 1 Comment
… Intern position (with limited compensation) to work on project of MySQL Performance research and analysis, developing and running benchmarks under our… benchmark results. Working us you would learn a lot about MySQL Architecture, Unix/Linux Operating Systems and Hardware Performance Optimization, Performance… and curious. You should know MySQL and some programming languages (C/C++ and Perl PHP or Python), you should be familiar with…
Comment: Percona is looking for a Perl and Python expert
December 8, 2008 By 6 Comments
… Python also its issues w/ threading. These are mainly due the the fact that there is no native mysql interface and the python interpreter is not truly threaded. Once it drops into a c function python loses all… hundreds of mysql instances you could easily kernel panic the box with that many forks. Until python has a native mysql interface Jython…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 37 Comments
… the beloved pager option in mysql monitor isn’t supported on Windows. Running scripts in Perl or Python requires you to install software from ActiveState of some other Perl/Python vendor and is sometimes limited. (The 64-bit MySQL Python module is only available if you bought a support contract). On CentOS/RHEL/OEL: The system MySQL is easy…
Post: dbqp and Xtrabackup testing
November 16, 2011 By Leave a Comment
… paradigm. While this sounds fancy, basically, we take advantage of Python’s unittest and write classes that use their code. The… step forward. We can now write actual, honest-to-goodness Python code to test the server. On top of that, we… run them: $./dbqp.py –suite=xtrabackup_basic –basedir=/path/to/mysql –xtrabackup-path=/mah/path –innobackupex-path=/mah/other/path –default…
