On 10/26/07, James Hare messedrocker@gmail.com wrote:
Anyways, despite my ignorance, we have servers whose sole purpose is to process MySQL queries. Yipee. Leaving us with finding a feasible means of
As far as I'm aware, the intensive part is done by the database server, not the server that passes through the query.
processor capability, the public query terminal would read something like
What I have been told is that disks are the bottleneck for a database server, but I don't know for sure.
The main problem I can think of is replication lag. Running very long queries will effect the replication lag. If we want to have an open access query server, I would say that we at least need two extra, separate database servers.
Or we just keep it as it is and have people just post their queries to JIRA. I think we are trying to solve a non-existent problem.
Bryan
And of course, I am not a server admin, so what I wrote above may have as well been entirely mistaken.