Joomla 2.5, 102 Mb content, very slow :( Possible mysql? - Joomla! Forum - community, help and support

hi!
there news site joomla 1.0 9 years accumulated 96 mb of articles. has long been brewing upgrade. updated in 2 phases, first dump of categories of users , content in 1.5 using migrator jupgrade 2.5 , updated periodically j2xml importer. in j2.5 table content 102 mb.

but when trying run on 2.5 - terrible slow. caching enabled, built-in template ja purity ii compressed js , css

mytop output:

mysql on localhost (5.0.95-log) 1+06:35:14 [21:43:10]
queries: 3.3m qps: 32 slow: 477.0 se/in/up/de(%): 90/00/04/00
qps now: 16 slow qps: 0.0 threads: 28 ( 28/ 0) 88/00/00/00
key efficiency: 99.3% bps in/out: 5.6k/29.6k in/out: 1.1k/18.7k

id user host/ip db time cmd query or state
-- ---- ------- -- ---- --- ----------
58265 root localhost test 0 query show full processlist
58576 user localhost rpdb 322 query select a.id, a.asset_id, a.ti
58577 user localhost rpdb 322 query select a.id, a.title, a.alias
58109 user localhost rpdb 335 query select a.id, case when char_l
58127 user localhost rpdb 335 query select a.id, case when char_l
58144 user localhost rpdb 335 query select a.id, case when char_l
58101 user localhost rpdb 343 query update higb0_contentset order
58090 user localhost rpdb 1000 query select a.id, a.title, a.alias
58080 user localhost rpdb 1014 query select a.id, a.title, a.alias
58074 user localhost rpdb 1015 query select a.id, a.title, a.alias
58056 user localhost rpdb 1036 query select a.id, a.title, a.alias
58059 user localhost rpdb 1038 query select a.id, a.title, a.alias
58041 user localhost rpdb 1059 query select a.id, a.title, a.alias
58038 user localhost rpdb 1061 query select a.id, a.title, a.alias
58008 user localhost rpdb 1079 query select a.id, a.title, a.alias
58010 user localhost rpdb 1081 query select a.id, a.title, a.alias
58018 user localhost rpdb 1081 query select a.id, a.title, a.alias
58004 user localhost rpdb 1088 query select a.id, a.title, a.alias
57984 user localhost rpdb 1095 query select a.id, a.title, a.alias
57986 user localhost rpdb 1095 query select a.id, a.title, a.alias
57987 user localhost rpdb 1095 query select a.id, a.title, a.alias
57989 user localhost rpdb 1095 query select a.id, a.title, a.alias
57992 user localhost rpdb 1095 query select a.id, a.title, a.alias
57983 user localhost rpdb 1096 query select a.id, a.title, a.alias
57985 user localhost rpdb 1096 query select a.id, a.title, a.alias
57982 user localhost rpdb 1098 query select a.id, a.title, a.alias
57990 user localhost rpdb 1100 query select a.id, a.title, a.alias
57994 user localhost rpdb 1100 query select a.id, a.title, a.alias

help please!

tried restarting sql after dump?