Error displaying the error page: Application Instantiation Error: Incorrect key file for table './mzansi_joo/rtovi_session.MYI'; try to repair it SQL=DELETE FROM `rtovi_session` WHERE `time` < '1449053047'

Hi Goodwin mankomb,

Error displaying the error page: Application Instantiation Error: Incorrect key file for table './mzansi_joo/rtovi_session.MYI'; try to repair it SQL=DELETE FROM `rtovi_session` WHERE `time` < '1449053047'

If your issue was caused by the above sql statement, then this sql statement actually executed by Joomla library. Can you try to increase the value for below two setting from your MySQL my.cnf ? E.g.

max_heap_table_size=512M
tmp_table_size=512M

The size above is an example, you will need to increase higher if your existing size is already at 512M.

Also, today I tried install a db sql component 'MijoSQL' to check how many records you have in #__sessions and upon installing the component, i get below error:

Table '#__update_sites_extensions' doesn't exist SQL=SELECT update_site_id FROM #__update_sites_extensions WHERE update_site_id = 11 AND extension_id = 10172 

Did you customised your Joomla? Look like the core Joomla table was missing from your site.

Let me know if you your session table still crash after increasing the above two setting from your my.cnf mysql configuration file.

Hope this help and have a nice day!

ok sam..... how high can i go in terms of these two

max_heap_table_size=512M
tmp_table_size=512M

and were can i locate the my.cnf if you can show me the path please i will appreciate

Hi Goodwin mankomb,

ok sam..... how high can i go in terms of these two
max_heap_table_size=512M
tmp_table_size=512M

It depends on how many system ram you've installed at your server. If you have 16G system ram, you can set these setting at 512M or 1024M (1 GB).

and were can i locate the my.cnf if you can show me the path please i will appreciate

The path to mysql configuration file can be varies from different server environment. Usually it located at these location:

/etc/my.cnf
/etc/mysql/my.cnf

But again, best if you can consult with your hosting provider and ask them where is this my.cnf file for your mysql server.

Hope this help and have a nice day!

sam is it ok if i gave you the admin details to my server so that you can do it for me please if its ok with you. am renting the server with hosting source.

i need this to go to 1024M (1 GB)

please assist coz am not all that femilier dilling with msql

Hi Goodwin mankomba,

We are okay to help you to edit the my.cnf setting but please take note that we will not be responsible if anything happen to your server after the changes made. If you are okay, then please send us your ssh details to your server and we will change the setting for you

You can add the details at http://stackideas.com/dashboard/site

Hope this help

I have sent the details to the link you provided and you can go ahead please

this hapend again today

Error displaying the error page: Application Instantiation Error: Incorrect key file for table './mzansi_joo/rtovi_session.MYI'; try to repair it SQL=DELETE FROM `rtovi_session` WHERE `time` < '1449240015'

i just repaired the database again

Hey there,

I really think something is not right with your current setup because with just so little data under the session's table, it shouldn't be crashing. By the way, in the my.cnf, it seems like both the settings sam mentioned is already added correctly.

I strongly urge you to consider switching to SSD disks because from the looks of it you are running on a normal disk drive for the machine.

Hi Mark

ok i have opend a ticket with my host providers to change to SSD disks and am waiting for them to reply. i will late you know the outcome

Regards

Not a problem at all Keep us updated