Search results for query: *

I manage http://www.motherearthnews.com/ <--not much to look at yet I know. I am currently using PHPMYSearch to search through our database of almost 7000 archived stories. The problem I'm runnning into is that now and then the MySQL server will crash on large searches. It goes down with a pop...

I keep getting an error whenever I try to modify a table. Actual Error: "Couldn't add field te. MySQL said: Error on rename of '.\test\test.MYI' to '.\test\#sql2-368-47.MYI' (Errcode: 13)" I have checked the permissions on the MYSQL folder, mysql data folder, and each of the individual...

32763 Opened tables in 3 days... The MySQL Manual says "If the value is quite big" you should increase your table_cache. What is quite big for 7 sites running PHP MySQL? What should my table_cache be set to. This is a repeat of my earlier post with new numbers. Chris

Uptime: 7 hours, 54 minutes and 19 seconds Threads created: 18 Open tables: 35 Open files: 70 Open streams: 0 Opened tables: 4492 select: 29,909 Key reads: 4726 Key write requests: 9684712 Key writes: 108618 Max_Connections: 300 Table_Cache_Size: 300 Thread_Cache: 5....don't ask me I...

Obviously everyone knows that mysql ships with the default root user. I was wondering (for security) if it was possible to replace the root user with another user account or if the root user had certain privaliges that others could not have.

Application popup: mysqld-nt.exe - Application Error : The memory could not be "read". I have gotten this error twice now. I can't seem to find any rhyme or reason to why though. Our sites are all based on php and mysql. The Server load at the time of the crash was minimal. The only common...

Ok, here is the situation. We are on mysql 4.0.17 and are waiting to update to 4.1 until it is out of alpha. What I have is a biweekly magazine that could run any number of stories an issue. We are currently displaying the last 3 issues. They had limited to 3 stories per issue online but are...