Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i have a wordpress driven web site. i am having a very very weird issue. i am clean installing my wordpress, using it about a week or so then i am losing admin rights in wp-admin. i can login with my admin account, i can confirm that its role is still admin but for example i cant post a new page. i am asking this here cause i believe this is not related with wordpress. i am having a very strange problem with my mysql database. i dont know how but i believe after a period of time my tables loses their auto increment functionality. cause this is not only a admin account related problem. for example after this thing happens, nobody can register to my site, no body can post etc. please help me. i am trying to fix this issue about 2 months. because i dont really understand what happens, i cant find a real solution. how can i debug this for example? thanks

share|improve this question
    
Have you looked in the mysql logs (what OS are you running on), or your web server error logs? –  slillibri Dec 4 '11 at 23:10
    
i am on ubuntu 10.04 lts and using nginx as webserver. how can i look mysql logs. where are they? –  borannb Dec 4 '11 at 23:18
    
You can find your mysql error logs by logging into your mysql server and running show global variables like 'log_error'; –  slillibri Dec 4 '11 at 23:43

1 Answer 1

typically, this tends to occur when mysql's run out of disk space. how large is the database, what does df -h report, etc.?

you may want to consider posting the my.cnf as well, though i'm fairly certain this is a disk space/fs quota issue based purely on the symptoms you mention.

share|improve this answer
    
Filesystem Size Used Avail Use% Mounted on /dev/xvda 20G 735M 18G 4% / devtmpfs 249M 112K 249M 1% /dev none 249M 0 249M 0% /dev/shm none 249M 40K 249M 1% /var/run none 249M 0 249M 0% /var/lock none 249M 0 249M 0% /lib/init/rw and this is my.cnf pastebin.com/0rviE4k7 –  borannb Dec 6 '11 at 1:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.