… MySQL Supplied by Distribution Vendor. Some vendors already offering MySQL 5.0.30 – Gentoo, Ubuntu and Debian at the time of this writing… recent version this is a way to go. The address for MySQL 5.0 is bk://mysql.bkbits.net/mysql-5.0 (HowTo Docs) Note… few people have access to. What is about free MySQL Enterprise Version ? Well at the time of this writing as far as I…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…use of Parameters (particulary OdbcParameter class in .NET) qualify as an appropriate security mechanism…load onto their database server. Their MySQL server became CPU-bound, while their…to use a stored procedure, even one that writes dynamic SQL. And it only takes one SQL injection vulnerability to…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘…delay=0 innodb-use-sys-stats-table innodb-write-io-threads=4 join-buffer-size=16M …log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we value throughput over response…
Post: MySQL Performance Blog now uses Sphinx for Site Search
February 15, 2008 By 52 Comments
… so I always used Google search if I wanted to find something on MySQL Performance Blog. Today we have published new search… weeks – just want to test it a bit more and write proper documentation before announcing. If you would like to test it however… make MySQL Performance Blog more useful for you. UPDATE: For those looking to download plugin code it is here: https://launchpad.net/wp…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… key and full table scans. To highlight different properties of storage…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 …
Post: xtrabackup-0.9
August 20, 2009 By 4 Comments
… 0″ Bug #394374: “Can’t compile with MySQL 5.1″ Bug #394781: “xtrabackup requires write permissions on original ibdata1″ Bug #395977: “xtrabackup….percona.com/mysql/xtrabackup/0.9/. The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad…
Post: SysBench - benchmark tool
August 18, 2006 By 20 Comments
… developed by Alexey Kopytov (software engineer @ MySQL AB) – http://sysbench.sourceforge.net/ and I want to write a short intro about this tool as… if you want to compare speed of file I/O and implementation of threads on different servers – I will write about in… Windows – well you can try and write about your experience. In next notes I’ll write how to setup and perform database benchmarks.
Post: xtrabackup-0.6
April 29, 2009 By 6 Comments
…_fast_shutdown=1 on xtrabackup shutdown – set innodb_write_io_threads=10 by default for fast…/ Intel 64bit there: http://www.percona.com/mysql/xtrabackup/0.6/. By the same link… https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system: https://launchpad.net/percona-…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…documentation Improvements to InnoDB IO. Improvements of InnoDB IO subsystem, such as multiple read and write threads,… : * in source code from Launchpad https://launchpad.net/percona-xtradb, the version 1.0.2…to use as drop-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql…
Comment: Making the impossible: 3 nodes intercontinental replication
January 12, 2012 By 29 Comments
… with mysql slaves, and all writes are directed to one master data center, then this is a lot faster. You can now write at any datacenter, which is closest to the user. The commit will be slower… is a net gain (if you have users spread around the world). If the answer is that you already write in multiple…
