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

2007-12-21 Thread cirisme
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 TAB

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

2007-12-21 Thread Baron Schwartz
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: Hi,I want to know how big to configurate the max-connections parameter in my.cnf?

2007-12-21 Thread Peng
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]

DB acts like a good db but is really corrupt?

2007-12-21 Thread cirisme
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: Applying LIMIT to SELECT count(*)

2007-12-21 Thread js
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 conte

Re: Applying LIMIT to SELECT count(*)

2007-12-21 Thread Urms
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 arc

Re: Applying LIMIT to SELECT count(*)

2007-12-21 Thread js
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 jo

Re: cache in mysql Windows

2007-12-21 Thread Paul DuBois
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.

MySQL5.1 estimated release date?

2007-12-21 Thread js
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: http://lists.m

cache in mysql Windows

2007-12-21 Thread Duhaime Johanne
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: Can anybody know how to determinate whether a variable 's type?

2007-12-21 Thread Kyo Peng
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: http://lists.mysql.c

Finding the 'nearest' text match

2007-12-21 Thread Edward Kay
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

Re: Odd item in MySql error log

2007-12-21 Thread Martin Gainty
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: Sent: Friday, December 21, 2007 4:52 AM Subject: Odd item in MySql error log >

regarding outfile

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

Applying LIMIT to SELECT count(*)

2007-12-21 Thread Urms
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 experimente

Re: Mysql and Perl

2007-12-21 Thread Jørn Dahl-Stamnes
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

Odd item in MySql error log

2007-12-21 Thread Ben Clewett
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 b