insert delayed on partitioned table

2009-06-26 Thread Ujang Jaenudin
lists, I have tried utilizing partitioning (mysql 5.1.35 advanced version) from mysql docs, it has been said that insert delayed on partitioning table isn't supported. and when perform insert like this: insert delayed into tbla values(...); the error that mentioned by documents is coming. but w

archive mysql data

2008-10-23 Thread Ujang Jaenudin
dear all, I need your direction about archiving mysql data. the scenario is: mysql on host A with dbname DB1 has the INSERT 90% and select 10% activities. mysql on host B with dbname DB2 as an archiver database of DB1 database. on DB1 the data will be purged daily on midnight. I need all the dat

Re: super-smack on mysql 5.0 solaris 10 x86_64

2008-10-16 Thread Ujang Jaenudin
on this machine there are libs from solaris package... bash-3.00# pkginfo | grep mysql system SUNWmysqlr mysql - MySQL Database Management System (root component) system SUNWmysqlt mysql - MySQL Database Management System (test component) syste

super-smack on mysql 5.0 solaris 10 x86_64

2008-10-14 Thread Ujang Jaenudin
all, does anyone has successful installing super-smack on solaris 10 x86_64 with mysql 5.0. I have installed, but when will doing stress testing, always complaining that client should be upgraded $ super-smack select-key.smack 30 1 super-smack: aborting because of a database error: Client