Re: Unbelieveable with 4 Gbytes - MySQL 5 only 350 concurrent mysql connection... on Linux Redhat 9
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 concurrent mysql connection Unbelieveable, i have 4 Gbytes, but on the next 351 connection i always got Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in Is it mysql bug, incorrect Linux setting or what? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Logging Data: Should I use MyIsam or InnoDB?
Martijn Tonies wrote: Hello Jeremy, I have a curious issue here, maybe someone can help. I have a single process that inserts data into tables that contain purely logging information. This table is then searched by our Care department to troubleshoot issues. I am looking for the best way to store this data, and the structure on the backend. There are 50 million inserts into table LOG a day. The primary index on the table is seconds from 1971. Sorry, as I understand, there are not 5000 seconds in a day, so it can not be primary key. OK, how about this: Use MyISAM and MERGE tables. Keep one table per day. E.g.: log_2005_01_15 log_2005_01_16 log_2005_01_17 log_2005_01_18 etc. Use MERGE tables to give you the 60 day (and perhaps e.g. 14 day, 30 day, 7 day, etc.) read views that you need, like so: CREATE TABLE log_view_7day ( ... ) TYPE=MERGE UNION=( log_2005_01_12, You can then do all of your inserts from the log writer into the today table, and do your reads against the various MERGEs. Every day at exactly midnight, you would use ALTER TABLE (which is atomic) to redefine the UNION of the MERGE definition of the various tables. Modifying metadata because you need a different view at your data. Am I the only one to which this sound ugly? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server Upscene Productions http://www.upscene.com -- Cuando todo esta bajo control, es que no vamos suficientemente deprisa Javier Armendáriz [EMAIL PROTECTED]
What is wrong in this query???
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.incorporacion = '2002-3-16', alumnocurso.finalizacion='-0-0', alumnocurso.observaciones = 'Observaciones id 4' where alumno.id = '4' and alumnocurso.id = '4' and alumno.id = alumnocurso.id_alumno ; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL can't tell the difference between two databases???
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 the difference between two databases??? It's something like this: mysql use db1 mysql select * from products; ++-+-+--+--+ | Id | Ref | Version | Type | Name | ++-+-+--+--+ | 1 | XXX | 1 |1 | XXX | ++-+-+--+--+ 1 row in set (0.27 sec) mysql use db2 mysql select * from products; ++-+-+--+--+ | Id | Ref | Version | Type | Name | ++-+-+--+--+ | 1 | XXX | 1 |1 | XXX | ++-+-+--+--+ 1 row in set (0.16 sec) I'm sure the table products on database db2 is empty, because of the results I get when I remove db1 from the system. The same select returns empty. Hope that helps. Thanks. Nuno A. S. Gonçalves [EMAIL PROTECTED] - Original Message - From: Duncan Hill [EMAIL PROTECTED] To: Nuno Gonçalves [EMAIL PROTECTED] Cc: Mailing list MySql [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 12:13 PM Subject: Re: MySQL can't tell the difference between two databases??? On Tue, 15 Jan 2002, Nuno Gonçalves wrote: The only way I seem to be able to access the data on database B is to remove the other database from MySQL. From my tests it seems that MySQL only uses the table name to access the data (not using also the database name). The sql queries you are using on your database would help. We are not mind-readers (well, I'm not!). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL can't tell the difference between two databases???
I really don´t undarstand My Linux is working fine in a situation like yours. I´ve simulated your situation mysql use db2; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from tab1; +++ | id | name | +++ | 1 | javier | +++ 1 row in set (0.00 sec) mysql use db1; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql select * from tab1; Empty set (0.00 sec) My database and table description: ysql use db1; Database changed mysql show tables; +---+ | Tables_in_db1 | +---+ | tab1 | +---+ 1 row in set (0.01 sec) mysql describe tab1; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | varchar(10) | YES | | NULL|| +---+-+--+-+-++ 2 rows in set (0.00 sec) mysql select * from tab1; Empty set (0.01 sec) mysql use db2 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show tables; +---+ | Tables_in_db2 | +---+ | tab1 | +---+ 1 row in set (0.00 sec) mysql describe tab1; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | varchar(10) | YES | | NULL|| +---+-+--+-+-++ 2 rows in set (0.00 sec) mysql select * from tab1; +++ | id | name | +++ | 1 | javier | +++ 1 row in set (0.01 sec) And finally my server and sistem data: mysql status; -- mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686) Connection id: 6 Current database: db1 Current user: [EMAIL PROTECTED] Current pager: stdout Using outfile: '' Server version: 3.23.44 Protocol version: 10 Connection: linux2 via TCP/IP Client characterset:latin1 Server characterset:latin1 TCP port: 3306 Uptime: 7 hours 27 min 52 sec Red Hat Linux release 7.0 (Guinness) Kernel 2.2.16-22 on an i586 -Mensaje original- De: Gerald Clark [mailto:[EMAIL PROTECTED]] Enviado el: martes, 15 de enero de 2002 15:35 Para: Nuno Gonçalves CC: Mailing list 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] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Getting id asignet to an insert
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 there a method for doing this whitou problems of concurrent users in the database??? Tahnk a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error codes list
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error codes list
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 write some functions to analize errors when they happend, break the program execution and tell operators what is happending (in spanish and in a language they could understand). What i´m looking for is a complet lits in some way like this : Error code numbrer (not DEFCON 5 :-)) Error descripcion Thanks a lot for your interest and help Apologize my macarronic english, when i get rich with this progect i´ll travel to great britain in order to learn some good english (and taste english beer and women) At 12:02 21/10/01 +0100, DL Neil wrote: 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 Hola Javier, Yes it is in the manual - but try the PHP manual (not MySQL's). The PHP online annotated manual is 'down' at the moment (update happening?) so I can't give you a reference - apologies. In addition to the familiar PHP-MySQL functions, eg mysql_query($sqlQuery, $dbLink) There are two more: mysql_errno() and mysql_error() which return an error number and error text (from the 'latest' MySQL function executed) - or zero and empty-string if the execution 'worked'. It's important to perform error-checking, but some would suggest that it should not be reported to users - under 'normal' circumstances!? Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multiple-(BLOB)column, primary key for pre-v 3.23 db
Hi, No problem in my case, i´m using varchar inorder to get url and image paths and works well, and they are indexed in some cases. Blob fiels make tables work slower? Does they use much disk? I´m meking a database with descriptions of buildings usin blob for descriptions. Is there another 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 cannot be indexed. Besides upgrading to v. 3.23+, is there any workaround to this? One column will simply store really long URL values (300 characters max, I'm guessing), and the other column stores graphic image names, probably 50 characters max in length. Any reason why varchar wouldn't work for this? Thanks, Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL On Unix
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 Armendáriz [EMAIL PROTECTED] -Mensaje original- De: Janos Borbely [mailto:[EMAIL PROTECTED]] Enviado el: lunes, 23 de abril de 2001 9:12 Para: [EMAIL PROTECTED] Asunto: MySQL On Unix Dear Gents, I would like to access MySQL database running on Unix from a Windows workstation through ODBC. IS it possible? Can you give me a tip how to do that? Thanks a lot for your help! Regards Janos Borbely - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INFO
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 GB Net S.n.c. Via Bagni Caldi, 11 55021 Bagni di Lucca (LU) Tel. 0583-805533 Fax 0583-807912 http://www.g-bnet.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php