Building 5.1.38-maria packages
We’ve been able to do MySQL 5.1 binary tarballs for a bit now (great working together with Kristian Nielsen of Monty Program), but packages are bit more tricky. Peter has been working on Debian/Ubuntu while I’ve focused on RH/CentOS. The following is from an OurDelta (trial build run) RPM install on CentOS 5 x64:
$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.38-maria-beta1-ourdelta (OurDelta - http://ourdelta.org/) mysql> CREATE TABLE test.t1 (i int) ENGINE=PBXT; Query OK, 0 rows affected (0.10 sec) mysql> SHOW CREATE TABLE test.t1\G *************************** 1. row *************************** Table: test.t1 Create Table: CREATE TABLE `test.t1` ( `i` int(11) DEFAULT NULL ) ENGINE=PBXT DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> INSERT INTO test.t1 values (1); Query OK, 1 row affected (0.03 sec) mysql> SELECT * FROM test.t1; +------+ | i | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> SHOW ENGINE PBXT STATUS\G *************************** 1. row *************************** Type: PBXT Name: Status: 090929 23:05:41 PBXT 1.0.08d RC STATUS OUTPUT Record cache usage: 65675 Record cache size: 33554432 Record cache high: 65675 Index cache usage: 0 Index cache size: 33554432 Log cache usage: 295128 Log cache size: 16756712 Data log files: 1 row in set (0.00 sec)
So yes, PBXT is fully in there, as is XtraDB (the enhanced InnoDB plugin).
mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_version'; +----------------+----------+ | Variable_name | Value | +----------------+----------+ | innodb_version | 1.0.3-6a | +----------------+----------+ 1 row in set (0.00 sec)
Tags: centos, innodb, mariadb, mysql, ourdelta, pbxt, xtradb
October 15th, 2009 at 12:36 pm
Why didn’t have freebsd,MacOSX build?
October 15th, 2009 at 12:45 pm
Hi fire9.
Priorities.
OSX tends to not be a production platform, and FreeBSD is relatively rare for production also these days. Both are relatively easily built from source anyway.
If you are interested in packages for either, please feel free to help with the scripts and other things needed for those builds!
Simply join the ourdelta project on Launchpad.
October 17th, 2009 at 9:41 pm
great work! Thank you so much.