MySQL Forums
Forum List  »  General

Got error 12 from storage engine
Posted by: berthier laurent
Date: September 08, 2009 05:24AM

Hello,

Since two days, I often have the error "Got error 12 from storage engine" when application executes these queries :

SELECT idArticle, surtitreArticle, titreArticle FROM Articles, ArtRub, ArtSousRub WHERE idArticle = ArtRub.FK_idArticle AND idArticle = ArtSousRub.FK_idArticle AND FK_idRubrique='2' AND FK_idSousRubrique='29' AND magArticle='Le Nouvel Observateur' ORDER BY dateArticle DESC LIMIT 0, 1;

SELECT idRubrique, nomRubrique, typeRubrique FROM Rubriques, ArtRub WHERE FK_idArticle = '1242' AND FK_idRubrique = idRubrique ORDER BY idRubrique;

My configuration :

key_buffer = 500M
max_allowed_packet = 2M
table_cache = 400
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 128M
thread_cache_size = 48
query_cache_size = 32M
innodb_buffer_pool_size = 300M
innodb_thread_concurrency = 150
innodb_log_file_size = 50M
open_files_limit = 2048

max_connections = 400
max_user_connections = 130
server-id = 1011
group_concat_max_len = 50000
interactive_timeout = 90
wait_timeout = 90

Thanks for your help

Options: ReplyQuote


Subject
Written By
Posted
Got error 12 from storage engine
September 08, 2009 05:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.