Вот моя игра тык - есть проблемы со скоростью загрузки страниц, вызванная отсутствием индексов в базе.Я никогда с ними не сталкивался,поэтому прошу помочь. Контакты в анкете. Ну либо в теме поясните что и как сделать.

javajdbcсначала определите конкретноы запрос который
медленый -- потом выдайте его сюда.

Как это можно сделать?

javajdbc, вот например кусок mysql-slow.log :

/usr/libexec/mysqld, Version: 5.5.28-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 130827 13:18:38
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 1.677385 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 0
use vkolhoze;
SET timestamp=1377598718;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '20175', `id_collective` = '694', `count` = '5000000', `type` = 'money', `time` = '1377598717';
# Time: 130827 13:55:06
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 1.751256 Lock_time: 0.033130 Rows_sent: 0 Rows_examined: 1
SET timestamp=1377600906;
UPDATE `kolhoz_user` SET `date_last` = '1377600903' WHERE `id` = '29935' LIMIT 1;
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 4.093740 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 0
SET timestamp=1377600906;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '5555', `id_collective` = '63', `count` = '130200', `type` = 'money', `time` = '1377600901';
/usr/libexec/mysqld, Version: 5.5.28-log (MySQL Community Server (GPL)). started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 130827 15:04:23
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 1.079396 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 0
use vkolhoze;
SET timestamp=1377605063;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '14450', `id_collective` = '388', `count` = '50000', `type` = 'rubies', `time` = '1377605062';
# Time: 130827 18:18:27
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 5.899001 Lock_time: 0.048390 Rows_sent: 0 Rows_examined: 1
SET timestamp=1377616707;
UPDATE `kolhoz_user` SET `date_last` = '1377616700' WHERE `id` = '10033' LIMIT 1;
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 6.786058 Lock_time: 0.000026 Rows_sent: 0 Rows_examined: 0
SET timestamp=1377616707;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '6215', `id_collective` = '834', `count` = '8051', `type` = 'money', `time` = '1377616700';
# Time: 130827 18:55:39
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 2.858631 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 0
SET timestamp=1377618939;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '12173', `id_collective` = '682', `count` = '100000', `type` = 'rubies', `time` = '1377618936';
# Time: 130827 19:37:31
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 1.008244 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 0
SET timestamp=1377621451;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '29916', `id_collective` = '694', `count` = '1000', `type` = 'rubies', `time` = '1377621450';
# Time: 130827 20:26:04
# User@Host: tonyresh[tonyresh] @ localhost []
# Query_time: 2.720871 Lock_time: 0.000019 Rows_sent: 0 Rows_examined: 0
SET timestamp=1377624364;
INSERT INTO `kolhoz_collective_cash` SET `id_user` = '12213', `id_collective` = '555', `count` = '330200', `type` = 'money', `time` = '1377624361';



kolhoz_collective_cash - касса колхоза (гильдии)
с остальным вроде бы понятно...

javajdbc, в логе много запросов типа INSERT к примеру:

INSERT INTO `kolhoz_collective_cash` SET `id_user` = '20175', `id_collective` = '694', `count` = '5000000', `type` = 'money', `time` = '1377598717';

после которых сразу идёт запрос UPDATE:

UPDATE `kolhoz_user` SET `date_last` = '1379440065' WHERE `id` = '5055' LIMIT 1;

Сейчас я поставили ндексы так:



столбцы в таблице:



но на скорости обработки запросов похоже это никак не сказалось...подскажите как быть?