MySql Emergency!! Noobs in NEED!!!!

MySql Emergency!! Noobs in NEED!!!!

by Nina Kieninger -
Number of replies: 6
We are currently students working on the mysql for my school's moodle website. According to my teacher we are to fix the runtime errors, however she is not very helpful. Can anyone give step by step instructions for fixing a slow_queries error starting from the very beginning? We are not very computer savvy, so the easier the better. smile If you know how to fix Handler_read_rnd, created_tmp_disk_tables, select_full_join, or sort_merge_passes it would also be greatly appreciated. We have googled and researched all of these topics but can not get our computer to give us the results they say we should be getting.wide eyes Thanks in advance,

Nina and Larry
Average of ratings: -
In reply to Nina Kieninger

Re: MySql Emergency!! Noobs in NEED!!!!

by Elvedin Trnjanin -

All of these things could be helped with MySQL tuning. This is not an easy topic to go over and it requires some trial and error for fine tuning.

Search around for 'MySQL tuning' for general hints and ideas.

Average of ratings: -
In reply to Nina Kieninger

Re: MySql Emergency!! Noobs in NEED!!!!

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
Do you mean, all these error messages get dumped on the Moodle webpage? Or are you reading MySQL logs?

Wenn does this happen? At 100 users, 10 users, one user?

What sort of a course: static content, forum, quiz, chat, ...?

What is the system: Windows, Unix (Linux, Solaris, *BSD, Mac OS X)? Same with Apache, MySQL, PHP, versions, how (who) did you install?

Last of all the Moodle version?
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: MySql Emergency!! Noobs in NEED!!!!

by Nina Kieninger -
We are reading phpMyAdmin runtime information.

We have about 325 users.

High School.

Running on Windows 2003 server apache webserver

moodle 7.2
Average of ratings: -
In reply to Nina Kieninger

Re: MySql Emergency!! Noobs in NEED!!!!

by Visvanath Ratnaweera -
Picture of Particularly helpful Moodlers Picture of Translators
> Running on Windows 2003 server apache webserver

Sorry, I can't help you there, Windows is not my world.

> moodle 7.2

You mean 1.7.2?

That is old and one of the most inefficient versions. Please upgrade to 1.9 first!
Average of ratings: -
In reply to Visvanath Ratnaweera

Re: MySql Emergency!! Noobs in NEED!!!!

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Just to echo what Visvanath said, upgrade to 1.9 and most likely and you will likely solve your slow queries issues. Peace - Anthony
Average of ratings: -