Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9

2006-02-24 Thread Javier Armendáriz
Can you tell us about your config parameters? Probably you must set up your max_connections, max_user_connections http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html Ady Wicaksono escribió: I have MySQL 5 installed on My Machine, But it could handle only max about 350 concurren

Re: Logging Data: Should I use MyIsam or InnoDB?

2005-01-19 Thread Javier Armendáriz
== Cuando todo esta bajo control, es que no vamos suficientemente deprisa ======== Javier Armendáriz [EMAIL PROTECTED]

Server speed working with databases and apache

2002-05-28 Thread Javier Armendáriz
Javier Armendáriz [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

What is wrong in this query???

2002-03-27 Thread Javier Armendáriz
Can someone tellme the problem in this query?? Is there any problem updating two tables in the same query??? update alumno, alumnocurso set alumno.nombre='Blas', alumno.apellidos='Martinez Maertinez', alumno.nacimiento='1990-09-12', alumno.telefono = '6', alumnocurso.incorpora

RE: MySQL can't tell the difference between two databases???

2002-01-15 Thread Javier Armendáriz
MySql > Asunto: Re: MySQL can't tell the difference between two databases??? > > > Is db2 a symlink to db1? > If it was deleting one database or table must delete de another one. Javier Armendáriz [EMAIL PROTECTED] ---

RE: MySQL can't tell the difference between two databases???

2002-01-15 Thread Javier Armendáriz
What happens if you try select * from db1.products and select * from db2.products;??? Doing that does the same? > -Mensaje original- > De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]] > Enviado el: martes, 15 de enero de 2002 13:24 > Para: Mailing list MySql > Asunto: Re: MySQL can't tell

Getting id asignet to an insert

2001-11-30 Thread Javier Armendáriz
Hi everybody: Can anybody tellme how can y get the id asigned to a record in the moment i insert data in the database? I need to storage transaction requests, the mysql database assigns an unique id (auto increment) to that record, and i need it to continue saving data in another table. Is ther

Re: Error codes list

2001-10-21 Thread Javier Armendáriz
Thanks a lot, as you know, I need to translate error codes (such as duplicate references) to the future (i hope) program operator. The error codes are for operators (those who write data into the catalog), not for public, I know PHP error reporting functions with MySQL, but i would like to wri

Error codes list

2001-10-21 Thread Javier Armendáriz
Hi Maybe it is in the manual, but i can´t find it in the way i need. Does anybody know where to find a complet list of MySQL error codes with number and descripcion in order to make a library for handling and reporting alerts to users in php Thanks a lot

Re: multiple-(BLOB)column, primary key for pre-v 3.23 db

2001-06-19 Thread Javier Armendáriz
way for do the same in a better way? Thanks Javier Armendáriz [EMAIL PROTECTED] Brian Warn wrote: > Hello, > > I want to use two text columns as my primary key. From the DuBois book, I see that >I cannot do this since my v. 3.22.32 tables are ISAM, and BLOB and TEXT columns >ca

RE: MySQL On Unix

2001-04-23 Thread Javier Armendáriz
Hi, You must install MyODBC in your Unix system, and the MyODBC module for windows. Once it is done, make a new connection trought this module whit de ODBC default fort, the machine name, user, pass and database. It was all I did and it worked correctly Javier

Re: INFO

2001-03-15 Thread Javier Armendáriz
MySQLGui is a good option in graphical mode, there are other command line clients too At 19.40 14/3/01 +0100, you wrote: >can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on >win nt ? >thank you in advance. >regards. > >Andrea GIGLIOTTI > >G&B Net S.n.c. >Via Bagni Caldi,

INNER JOIN problem

2001-03-12 Thread Javier Armendáriz
Attack ships on fire off the shoulder of Orion. I watched C-beams glitter in the darkness at Tan Hauser Gate. All those moments will be lost in time like tears in rain. Time to die. === Javier Armendáriz [EMAIL PROTECTED] --

Re: configuration

2001-01-16 Thread Javier Armendáriz
be lost in time like tears in rain. Time to die. ======= Javier Armendáriz [EMAIL PROTECTED] - Original Message - From: "funky gao" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: martes, 16 de enero de 2001 13:41 Subject: configurat

Off-topic, but database

2001-01-10 Thread Javier Armendáriz
ms glitter in the darkness at Tan Hauser Gate. All those moments will be lost in time like tears in rain. Time to die. ======= Javier Armendáriz [EMAIL PROTECTED] - Before posting, please chec