June 19, 2013

Post: ZFS on Linux and MySQL

with servers located in two data centers, one with Solaris servers and the other one with Linux servers. The Solaris… write cache use.  Even the fairly slow gzip-1 mode works well.  The tpcc…interesting solution for MySQL backup servers.  All backup solutions have an impact on performance with ZFS …

Post: Interesting MySQL and PostgreSQL Benchmarks

in this test. Woodcrest has best performance in this test (and in many other MySQLSolaris comparison is also pretty interesting. With MySQL Linux has higher peak but Solaris suffers less with

Post: Heikki Tuuri answers to Innodb questions, Part II

performance within December 2006 with a large patch, and the ‘last’ serious bug in it was only recently found and fixed: http://bugs.mysqlperformance of Innodb on Solaris? HT: Yes, if your ‘write working set’ fits in

Post: Using LVM for MySQL Backup and Replication Setup

with similar features set for other operation systems. Veritas File System can do it for Solarisperform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… you can skip slow query logs and… also clones inconsistences in data which slave …

Post: Percona Server 5.1.58-12.9

performance when using compressed tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL… #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow …is incompatible with Percona Server with XtraDB, …been fixed on Solaris (supported platform) and Windows…

Post: Effect of adaptive_flushing

performance of InnoDB Plugin 1.0.5 in the wild, which Yasufumi wrote about previously here and here. The server in question was Solaris 10 withmysql

Post: Alternatives of PHP ?

… XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need that ? 1. PHP is slow – I… new protocol with prepared statement is necessary. – good XML handling – Fast in terms of performance and development – multiplatform, at least Linux, Windows, Solaris necessary…