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.

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 com

Re: MySQL runs on 16-cores server

On Fri, Apr 10, 2009 at 10:40 AM, Wm Mussatto 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, mysqld

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. ---^^

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: http://www.vestitutiempolibre.com.ar/news/Promoc

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 archive

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

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 upgra

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

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: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

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