[Using Sakai] mysql performance issues

[David Horwitz]

Hi Anders,

We would certainly recommend switching on query caching - it will 
certainly help. I would also recommend you switch on slow query logging, 
this will help point you to any possible missing indexes in your database

Regards

David

On 01/17/2012 11:44 AM, Anders Nordkvist wrote:
>
> 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>
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120117/a98144ac/attachment.html