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 sce
CVS at http://sourceforge.net/projects/irtools
-- Greg
> On Jan 15, 2004, 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 ex
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
re almost there!
-- Greg
> I've got mysql installed in /usr/bin/mysql
> and
> the db's and logs in /var/mysql - 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
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
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:
"ER
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.
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
