[Using Sakai] mysql performance issues

[Anders Nordkvist]

Hi,

Where having performance issues with our mysql 5.1.45 database. I haven't administerd the database from start and I am not very good at mysql. The CPU load is very heavy and it slows down things in Sakai. We have around 400 sessions open at the same time.
To my knowledge the only things that's changed is in my.cnf:

default-storage-engine=InnoDB
innodb_data_file_path=ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit=1
table_open_cache=1024
table_definition_cache=1024
join_buffer_size=131072
max_heap_table_size=67108864
tmp_table_size=67108864
innodb_buffer_pool_size=3221225472

I have looked at the Sakai admin mysql section and found a few tips. One thing to test with is the query caching.
Do you guys have any more tips of how to increase the performance? Do you know of any free profiling tool to use?
My last question is: How do I know that SAKAI_PRESENCE table is in memory?



mvh
Anders Nordqvist
Systemadministratör, Nätbaserad Utbildning
________________________
IT- och campusavdelningen
Högskolan i Skövde
Box 408
541 28 Skövde
tfn 0500-44 81 78
e-post anders.nordqvist at his.se<mailto:fornamn.efternamn at his.se>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120117/983e0aed/attachment.html