I believe that this will flush those logs:
mysql reset master;
-- Greg
On Thu, Jan 22, 2004 at 05:23:07PM -0500, Asif Iqbal wrote:
Hi All
My data file has all these files
(root)@webrt:/usr/local/mysql/data# du -sh *
25K ib_arch_log_00
3.0Kib_arch_log_02
3.0K
Don't forget to run optimize table after you build
the combined index or make significant changes.
-- Greg
PS: Sorry to hear of MySQL's gender issues ;-)
On Mon, Jan 19, 2004 at 10:20:12AM -0500, Balazs Rauznitz wrote:
I saw surprisingly slow query results on columns that were indexed.
There is an issue in ISAM/MyISAM tables of needing to have correctly
sized row pointers. I submitted this as a bug report (it's really a
documentation bug), but don't know if it will be fixed. I was happy
to get an answer, though, so will share it with you :-)
If you get an error like this:
On Fri, Jan 16, 2004 at 10:14:08AM -0800, Andrew Kwiczola wrote:
I was wondering how many records A mysql table can comfortably handle.. and
which table type supports the greatest amount of record capacity. Can I
have a few million records in 1 table? Over 10 million? Thanks !
Hi, Andrew.
I'm using MySQL for an information retrieval application where word
occurrences are indexed. It seems that performance is not as good as
I would expect (it seems nearly linear with the number of rows).
Any advice would be welcome. I'll lay out a lot of detail.
Some details follow. The basic
, at 1:53 PM, Gregory Newby wrote:
I'm using MySQL for an information retrieval application where word
occurrences are indexed. It seems that performance is not as good as
I would expect (it seems nearly linear with the number of rows).
Any advice would be welcome. I'll lay out a lot
Hi, Tait. It sounds like your server is never actually
starting properly. There could be any number of reasons for
this - it's best to work through the installation instructions
that came with the package.
To see what failed, chances are good there is an entry
in the error log (it will probably
- this is where the mysql db itself is.
ta
tait
On 16/01/2004, at 10:36 AM, Gregory Newby wrote:
Hi, Tait. It sounds like your server is never actually
starting properly. There could be any number of reasons for
this - it's best to work through the installation instructions
that came