… the script. If xinetd is not installed yet, you can install it with yum. # yum -y install xinetd The servie itself should be… –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf… mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… so do not work well for a lot of installations, especially as MySQL Server do not offer any enforcements – ie there is… to filter the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do…
Comment: How to check MySQL Config files
December 27, 2011 By 7 Comments
… MySQL Password you specified during the MySQL installation). MySQL Settings define(“MYSQL_HOST”, “localhost”); define(“MYSQL_USER”, “root”); define(“MYSQL_PASS”, “password”); define(“MYSQL_DB“, “test”); $conn = mysql_connect(“”.MYSQL_HOST.”", “”.MYSQL_USER.”", “”.MYSQL_PASS…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…command. In this example I’m going to install the tools in /root/recovery-tool folder… 6120 FIELDS: emp_no from_date DB_TRX_ID DB_ROLL_PTR salary to_date INDEX…: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL…
Comment: Choosing innodb_buffer_pool_size
January 24, 2010 By 39 Comments
… fine expecially the mysql directory… Cool (I thought) now with a working mysql installation + the exact logs file size + all the db folders and… really soon… It is not like that.. Bad story… their db operations were started in jan 2007, the server died on…
Comment: 5.0.87-build20 Percona binaries
November 18, 2009 By 3 Comments
Is it worth/recommended to downgrade from a non RedHat RPM 5.1.40 MySQL installation to this Percona build? Which would have better performance? MySQL for dedicated CentOS 5.4 DB server focused on performance. Thanks
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) …db=dummyData #binlog-ignore-db=edmunds #binlog-ignore-db=evox #binlog-ignore-db=jato #binlog-ignore-db=kbb binlog-ignore-db=mysql binlog-ignore-db=test #binlog-ignore-db…
Post: New patches, new builds
September 5, 2008 By 24 Comments
…_INDEXES | +————————-+———–+————–+———————-+ | art86.forum86 | 469084 | 54 | 162 | | mysql.db | 36 | 0 | 0 | | art57.link_out57 | 59336163 | …install it and run mysql with option –skip-innodb. We think InnoDB plugin is stable enough to use it with MySQL…
