Hello, Recently i decided to move from Geeklog (CMS) to Wordpress. Geeklog is nice, but i really miss some features easily found in wordpress using some plugins. My site is getting 6~7k unique visitors and 30k pageviews a day, tons of bandwidth. It is mostly images/video/game stuff, a media site. 1500 posts. So i changed the database from geeklog to wordpress, make a new layout, etc etc. I put this online and for my surprise, with 60, 70 users online, the server couldn't take it. And it is a dedicated server. Is not shared. "Wordpress cannot connect do database" etc etc... I tried to use the plugin WP-cache and a lot of pages were recorded at the wp cache folder, but it didn't solved. So, Wordpress have this problem with medium/large sites? I read that some big sites are using wordpress... i can't understand why this problem occurred to me. Any help or suggestion will be appreciated.
As you've found WP is very database heavy ... one thing to check is the database server configuration with your host, it may be restricting the number of connections / queries per day, leading to your problem.
I have root access to server, i need to edit my.ini or my.cf right? Which number you think is good in this case? Thanks for your response.