auto_increment Issue

Hi All I have created a table.Now I need to make a field Auto_increment...Help me with this issue..An example will do.. Regards Jnani -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: auto_increment Issue

Date: Fri, 10 Apr 2009 15:15:28 +0530 From: jnaneshwar.banta...@kavach.net To: mysql@lists.mysql.com Subject: auto_increment Issue Hi All I have created a table.Now I need to make a field Auto_increment...Help me with this issue..An example will do.. Regards Jnani Hi Jnani,

Re: auto_increment Issue

Hi While trying for the same,I am getting the following error Incorrect table definition; there can be only one auto column and it must be defined as a key Jnani Octavian Rasnita wrote: Or more simple: ALTER TABLE tbl modify id INT UNSIGNED NOT NULL AUTO_INCREMENT; -- Octavian

RE: auto_increment Issue

Date: Fri, 10 Apr 2009 15:55:33 +0530 From: jnaneshwar.banta...@kavach.net To: orasn...@gmail.com CC: defati...@hotmail.com; mysql@lists.mysql.com Subject: Re: auto_increment Issue Hi While trying for the same,I am getting the following error Incorrect table definition; there

Re: auto_increment Issue

Hi , Thanks,Its working now Jnani abdulazeez alugo wrote: Date: Fri, 10 Apr 2009 15:55:33 +0530 From: jnaneshwar.banta...@kavach.net To: orasn...@gmail.com CC: defati...@hotmail.com; mysql@lists.mysql.com Subject: Re: auto_increment Issue Hi While trying for the same,I am

MySQL 5.0.45-0 to 5.0.45-7

Hi all, because of OS upgrade (RHEL) we need to upgrade from 5.0.45-0 (rpm MySQL-server-community-5.0.45-0.rhel5) to 5.0.45-7. We have also a replication slave on another host with the same version (and I'm not sure if we have to upgrade that one too). It's only about an rpm RHEL package

Re: MySQL runs on 16-cores server

Moon's Father wrote: Hi. If the server has 16 cores, how to set parameters to make MySQL runs well. IIRC is mysqld multi threaded - so if you have parallel queries, mysqld will spam multiple threads across multiple cores. HTH, Uwe -- MySQL General Mailing List For list archives:

En Abril tenes 10% de descuento en todos los productos!

No te pierdas esta oportunidad. Hasta el 30 de abril tenés 10% de descuento en todas tus compras aplicando tu cupón de descuento: 10ABR09 Disfrutá, Ahorrá y Vestí tu Tiempo Libre con Alfest Store Ingresá aquí para visualizar la versión online:

Re: MySQL runs on 16-cores server

On Fri, April 10, 2009 05:24, Uwe Kiewel wrote: Moon's Father wrote: Hi. If the server has 16 cores, how to set parameters to make MySQL runs well. IIRC is mysqld multi threaded - so if you have parallel queries, mysqld will spam multiple threads across multiple cores. --- Don't

Re: MySQL runs on 16-cores server

On Fri, Apr 10, 2009 at 10:40 AM, Wm Mussatto mussa...@csz.com wrote: On Fri, April 10, 2009 05:24, Uwe Kiewel wrote: Moon's Father wrote: Hi.    If the server has 16 cores, how to set parameters to make MySQL runs well. IIRC is mysqld multi threaded - so if you have parallel queries,

Re: MySQL runs on 16-cores server

At 06:00 AM 4/10/2009, you wrote: Hi. If the server has 16 cores, how to set parameters to make MySQL runs well. Any reply is appreciated. Using more cores with MySQL doesn't mean it will run faster. In fact, it could slow it down. Make sure you have done benchmarking with your current

RE: S L O W query over internet

One interesting note is we have a server running on the remote end and we did a test and tried to access the remote end from the server location and there was no issue.What I am wondering now is if there are configuration settings slowing the connection down on one server but not the other.