Author Topic: Mysql PERFORMANCE  (Read 4356 times)

slawek

  • Guest
Mysql PERFORMANCE
« on: February 21, 2006, 06:38:38 PM »
Hello, im just in process of looking new webhost and have some questions mainly about mysql servers that paid customers use.

1. Can it be accessed from external IP
2. Is the mysql server dedicated or run on same machine as apache, ftp and all other stuff
3. How much users are there per mysql server / per www server
4. How much time itll take to update table using example query UPDATE some_table SET value=392 WHERE field=89. Where field is primary index and value is integer field

If you have some test-server please just qive me directions how to connect to it, no need to answer the questions.

TIA.

Helping Webmasters - Webmaster Forum, Website Support and T35 Hosting Support

Mysql PERFORMANCE
« on: February 21, 2006, 06:38:38 PM »

Offline Alex Melen

  • Co-CEO, Melen LLC
  • Administrator
  • Addict
  • *****
  • Posts: 2,809
  • Karma: +9/-0
    • View Profile
    • T35 Hosting
Re: Mysql PERFORMANCE
« Reply #1 on: February 22, 2006, 09:04:47 AM »
1. Yes
2. Same
3. 300 'personal plan accounts' per quad Xeon 2-4gb ram machine
4. If its just a simple query like that it should be pretty instant