Geting current user pasword.

2010-06-03 Thread Guillermo
Hello, I need to get the user and password from the current session. I found the user() function, wich gets the username, is there anything like that to get the password ? Thx Guillermo __ Información de ESET NOD32 Antivirus, versión de la base de firmas de virus 5170

Improve MYSQL performance on large database

2008-11-08 Thread Guillermo Nardoni
ame problem I'l give lots of "thanks" if you could show me the path to investigate. Regards Guillermo Nardoni Rosario - Argentina. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Performance problem with more than 500 concurrent queries

2008-06-27 Thread Guillermo . Acilu
Hi, Thanks for your suggestion. It looks like had a minor effect. I see sometimes 4 or 5 queries running. But it is not much different in general. Regards, Guillermo From: jocelyn fournier <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Date: 27.06.2008 12:41 S

Re: Performance problem with more than 500 concurrent queries

2008-06-27 Thread Guillermo . Acilu
s At 10:39 AM 6/26/2008, you wrote: >Hello, > >thanks for the answer. > >Where is the error.log stored? I run the mysqladmin, it requires the >password and it exits immediately. But I cannot find any error.log. > >Thanks, > >Guillermo Guillermo, Look in the

Re: Performance problem with more than 500 concurrent queries

2008-06-26 Thread Guillermo . Acilu
Sorry about the long signature in the email. I forgot to remove it... Guillermo From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: 26.06.2008 17:39 Subject: Re: Performance problem with more than 500 concurrent queries Hello, thanks for the answer. Where is the error.log stored? I

Re: Performance problem with more than 500 concurrent queries

2008-06-26 Thread Guillermo . Acilu
Hello, thanks for the answer. Where is the error.log stored? I run the mysqladmin, it requires the password and it exits immediately. But I cannot find any error.log. Thanks, Guillermo --- Guillermo Acilu Senior Engineer, Koiaka GmbH Koiaka GmbH Riesserkopfstr. 17 82467 Garmisch

Performance problem with more than 500 concurrent queries

2008-06-26 Thread Guillermo . Acilu
some points in common with mysql to gain performance, but I cannot find the source of the problem. I am with Mac OS X Leopard in a very fast machine and MySQL 5.0.51b. The problem is also present in 5.1.25-rc Any ideas why is this happening? Thanks, Guillermo

easy - optimizing query

2007-06-21 Thread Guillermo
,T2.field2 from T1) as P1 left join (Select sum(T2.field4) from Table2) as P2 on P1.field1 = P2.field1 thx, Guillermo

Shape Command

2007-06-08 Thread Guillermo
Hello, Does anyone knows if MySQL supports ADO´s "shape" command ??? Guillermo

Coping table

2007-01-05 Thread Guillermo
ver, and i want/need to do that on a client machine...¿what should i do? Guillermo

RE: Good book

2004-08-27 Thread "Chinchilla Zúñiga, Guillermo"
I suggest: For PHP and MySQL: PHP and MySQL Web Development (Sams Publishing) by Luke Welling and Laura Thomson For MySQL: MySQL (second edition) by Paul Dubois -Mensaje original- De: Scott Hamm [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 27 de Agosto de 2004 11:16 a.m. Para: 'My

RE: GUI for MySQL

2004-08-12 Thread "Chinchilla Zúñiga, Guillermo"
I would suggest DBDesigner available on http://www.fabforce.net/ -Mensaje original- De: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 12 de Agosto de 2004 12:09 p.m. Para: '[EMAIL PROTECTED]' Asunto: GUI for MySQL This is my first attempt to design and test MySQL. I ha

RE: MySQL know

2004-08-11 Thread "Chinchilla Zúñiga, Guillermo"
En español lo más útil que he visto es: www.mysql-hispano.org/ Para crear tablas y en general para hacer algo útil en MySQL se necesita aprender SQL, hasta donde yo se, con solo MySQL instalado no vas a poder crear aplicaciones y solo podrás interactuar con el por medio de la línea de comandos

RE: sql function for timestamp

2004-07-14 Thread "Chinchilla Zúñiga, Guillermo"
In MySQL you can do that with: DATE_FORMAT DATE_FORMAT (column_name,'%Y-%m-%d %H:%i') -Mensaje original- De: J S [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 14 de Julio de 2004 08:26 a.m. Para: [EMAIL PROTECTED] Asunto: sql function for timestamp Hi, What SQL function do I need to

RE: DBF to MySQL

2004-07-07 Thread "Chinchilla Zúñiga, Guillermo"
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Thanks, John on 7/6/04 3:59 PM, Chinchilla Zúñiga, Guillermo at [EMAIL PROTECTED] wrote: > Try, for example: > > LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable > FIELDS TERMINATED BY ',' ENCLOSED BY '"' >

RE: DBF to MySQL

2004-07-06 Thread "Chinchilla Zúñiga, Guillermo"
Try, for example: LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; -Mensaje original- De: John Mistler [mailto:[EMAIL PROTECTED] Enviado el: Martes, 06 de Julio de 2004 04:51 p.m. Para: [EMAIL PROTECTED] Asunto: DBF to M

RE: Recommendation on god MySQL books

2004-06-17 Thread "Chinchilla Zúñiga, Guillermo"
I think Wiley´s Mysql enterprise solutions could be a good option. It´s a great book and have an entire chapter covering replication -Mensaje original- De: Bartis, Robert M (Bob) [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 17 de Junio de 2004 11:44 a.m. Para: [EMAIL PROTECTED] Asunto:

Perfomance issues

2004-03-12 Thread "Chinchilla Zúñiga, Guillermo"
Hi folks: I would like to know if there are a perfomance loss using PEAR DB comparing with PHP native Mysql functions, and if this is a significant issue. Also I´m wondering if using persistent connections in PHP could lead to have many connections at the same time slowing the server, and how t

Perfomance issues

2004-03-11 Thread "Chinchilla Zúñiga, Guillermo"
Hi folks: I would like to know if there are a perfomance loss using PEAR DB comparing with PHP native Mysql functions, and if this is a significant issue. Also I´m wondering if using persistent connections in PHP could lead to have many connections at the same time slowing the server, and how t