Re: SAN and ibdata files

iguration, the lun/volume should 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,

Re: SAN and ibdata files

e. but still the error. I will overcome 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, > > > &

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 /ops

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 bi

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: how to get Number of rows matched?

t, 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

Re: how to get Number of rows matched?

ww.the-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 > > AFA

Re: how to get Number of rows matched?

0 rows affected (0.00 sec) * Rows matched: 1 Changed: 0 Warnings: 0 * Thanks ViSolve DB Team. ----- Original Message - From: "Ace" <[EMAIL PROTECTED]> To: "ViSolve DB Team" <[EMAIL PROTECTED]> Cc: Sent: Monday, June 11, 2007 5:04 PM Subject: Re: how to get Num

Re: how to get Number of rows matched?

". ---after 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

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 out

Re: MySQL in multi-threaded environment

n one time the same 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

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 PROTECTE

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: Sent: Wednesday, May 30, 2007 1

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 Errors

Re: French Characters, Still no answer

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 of

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)); // o