Hi,
Is there a way to run fast queries (perhaps using
indexes) using the "old" table in my replication of
the English Wikipedia database (MySQL 4.0.20)? When
I've tried queries that include the field "old_title",
the simplest queries run for up to an hour on my AMD
Athlon XP 2400+ and 512 MB RAM on Windows XP
Professional. The more complex ones I'm trying to run
take dozens of hours--one query ran for five days,
before I finally quit it.
I've configured MySQL using the configuration options
that I list at the botton of this e-mail, but things
are still unbearably slow. An example of the type of
query I've been trying to run would be:
select distinct old_user, old_user_text
from old
where old_user > 0
and old_title like 'History_of_%';
I'm surprised that this sort of query runs so slowly,
considering that when on the live Wikipedia, you click
on "User Contributions" and get a list of responses
with lightning speed. Is there a faster way to search
on all the historic changes to Wikipedia that I'm
overlooking? I'd really appreciate any help anyone
could give me.
Thanks,
Claudio
[mysqld]
basedir=D:/www/mysql
#bind-address=192.168.2.22
datadir=D:/www/mysql/data
#language=D:/www/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
set-variable=key_buffer=128M
set-variable= max_allowed_packet=1M
set-variable=table_cache=256
set-variable=sort_buffer_size=4M
set-variable=read_buffer_size=4M
set-variable=myisam_sort_buffer_size=64M
set-variable = thread_cache=8
set-variable = thread_concurrency=2
set-variable =tmp_table_size=64M
set-variable=innodb_buffer_pool_size=140M
set-variable=innodb_additional_mem_pool_size=10M
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
______________________________________________________________________
Post your free ad now!
http://personals.yahoo.ca