poor forum performance
Posted: Sat Feb 21, 2009 12:43 pm
Folks,
Ever since I moved the forum to the new, secure location -- we've been suffering from performance problems. It's not the website; it's the database behind it. Just so you know, I'm aware of the problem and lobbying to get it fixed. Here's a conversation I just had via Live Chat:
Ever since I moved the forum to the new, secure location -- we've been suffering from performance problems. It's not the website; it's the database behind it. Just so you know, I'm aware of the problem and lobbying to get it fixed. Here's a conversation I just had via Live Chat:
Please wait for a site operator to respond.
You are now chatting with 'Viktor Kulikov'
Viktor Kulikov: Welcome! This is Viktor, please let me know how can I assist you today?
you: You and I were having a chat about 59sportfury.net/59forum and I was cut off. Did you observe the poor performance I talked about?
you: Hello?
you: are you there?
you: performance is remarkably snappy right now -- did you do something? I haven't seen it like this in weeks.
Viktor Kulikov: Hello, I am sorry for delay
Viktor Kulikov: Which database does your site use?
you: MySQL
Viktor Kulikov: I see mysql server is up and running fast right now
you: yes -- it is behaving OK, but not when I started this conversation
you: do you have a way of monitoring queries, and how long they take to fulfill, for all the database instances on your server? I'd like to know who's killing performance
Viktor Kulikov: I think there was just some short-time problem or timeout on the web server and our admins have fixed it quickly.
you: the problem is chronic
Viktor Kulikov: I think that because of shared database server environment. You know there are not only your database on the server but also there are many databases of other people as well. So it may cause overloads sometimes.
you: it has been here ever since I moved from the old insecure control panel to the new one. The server I am on is overloaded; not sometimes, but chronically
you: do you have a way of monitoring queries?
Viktor Kulikov: It is something that our admins only have
you: you should have some way to know, what percentage of queries take a long time to fulfill -- and decide based on that how many instances you can support on a single server
you: if the problem persists -- and ix does not move my db to another, less loaded server, I will subscribe with someone else
you: There. I just did another query. 19 seconds. NINETEEN! Who will stay with a provider that provides such abysmal performance?
you: I would like to have my MyQSL database moved. The performance on my web server is OK; it is the database server. What will it take to get it moved? I am formally requesting this.
you: Hello? No reply?
Viktor Kulikov: I am sorry for delay
Viktor Kulikov: You may place a ticket to our admins with such request
you: OK. I've got an open ticket. I will add this conversation to the request.
you: Goodbye