Re: SAN and ibdata files

appear just like a locally attached physical disk on your server. MySQL will not need any special configurations to access it, just poiint the datadir to the SAN disk. Regards, Scott Tanner On Mon, 2007-10-08 at 11:06 +0530, Ace wrote: Thanks Dan! We do know the permission problem. We tried

Re: SAN and ibdata files

this somehow.but my Biggest worry now is - can I configure Mysql to use SAN location? if not, why? Thanks, Rajan On 10/7/07, Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Oct 06), Ace said: Hi Experts, You all know the size problems with ibdata and log files. We plan to move

SAN and ibdata files

Hi Experts, You all know the size problems with ibdata and log files. We plan to move those files to SAN to have maximum storage possible. We did so with configuration changes in my.cnf files to save log and ibdata files on SAN location. But got following error - InnoDB: Unable to lock

MySQL database move

Hi, We have crisis. Disk with MySQL database is full. Now we want to move database to another disk. How can we do it? -- Thanks, Rajan

Re: MySQL database move

Will try with dump and moving logs. Can I just move my datadir=/usr/local/mysql/data to some other location and change it in my.cnf? Will there be any complications to this? Thanks, Rajan On 7/8/07, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Ace, Can't you zip or move old bin-logs

how to get Number of rows matched?

Hi Experts, When issuing updates in mysql (in the console window), mysql will tell you if any rows matched and how many rows were updated (see below). I know how to get number of rows udpated using mysql_affected_rows(), but is there any way to get the number of rows matched? I want to find

Re: how to get Number of rows matched?

filtering out the matched row, it check whether there is need to change the old value to new value. if need then flags Changed and rewrite the same in the datafile/rollback segment. Thanks ViSolve DB Team. - Original Message - From: Ace [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday

Re: how to get Number of rows matched?

: 1 Changed: 0 Warnings: 0 * Thanks ViSolve DB Team. - Original Message - From: Ace [EMAIL PROTECTED] To: ViSolve DB Team [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, June 11, 2007 5:04 PM Subject: Re: how to get Number of rows matched? Ok..thanks! But my problem here is how

Re: how to get Number of rows matched?

-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: ViSolve DB Team [mailto:[EMAIL PROTECTED] Sent: Monday, June 11, 2007 6:15 AM To: Ace; mysql@lists.mysql.com Subject: Re: how to get Number of rows matched? Hi AFAIK, before changing data, the old values

Re: how to get Number of rows matched?

but, for PHP. the string returned by mysql_info() is all you get. The format of that string is very regular and we have been using it in production software for well over a year now with no issues. - michael On 6/11/07, Ace [EMAIL PROTECTED] wrote: Yes, you are right! mysql_info() is not most useful

Re: MySQL in multi-threaded environment

query ( perhaps, the mutex on pool-query is enough ) Try to limit mutexes only where it's necessary and be aware where you're locking and unlocking them. Regards, Geoffroy. 2007/5/30, Ace [EMAIL PROTECTED]: Hi Friends, I am facing problem while using MySQL in multi-threaded environment. I am

Re: MySQL in multi-threaded environment

Thanks! but I am already using table locks...any other thoughts? Cheers, Rajan On 5/29/07, sangprabv [EMAIL PROTECTED] wrote: Maybe need to lock the table Regards Willy - Original Message - From: Ace [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, May 30, 2007 12:22 PM

Re: MySQL in multi-threaded environment

Yes, I am using InnoDB. On 5/30/07, sangprabv [EMAIL PROTECTED] wrote: Hi, What is your table engine? AFAIK it is recommended to use InnoDB than MyISAM. Regards Willy - Original Message - *From:* Ace [EMAIL PROTECTED] *To:* sangprabv [EMAIL PROTECTED] *Cc:* mysql@lists.mysql.com

MySQL in multi-threaded environment

Hi Friends, I am facing problem while using MySQL in multi-threaded environment. I am using C lang for developement. I maintain MySQL connection pool between threads but with increase in number of requests, it started reporting following errors - == Server

Re: French Characters, Still no answer

that use mySQL with some script language using base64 encoding/decoding funtions for non latin1 letters is the safest way (however you cannot strictly predict the lenght of the encoded string based on the lenght of the plaintext). best regards --- Ace Dimitrievski, research assistant, Faculty

bug? in OPTIMIZE TABLE command

Description: If I use a table containing AUTO_INCREMENT field, and I have there a 0 value, OPTIMIZE TABLE will fail. How-To-Repeat: CREATE TABLE test( ID DECIMAL(5,0) NOT NULL AUTO_INCREMENT, text CHAR(20) NOT NULL, PRIMARY KEY(ID)); //