June 19, 2013

Post: MySQL, AIX5L and malloc()

to run MySQL database on AIX 5L operating system. You compiled it successfully, configured and.. unluckily database didn’t start due tobit compiled applications. But how to deal with 64-bit systems? It’s quite easy, but you have to remember about setting OBJECT_MODE to 64 for both, self-compiled

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

to see how Falcon performs in comparison to… NULL default ”, `city` varchar(64) NOT NULL default ”, …Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql…but MyISAM scales a bit better in …

Post: PBXT benchmarks

… this case (no disk IO) to see how efficient storage engines are in terms …MySQL version We used MySQL 5.1.16-beta sources for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilationbit better. Unfortunately InnoDB shows bad scalability for 8CPU box, in many cases the transition from 16 threads to 64