Re: a mysqldump causes all other queries to be queued super slow. Any clue what is going on?

2010-03-22 Thread Andres Salazar
k this is a bigger issue then just a mysqldump. Iam trying to figure out why or where should i look. Andres > > -- > William R. Mussatto > Systems Engineer > http://www.csz.com > 909-920-9154 > > > -- > MySQL General Mailing List > For list archive

a mysqldump causes all other queries to be queued super slow. Any clue what is going on?

2010-03-22 Thread Andres Salazar
free up immediately. What could be causing this? I know there might be many factors involved but Id like to get some clues as to where to look. Thanks Andres -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch

How to benchmark OpenBSD for Mysql .

2010-02-28 Thread Andres Salazar
Hello, Iam a OpenBSD user. I would like to know if there is any technique specific to the US to be able to benchmark the IO for this OS. Also, what result would be considered acceptable and what is not. Thanks!! Andres -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: problems with a select

2007-02-26 Thread Raul Andres Duque
I'm spanish speaker too .. but I write it in english for everyone can read it. The version 5 implements subqueries. You can do something like: SELECT id_room FROM rooms WHERE id_room NOT IN (SELECT id_room FROM reservations WHERE date = '22-03-07'); Regards, RAUL DUQUE Bogotá, Colombia ---

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-23 Thread Raul Andres Duque
Why you always talk about *client* fee ?? what about the server? Sincerily, I'm see MySQL is not the best option for a commercial application (you don´t distribute you application with GPL lincense). Postgresql is a excellent DB using BSD license and the last version improve the speed reponse.

Re: [LICENSING] why so hazy? Comparing to Samba.

2007-02-22 Thread Raul Andres Duque
What do the license say about using MySQL on web aplications (with PHP)?? Regards, RAUL DUQUE Bogotá, Colombia - Original Message - From: "mos" <[EMAIL PROTECTED]> To: Sent: Thursday, February 22, 2007 3:32 PM Subject: Re: [LICENSING] why so hazy? Comparing to Samba. At 12:51 PM

Re: One thread takes over the whole server

2004-03-09 Thread andres
, 2 SCSI HD 10.000RPM INTEL MB running SuSE Linux 9.0, my.cnf = example my.medium Andres Hocevar VENEZUELA > [EMAIL PROTECTED] wrote: >> Hi >> >> I need to prevent users from holding down the server,issuing the next >> query the server becomes so slow that the other

One thread takes over the whole server

2004-03-08 Thread andres
Hi I need to prevent users from holding down the server,issuing the next query the server becomes so slow that the other clients can't even login!, the tables are around 6Million records: SELECT (some fields ), sum(more fields) AS calcfield FROM table1 INNER JOIN table2 ON ... INNER JOIN ta

100 million row limit (Part 2)

2003-12-28 Thread Andres Montiel
. Why would the documentation discuss the 100 million row limit if, apparently, MySQL can indeed go beyond this limit? Also, is going beyond the 100 million row limit documented (aside from http://www.mysql.com/doc/en/Table_size.html)? - Andres -- MySQL General Mailing List For list archives: http://

100,000,000 row limit?

2003-12-22 Thread Andres Montiel
I was informed that MySQL has a 100,000,000 row limit. Is this true? We were planning to use MySQL for an inventory system. However, our current data (rows) for 1 year for one area is already 8.8 million. We want to place data for 5 years for 7 areas. This would exceed 100,000,000. Is there a possi

Error updating slave list: Query error / replication on 4.0.4-beta

2002-11-18 Thread Andres CALDERON
osition 4 Would you please tell me what this error means? What should I read/try? I'm using a fresh snapshot and I've deleted the binary logs... I have searched the web but I think this does not happen often. Thanks, Andres.- _ D

Override date format in MyODBC

2001-11-24 Thread Andres Portillo
is set to mm/dd/ (This setting is controlled in the windows control panel), but I want to be able to get the next value 1/11/2001 (dd/mm/) without modifying the computer settings. I'd appreciate any idea or comment. Thanks in advance. a

Service not starting properly

2001-10-05 Thread Andres Adamoli
in order to make it work. I could not find any log messages, nor help on the documentation. Any ideas? Thanks a lot. Andres [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manua

RE: password()

2001-08-23 Thread Andres Berger
warranty could help. --- Andres Berger Garcia Gerente de Marketing Preventix S.A.C. --- www.zapantivirus.com --- - Original Message - From: s. keeling <[EMAIL PROTECTED]> To: mysql_mailing list <[EMAIL PROTEC

RE: Nesting Problem for Multilevel Marketing

2001-08-20 Thread Andres Berger
om network where id1 in (select id2 from network where id1=1) and so on. (Note that the subquery is the same as the previous query) You must change this to use temporary tables because MySQL doesn't support subselects yet. :-( Hope that help you --- Andres Berg

RE: Mysql to Mdb

2001-04-17 Thread Sascha Andres
hi, > Hello > > I need export data from MySql to Access(MDB), but must to be in > Web. I'm use PhpMyAdmin. which platform do you use? i had a similar problem with access to mssql, where i could not access the sql server via the administration toolkit. so i wrote an asp script that created the ta

Support MySql and Delphi

2001-04-09 Thread Andres Melai
subject: [EMAIL PROTECTED] Remite: Guillermo Guzman Ramirez Ibague - Colombia - Sur America Would you please help to repair/Corrige an error that occured with mySQL and Delphi; The error is like this ; error 127 from table handler We noticed that the table, which we do SELECT is out of ord

Support

2001-04-04 Thread Andres Melai
Remite: Guillermo Guzman Ramirez Ibague - Colombia - Sur America Would you please help to repair/Corrige an error that occured with mySQL and Delphi; The error is like this ; error 127 from table handler We noticed that the table, which we do SELECT is out of order and I named the original

Split results

2001-03-19 Thread Andres M.V. Paglayan
Hi you all, I´m trying to resolve how to manage a large resultset (about 500), showing only 20 rows per page and then to have the option to show more results from several buttons, like when you search something with a lot of pages in the yahoo, Best wishes for you all. Thanks in advance. -

MYSQL failes at startup

2001-02-18 Thread Sascha Andres
hi, on a suse 7.1 system my mysql fails on startup. it can't create a pid. how can i fix this ? sascha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Server error: Segmentation fault

2001-02-01 Thread Andres Valenciano
010201 x:y:z mysqld restarted /usr/bin/safe_mysqld: line 254: 29350 Segmentation fault $NOHUP_NICENESS $ledir ( .. a long line...) $pid_file --skip-locking >>$err_log 2>&1 Any idea? I am totally lost with this... :( Th