puzzled issue for deadlock due to locking upgrade from LOCK_S to LOCK_X

Hi Guys, I got a deadlock problem, and it puzzled me days. Hope some body could help with some explanation for the reason of deadlock, better if some extra advises. * * *DeadLock Info:* * * - - - (1) TRANSACTION: TRANSACTION 13D947E32, ACTIVE 0 sec, process no 10928, OS

mysql tables are lost for DDL of "alter table .. add column ..."

mysql tables are lost for DDL of "alter table .. add column ..." *1. mysqld's error.log* 110803 3:39:16 InnoDB: Warning: problems renaming 'feel_22/#sql-2635_23d3a8' to 'feel_22/feed_send_1451', 25000 iterations （first 25000，fil0fil.c:: fil_rename_tablespace） InnoDB: Warning: tablespace './fe

Tables are lost for DDL and different behaviors for alter table failed situation between innobase and innodb_plugin

*summary:* Recently we hit lost tables during DDL for online products, and after some observersion, we found some interesting hehaviors if fil_rename_tablespace failed as retry > 25. That might be another issue that not discussed here. THERE MUST BE SINGLE TABLESPACE Here is the steps to show

mysql on raid 1 or raid 5?

hi all, currently, i have a machine with raid 1 and raid 5 (backplane). in order to boost up the mysql performance, does it advise install /var/ (mysql data directory) into raid 1 or raid 5? please advise. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

can i replicating innodb table?

can i replicating innoble tables? does the master db and the slave db will having the same of information when they are doing replication? thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql connectivity error

hi all, i have a mysql which only localhost can be logged in. if i have created an account [EMAIL PROTECTED], then, i cant login in as that host. mysql -u user -h mymachine.com -p ERROR 2003 (HY000) Cant connect to the MySQL server on 'x.x.x.x' (111) please advise. thanks -- MySQL General Ma

Re: default table type = innodb is stable??

Is that stable if i started mysql server by defining default_table_type = INNODB at the my.cnf file? from which by default my.cnf is defining MYISAM table to be the defaulted. Richard Dale wrote: this is my error log file. InnoDB: Error: log file ./ib_logfile0 is of different size

Re: default table type = innodb is stable??

Jigal van Hemert wrote: - Original Message - From: "Hiu Yen Onn" <[EMAIL PROTECTED]> if i uncomment it, then mysql server wont start at all. if i comment it, then, that's ok. please advise. thanks again If the mysql server does not start it will pr

Re: default table type = innodb is stable??

, then, that's ok. please advise. thanks again Hiu Yen Onn wrote: Are you using the my-innodb-heavy-4G.cnf file for your machine? i loaded the cnf file to /etc/my.cnf. then, it fails to start. what's wrong with it? mind to tell me on how to set the default table type equal to inno

Re: default table type = innodb is stable??

chine for mysql? thanks again Ady Wicaksono wrote: Currently i have 4 Gbyte RAM and RH 9 Linux using InnoDB and yes, it's stable :) Hiu Yen Onn wrote: hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will

default table type = innodb is stable??

hi, i have a machine with 6G memory, loaded with RHEL4. now, my question is mysql support innodb as the default table type? will be stable running RHEL4? i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the existing one (/etc/my.cnf). but, it failed to start the mysql server

Newbie: MySQL cluster configuration

b.cfg file. i have not noticed that file in my machine. weird pls give me more information and ideas.thanks -- Mr. Hiu Yen Onn System Administrator Shin Yang Group of companies Website: www.shinyang.com.my Email: [EMAIL PROTECTED] Tel: (6085)6

where is my my.cnf files??

hi, i compiled mysql-4.1.7 from source. actually, i want to configure a mysql cluster. from the documentation, i need to add some flag into a file called "my.cnf". i searched through the files. it consisted of my-small.cnf, my-medium.cnf, my-huge.cnf. but, i cant see the file my.cnf file. where

Re: mysql cluster installation

Hiu Yen Onn wrote: hi, I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7. but, i cant get the "ndbd" command to start my NDB. do i really need to install from tarball?? i am really new to MySQL clustering. all this while, i am using MySQL standalone database.

mysql cluster installation

hi, I wish to have clusters of MySQL. i installed it from RPM. version, 4.1.7. but, i cant get the "ndbd" command to start my NDB. do i really need to install from tarball?? i am really new to MySQL clustering. all this while, i am using MySQL standalone database. pls guide me... i am willing to

archive data

hi, i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13 using rpm package. by default, the data file of mysql is alocated at /var/lib/mysql, but i have a limited of diskspace of /var dir (it is about 1G), so, it was easily full loaded with data. now, i want to archive the da

Access my mysql db remotely...

i want to create a user who access from internet remotely to my db (outside firewall)? what is the solution then? how can i define the user accoutn? [EMAIL PROTECTED] Cheers, yenonn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m