Gossamer Forum
Quote Reply
MYSQL 4
Seems Links and Forum will be optimized for MYSQL 4 soon - what are the key benefits of MYSQL 4 - how well does it perform compared to current version?

Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] MYSQL 4 In reply to
The features I am most excited about are:

* Greatly improved full text indexing support. MySQL now has fairly decent full text indexes (which means really fast searches on large amounts of text). It's still not as good as MS SQL's, but it's pretty nice. The indexer in 3.23 was awful.

* Query caching - MySQL now has a built in query cache so if you send it the same SQL query twice, and your tables hasn't changed, it pulls the results from a cache rather then redoing the query. Can result in dramatic performance gains.

If you are into "real" database features, the Innodb table type is greatly improved as well (provides transactions, row-level locking and foreign key support).

For a full list, see http://www.mysql.com/doc/en/News-4.0.x.html.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] MYSQL 4 In reply to
Sounds great - would that also mean that I would then be able to search for ex. 'hp' which I can't today... (and not pleasing our client :-)

Klaus

http://www.ameinfo.com
Quote Reply
Re: [klauslovgreen] MYSQL 4 In reply to
Yes, you can set: ft_min_word_len to the minimum word length you want to index (if you are using the MySQL 4 indexer).

If you are using the Links SQL internal indexer, you need to adjust it in the code, it's hard coded at three characters I believe.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] MYSQL 4 In reply to
Perfect - I'll wait for MYSQL 4 then :-)

Cheers Alex

Klaus

http://www.ameinfo.com
Quote Reply
Antwort: [Alex] Re: [klauslovgreen] MYSQL 4 In reply to
now the latest mysql max 4 is vision 4.012
but at mysql max 4.012 for windows is slow than mysql 4.05.

i running a gforum 1.18 withins mysql 4.05 is perfect.
but update to 4.012 , after repair or optimian table gforum_user and gforum_post will be a login error.

so, sugest waitting for mysql 4.10 relaase.

my MSN: perlchina_at_hotmail.com
Quote Reply
Re: [Alex] MYSQL 4 In reply to
Alex,

I've been using MySQL 4 with Links SQL a while and it works very good. The only thing I don't seem to figure out is the ft_min_word_len setting and search results I get. the show variables command shows it set at 3, but searching for words like IBM results in a full scan of the whole database, is this a bug with the current MySQL4 libraries in Links SQL?