Re: Background tasks performed by MySQL?

2005-11-17 Thread Viktor Fougstedt
the slowdown? Some form of lock contention having to do with new connections or similar? Can I reset the Max_used_connections parameter so I get a maxlevel for the last five minutes rather than since the last restart? Lots of questions, so I am deeply grateful for any insights into

Background tasks performed by MySQL?

2005-11-15 Thread Viktor Fougstedt
scriptions somehow ring a bell, I would welcome any insight I could get from the list. Thanks in advance, /Viktor... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Repeated, occasional 2002 Connect errors/Aborted connections

2005-10-20 Thread Viktor Fougstedt
x27;s almost 1%). If it is the mysql client connecting in these cases, the error code returned is 2002, but most connects come from other programs using libmysql. Can someone give us a hint what might be lacking in our setup to cause this behaviour? What can we alter to make this stop

Mysql 4.1.1a

2004-01-12 Thread Viktor
Hello mysql, Table-level privileges do not work at all... (on Windows) -- Best regards, Viktor mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

COMP_ERR is missing in windows binary distribution zip file of 4.1.1a

2004-01-12 Thread Viktor
Hello mysql, subj. It's inconvenient, because one should get source distribution and compile this tool. -- Best regards, Viktor mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Re: Strange sorting in table

2003-02-14 Thread Viktor Vasiliou
Paul, Thanks for the explanation! Best Regards, Viktor Vasiliou - Original Message - From: Paul DuBois To: Viktor Vasiliou ; [EMAIL PROTECTED] Sent: Friday, February 14, 2003 12:05 AM Subject: Re: Re: Strange sorting in table At 0:01 +0100 2/14/03, Viktor Vasiliou wrote: >Ok

Re: Re: Strange sorting in table

2003-02-13 Thread Viktor Vasiliou
Ok, I guess you're right. It's just that it has never happend to me before. Thanks for your help. Regards, Viktor - Original Message - From: Paul DuBois To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 11:48 PM Subject: Re: Re: Strange sorting in table >St

Re: Strange sorting in table

2003-02-13 Thread Viktor Vasiliou
DefaultExtra counteridmediumint(8) unsigned PRINULL auto_increment Regards, Viktor Vasiliou - Original Message - From: Paul DuBois To: Viktor Vasiliou ; Stefan Hinz Cc: [EMAIL PROTECTED] Sent: Thursday, February 13

Re: Strange sorting in table

2003-02-13 Thread Viktor Vasiliou
all get a new row when a user signup. First, an entry is created in "tblmembers" (using auto_increment). After that, an entry is created in two other tables (using mysql_insert_id to set the right ID in the primary key columns). Any idea? Regards, Viktor Vasiliou - Origin

Strange sorting in table

2003-02-11 Thread Viktor Vasiliou
Hi! I have a couple of tables in a MySQL database. In one of the tables, PhpMyAdmin sorts very strange. ID 1002 is places between ID 21 and ID 22. Any idea why? Best Regards, Viktor Vasiliou - Before posting, please check

How to retrieve record-id after 'insert into'?

2001-05-21 Thread Viktor van den Berg
ew record. I can set the record pointer to the last record, but if anybody else also inserts a record at the same time, I think this will give a problem. Can anybody give me a suggestion? thanks in advance, Viktor v/d Berg - Bef

EXCEPT statement in MYSQL?

2001-05-15 Thread Viktor van den Berg
t are only availlable in user1 or in user2. If the userid is availlable in user1 AND user2, then it won't be availlable in the result. The question is what syntax to use in MYSQL to achieve this result! Thanks in advance, Viktor v/d Berg - The Netherlands PS If the query isn't to comp