https://bugzilla.wikimedia.org/show_bug.cgi?id=48851
--- Comment #6 from Asher Feldman <[email protected]> --- I noticed that the tables in p50380g50518__heritage_p were all myisam. No effort had been made to tune for myisam performance. I just increased the bulk_insert_buffer_size and key_buffer_size which should be relevant to your workload. Can you report on any improvement? (In reply to comment #0) > This weekend I played around with the databases on Toollabs. I'm using the > commonswiki.labsdb server. I compared the speed with the Toolserver > databases. > > SELECTs on commonswiki_p are very fast. I created a databases > p50380g50518__heritage_p on this server. INSERTs seem to be very slow and > sometimes seem to get stuck. I think some performance tuning needs to happen > here. The program I'm using tries to do about 1.000.000 inserts. The whole > program takes about an hour to complete on the Toolserver (when I last > checked), on labs it's several times slower. > > Ps. Now is probably a good time to add a database component. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
