Re: How to extend innodb files?

2010-09-27 Thread Carlos Proal
You have to round the size of the last data file (ibdata4) and add the new ones. You can find more information on the manual: http://dev.mysql.com/doc/refman/5.1/en/innodb-configuration.html http://dev.mysql.com/doc/refman/5.1/en/adding-and-removing.html Carlos On 9/28/2010 12:59 AM, Vokern wr

How to extend innodb files?

2010-09-27 Thread Vokern
Hello, Currently I have the setting: innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend Because the last file of ibdata4 is very large (more than 50G), if I want extend the data to more files, for example, ibdata5, ibdata6... how to do it? Thanks! -- MySQL Gener

Re: Persistent Connection VS One Time Connection Was Update Table

2010-09-27 Thread Willy Mularto
I have checked Apache's log. There is no refused connection. And also with MySQL I have set it to 999 connections and view the processes. Maximum connection ever reached was only around 200. What I'm thinking now is. Is it because of I use one time connection method? I mean every time the script

RE: Segmentation fault - Redhat Linux 64 Bit

2010-09-27 Thread Gavin Towey
Either 1. Use strace to find out where it's getting a segfault, or 2. Use gdb and get the backtrace where crashes. -Original Message- From: Sharath Babu Dodda [mailto:sharath.do...@gmail.com] Sent: Monday, September 27, 2010 3:17 PM To: mysql@lists.mysql.com Subject: Segmentation fault -

Segmentation fault - Redhat Linux 64 Bit

2010-09-27 Thread Sharath Babu Dodda
Hi there, I installed Apache, MySQL and PHP on Redhat Linux 64 bit. However, when I try to invoke MySQL, I'm getting the Segmentation fault error and I'm not able to see the "mysql" prompt. Begin of problem: ### [...@xyz123 bin]$ sudo ./mysql

Segmentation fault - Redhat Linux 64 Bit

2010-09-27 Thread Sharath Babu Dodda
This email may contain confidential information the use of which by an unintended recipient is unauthorized. For details please go to http://www.scotiabank.com/email_disclaimer/email_english.html Cette transmission peut contenir de l'information confidentielle et son utilisation par toute pe

Posting to the mailing list.

2010-09-27 Thread Sharath Babu Dodda
This email may contain confidential information the use of which by an unintended recipient is unauthorized. For details please go to http://www.scotiabank.com/email_disclaimer/email_english.html Cette transmission peut contenir de l'information confidentielle et son utilisation par toute pe

Re: multiple aliases

2010-09-27 Thread Shawn Green (MySQL)
On 9/27/2010 9:10 AM, Ramsey, Robert L wrote: I have a query with three subselects, all referencing the same table. I'd like to be able to combine them into one with aliases. Here's what I have now: select letter_codename, (select greek from letter_otherlanguages where letter ='A') as greek,

RE: multiple aliases

2010-09-27 Thread Travis Ard
I don't believe it's possible to do what you're suggesting. At least, according to the second example on this page: http://dev.mysql.com/doc/refman/5.1/en/subquery-errors.html. -Travis -Original Message- From: Ramsey, Robert L [mailto:robert-ram...@uiowa.edu] Sent: Monday, September 2

Re: Best encription method?

2010-09-27 Thread Vikram A
Dear Sir, Thank you for the suggestion, as you suggested i shall go for application level. I have another query too, please answer, Normally, If i need to store an integer value i have to define it as int, If I encrypt this, i must define its type as string of different size[it depend upon t

Re: Best encription method?

2010-09-27 Thread Johan De Meersman
Both have benefits. Application level: - data is encrypted during transmit, too - processing is offloaded from your hard-to-scale database server - decrypt keys don't pass your database, so dba or other users can't peek DB - Guaranteed consistent implementation regardless of client

Best encription method?

2010-09-27 Thread Vikram A
Hello experts! Can i have your valuable suggestion on the following? I would like to encrypt a particular table of records. I hope can choose two ways,number one, application level encryption method choosing our own encryption algorithm and an another is database level encryption. my question

multiple aliases

2010-09-27 Thread Ramsey, Robert L
I have a query with three subselects, all referencing the same table. I'd like to be able to combine them into one with aliases. Here's what I have now: select letter_codename, (select greek from letter_otherlanguages where letter ='A') as greek, (select french from letter_otherlanguages where

Re: Update Table

2010-09-27 Thread Nigel Wood
On Mon, 2010-09-27 at 11:25 +0100, Willy Mularto wrote: > Hi, > I work on MySQL 5 with PHP 5 and use Apache 2 as the webserver. I have a > simple query that searches matched row id and update the field via HTTP GET > query. On a low load it succeed update the row. But on high traffic sometimes

Update Table

2010-09-27 Thread Willy Mularto
Hi, I work on MySQL 5 with PHP 5 and use Apache 2 as the webserver. I have a simple query that searches matched row id and update the field via HTTP GET query. On a low load it succeed update the row. But on high traffic sometimes it failed to update some rows. No errors return by the script.

Re: Advanced query help

2010-09-27 Thread Johan De Meersman
Then you'll probably need to define it with a separate select before using it. I'm half-guessing here, really, but that sounds like it makes sense :-) On Mon, Sep 27, 2010 at 11:49 AM, Tompkins Neil < neil.tompk...@googlemail.com> wrote: > Hi, > > I did try defining it before the IF statement, bu

Re: Advanced query help

2010-09-27 Thread Tompkins Neil
Hi, I did try defining it before the IF statement, but still the same ? Cheers Neil On Mon, Sep 27, 2010 at 7:58 AM, Johan De Meersman wrote: > At a guess, because you use @team in an if statement before you actually > define it. > > > On Sun, Sep 26, 2010 at 12:35 AM, Tompkins Neil < > neil.to