BladeCenter of IBM and MySQL

Hi all The company that I'm work for use very intensive MySQL dB on 32 bit platform. because of the limitation of Innodb on linux 32bit (kernel2.6) we've decided to buy a bladecenter of IBM with 14 blades to replace the current configuration. we thought of buying 64 bit Opteron dual core dual C

The best way to configure innodb tablespace

Hi I'm running MySQL 4.0.25 on a Linux machine dual xeon 3.0GB Ghz(32 bit) with 6 GB RAM the data is connected to a SAN storage I wander what is the best tablespace configuration (except RAW) of configuraing? my configuration is as follows: innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3

UNIQUE issue at mysql 4.* and mysql 5.*

Hi all I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow | manager_new | CREATE TABLE `manager_new` ( `id` bigint(20) NOT NULL auto_increment, `id_from_hits` bigint(20) default NULL, `from_ip` varchar(15) default NULL, `pool` char(1) NOT NULL default 'n', `to_ip` varchar

UNIQUE issue at mysql 4.* and mysql 5.*

Hi all I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow | manager_new | CREATE TABLE `manager_new` ( `id` bigint(20) NOT NULL auto_increment, `id_from_hits` bigint(20) default NULL, `from_ip` varchar(15) default NULL, `pool` char(1) NOT NULL default 'n', `to_ip` varchar