MySql Emergency!! Noobs in NEED!!!!

MySql Emergency!! Noobs in NEED!!!!

ved Nina Kieninger -
Antal besvarelser: 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
Gennemsnitsbedømmelse: -
I svar til Nina Kieninger

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

ved 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.

I svar til Nina Kieninger

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

ved Visvanath Ratnaweera -
Billede af Particularly helpful Moodlers Billede af 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?
I svar til Visvanath Ratnaweera

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

ved 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
I svar til Nina Kieninger

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

ved Visvanath Ratnaweera -
Billede af Particularly helpful Moodlers Billede af 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!
I svar til Visvanath Ratnaweera

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

ved Anthony Borrow -
Billede af Core developers Billede af Plugin developers Billede af 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