This is a Instruction how to measure database performance. This page shall also help to enhance database performance.
We are now starting work on TikiWiki 1.10 to address some areas of parsing to make TikiWiki faster.
select qtime/qcount,qtext from tiki_querystats order by 1
select qcount,qtime,qtext from tiki_querystats order by 1;
select qtime,qcount,qtext from tiki_querystats order by 1;
delete from tiki_querystats;
select sum(qcount) from tiki_querystats;
select sum(qtime) from tiki_querystats;
Example: today (11/20/2003), i added a item in tiki's trackers and got these stats:
select qtime,qcount,qtext from tiki_querystats order by 1;
| 0.070599 | 1 | delete from `tiki_searchindex` where `location`=? and `page`=? |
| 0.10163 | 35 | select `tran` from `tiki_language` where `source`=? and `lang`=? |
| 5.32297 | 2026 | select `includeGroup` from `tiki_group_inclusion` where `groupName`=? |
| 6.52072 | 2004 | select `userId` from `users_users` where `login`=? |
| 6.84396 | 2004 | select `groupName` from `users_usergroups` where `userId`=? |
select sum(qcount),sum(qtime) from tiki_querystats;
| 6159 | 19.166826486588 |
You see the probem?
Flo
-------
Mysql has an option to log all slow queries and all queries that don't use indexes (i.e. queries
that sequentially search an entire table)
To enable this logging in /etc/my.cnf in the mysqld section add:
log-long-format set-variable = long_query_time=2 log-slow-queries=/var/log/mysql_slow_query.log
restart mysql
the email is attached in the comment area
1) |
18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
2) |
15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
3) |
19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
4) |
Tiki birthday |
5) |
17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
6) |
21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting |
7) |
19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting |