MySQL: large_page_size

2009-05-21 Thread Krishna Chandra Prajapati
Hi, How much performance improvement we can get using large_page_size in mysql server. Is there anybody using on productions. Thanks, Prajapati Krishna Chandra Prajapati Email-id: prajapat...@gmail.com

Re: MySQL: large_page_size

2009-05-21 Thread Johnny Withers
I tried it on win32, it worked but the server failed under heavy load. I'd suggest running mysql on a 64 bit Linux machine instead. Jw On Thursday, May 21, 2009, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi, How much performance improvement we can get using large_page_size in

6.0.11 source

2009-05-21 Thread Alex Katebi
Anyone knows where I can download the 6.0.11 gziped source from?

RE: mySQL slave IO Running and SQL Running

2009-05-21 Thread Jerry Schwartz
I'm not running with replication, but I AM often running the CLI against the production and test environments at the same time. I found it invaluable to add the line prompt=\h to my.ini (I'm running on Windows). That adds the host name to the prompt, and has saved my butt more than once.

General Question..

2009-05-21 Thread HINOJO RUELAS ARTURO
Hello all, Hope you are doing well, I have a general question creating foreign keys , I'm creating FK from catalog tables to relation tables with them, when I create a FK in innodb engine on MYSQL a new field with the same name of the FK is created, in this case if I create for example 3 FK

Re: Upgrade Mysql

2009-05-21 Thread Webmaster Studio Informatica
Thank You for all the help. I was upgrading from 4.0.x to 5.0.x The new mysql recognized the old databases without problems. Bye :)

Date Time

2009-05-21 Thread John Meyer
Is Thu May 21 03:15:28 + 2009 a valid date/time string? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Date Time

2009-05-21 Thread Martin Gainty
mysql select sysdate() from DUAL; +-+ | sysdate() | +-+ | 2009-05-21 17:37:13 | +-+ i would get the proprt format is i could CONVERT_TZ to work can you get CONVERT_TZ to work ? Martin Gainty

cannot alter table - rather urgent

2009-05-21 Thread PJ
I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the primary key (which should not exist) or delete the foreign keys nor remove the constraint. G search doesn't help. CREATE TABLE `book_categories` ( `bookID` smallint(6) unsigned NOT

Re: cannot alter table - rather urgent

2009-05-21 Thread Michael Dykman
On Thu, May 21, 2009 at 11:06 PM, PJ af.gour...@videotron.ca wrote: I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the primary key (which should not exist) or delete the foreign keys nor remove the constraint. G search doesn't help.

Re: cannot alter table - rather urgent

2009-05-21 Thread Peter Brawley
I cannot insert values into the tables What is the error message? Has the smallint key run out of values? and I cannot alter or delete the primary key (which should not exist) Eh? Without a PK, it ain't a table. or delete the foreign keys nor remove the constraint. G search doesn't help.

Re: cannot alter table - solved

2009-05-21 Thread PJ
Michael Dykman wrote: On Thu, May 21, 2009 at 11:06 PM, PJ af.gour...@videotron.ca wrote: I have a seemingly impossible situation. I cannot insert values into the tables and I cannot alter or delete the primary key (which should not exist) or delete the foreign keys nor remove the