Odd item in MySql error log

MySql 5.0.41 SUSE 10.2 Linux dbms-04-r1 2.6.18.2-34-default #1 SMP Mon Nov 27 11:46:27 UTC 2006 x86_64 x86_64 x86_64 GNU/Linux Dear MySql, I have an odd item in my error log, I wonder if you can tell me what this means? Also whether should do anything about it? (This table once corrupted

Re: Mysql and Perl

On Monday 25 September 2006 20:09, George Law wrote: damn outlook! fire up perl's CPAN interface: perl -MCPAN -eshell cpan i /mysql/ ... Bundle Bundle::DBD::mysql (C/CA/CAPTTOFU/DBD-mysql-3.0007.tar.gz) ... cpan install Bundle::DBD::mysql Hello again... I'm back to this

Applying LIMIT to SELECT count(*)

Hi, My task is to limit calculation of total number of items in the database that satisfy certain conditions. I join two tables using WHERE and there are millions of records as the result. When I do SELECT count(*) it takes really too long. The table has appropriate indexes and I

regarding outfile

-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Odd item in MySql error log

Good Morning Ben this is an acknowledged bug http://bugs.mysql.com/bug.php?id=20090 which was fixed in 5.1.22-beta + can you upgrade? Martin-- - Original Message - From: Ben Clewett [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 21, 2007 4:52 AM Subject: Odd item in

Re: Can anybody know how to determinate whether a variable 's type?

On Dec 21, 2007 7:45 PM, Moon's Father [EMAIL PROTECTED] wrote: If you know ,just tell me,thanks. etc. declare cnt int default 0; How can I know what type the variabe cnt is? Can't 'desc table' show what you want? -- MySQL General Mailing List For list archives:

Finding the 'nearest' text match

I have two datasets that I wish to relate together using the company name. The problem is the same company may have a slightly different name in each the two datasets. What I want to do is for each company name in dataset A, find the 'nearest' n matches to it in dataset B. e.g. If I have 'Alkool

MySQL5.1 estimated release date?

Hi, A silly question. Is there anybody knowing estimated GA release date for MySQL 5.1? I heard it was planed to be released in december this year and the latest release 5.1.22 is RC, but seems that it will not happen soon. Thanks. -- MySQL General Mailing List For list archives:

cache in mysql Windows

Hello We are doing some performance tests and would like to disable the cache. We did set the query_cache_size=0 but it did not have any effect as well as a select no_cache. The process is a select on MyISAM table. We are using a Mysql 5.0.27. We are wondering if Mysql uses a file to cache or

Re: cache in mysql Windows

At 9:01 AM -0500 12/21/07, Duhaime Johanne wrote: Hello We are doing some performance tests and would like to disable the cache. We did set the query_cache_size=0 but it did not have any effect as well as a select no_cache. The process is a select on MyISAM table. We are using a Mysql 5.0.27.

Re: Applying LIMIT to SELECT count(*)

If exact number isn't important, you might want to try table_rows in information_schema.tables or show table status. On Dec 21, 2007 7:53 PM, Urms [EMAIL PROTECTED] wrote: Hi, My task is to limit calculation of total number of items in the database that satisfy certain conditions. I join two

Re: Applying LIMIT to SELECT count(*)

The problem is that there are certain conditions after WHERE different for each query and the results number can be very different. -- View this message in context: http://www.nabble.com/Applying-LIMIT-to-SELECT-count%28*%29-tp14453544p14459808.html Sent from the MySQL - General mailing list

Re: Applying LIMIT to SELECT count(*)

Oh, I misunderstood,sorry. Using summary tables doesn't work for you? On Dec 22, 2007 3:00 AM, Urms [EMAIL PROTECTED] wrote: The problem is that there are certain conditions after WHERE different for each query and the results number can be very different. -- View this message in context:

DB acts like a good db but is really corrupt?

I have one table in my database that is completely unhappy with mysqldump. However, it acts like it's just fine. Performing checks on this table comes up okay: mysql CHECK TABLE post; ++---+--+--+ | Table | Op| Msg_type | Msg_text |

Re: Hi,I want to know how big to configurate the max-connections parameter in my.cnf?

On Dec 22, 2007 10:55 AM, Moon's Father [EMAIL PROTECTED] wrote: how big your mysql connections's users. How big users? don't know what you said. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DB acts like a good db but is really corrupt?

Hi, On Dec 21, 2007 8:08 PM, cirisme [EMAIL PROTECTED] wrote: I have one table in my database that is completely unhappy with mysqldump. However, it acts like it's just fine. Performing checks on this table comes up okay: mysql CHECK TABLE post;

Re: DB acts like a good db but is really corrupt?

On Dec 21, 2007, at 9:15 PM, Baron Schwartz wrote: Hi, On Dec 21, 2007 8:08 PM, cirisme [EMAIL PROTECTED] wrote: I have one table in my database that is completely unhappy with mysqldump. However, it acts like it's just fine. Performing checks on this table comes up okay: mysql CHECK TABLE