MySQL - bandwidth question

[LoveAsianChicks]

I'm sure this is a very basic question but I really don't know.

I've got 1 site using the free cjultra script which runs on MySQL & gets about 40K uniques a day.

Does that usage (MySQL database) contribute towards the billable bandwidth used on my account?
(I do plan to upgrade to a better script soon)

[Cogitator]

It shouldn't. By bandwidth they mean internet usage, not necessarily disk usage. There are limits on disk usage, too, but they usually based on size, not usage.

[Babaganoosh]

good question. Not that it would be much bandwidth even if you were charged, but I suppose it would depend on if your MySQL DB was on localhost or a remote server. Ask your host to find out for sure. I'd like to know the answer too.

[Mr.Fiction]

Originally posted by Armed & Hammered
good question. Not that it would be much bandwidth even if you were charged, but I suppose it would depend on if your MySQL DB was on localhost or a remote server. Ask your host to find out for sure. I'd like to know the answer too.

Even if it's on another server, you should not be paying bandwidth for traffic inside of your hosting facility, in my experience.

[Matt 26z]

No, MySQL doesn't count against bandwidth because bandwidth is what they send out. Anything pulled from a DB happens before it's sent out of course.

The only thing you've got to worry about with MySQL is using up too many resources on a virtual server. Once a site gets to this point though, you'll be at a level of needing a dedicated server already anyway.....

[LoveAsianChicks]

Originally posted by Matt 26z
No, MySQL doesn't count against bandwidth because bandwidth is what they send out. Anything pulled from a DB happens before it's sent out of course.

The only thing you've got to worry about with MySQL is using up too many resources on a virtual server. Once a site gets to this point though, you'll be at a level of needing a dedicated server already anyway.....

How much traffic would it take for a cjultra tgp to be putting alot of strain on a virtual server?
With one host I have 50K tgp (cjultra) hits on a virtual host and they haven't said anything to me.
Is it like 200,000+ hits and it starts eating up the resources?

[Script Dude]

If you have telnet access to your sever, try something like this:

top -s 30 -Umysql

If this gives an "unknown user" error,

ps -aux | grep "mysql"

and use the word in the first column in place of the mysql in the top command.

Type q to quit the top display when you are ready.

wait a while for your screen to refresh.

Look at the percentage under the CPU column. This is the percent of the cpu that is being used by mysql.

On the top line look at the % idle. This is the amount of the cpu on that machine that is not being used at all.

Whether any given percentage is bad depends on your host, the machine, and the number of people you share it with.

[foe]

more than 90% of the time no