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