[Toolserver-l] slow queries

[Mashiah Davidson]

Hello, All!

Can anyone suggest how to improve the performance of a query like this:

CREATE TABLE u_mashiah.pagelinks (
  `pl_from` int(8) unsigned NOT NULL default '0',
  `pl_namespace` int(11) NOT NULL default '0',
  `pl_title` varchar(255) binary NOT NULL default '',
  KEY `pl_from` (`pl_from`,`pl_namespace`)
) TYPE=MyISAM AS /* SLOW_OK */
SELECT pl_from,
       pl_namespace,
       pl_title
       FROM ruwiki_p.pagelinks;

This is the complete copying of a table from readonly database to personal
one with some altering on keys, not sufficient I suppose. It looks like if
copying like this is much slower than access to the same amount of data in
one database.

Please, advise.

Mashiah
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.wikimedia.org/pipermail/toolserver-l/attachments/20070620/3f0c8d78/attachment.htm