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