my mysql uses nearly all of the cpu of server

My web page aproxmetly 1000+ visits one a day. but my hosting company blocks my site. because of my mysql uses nearly all of the cpu of server. what can it reason be...? i changed hosting company many times but nothing has changed. what can i do for it? i m waiting for your answers... I am using latest version vivvo 4.2.

Hi shahadatmanik . are you useing cash option in you vivvo admin??

Yes, I can imaging cacheing can make a big difference, especially if you have a lot of traffic. Since Vivvo does not actually create static pages, this means that every page call must access the database to retrieve a page. By cacheing, you can avoid the constant database calls and make your site more like a "static" site in performance. This is especially important if you're in a shared server environment!

Thanks g m and every one. I have changed the admin option to cacheing, see how it goes. Take care.

[Elton]

I run my own dedicated server, but am experiencing a massive performance hit since upgrading to Vivvo 4. I'm about to switch on cacheing - what are the downsides of it?

Well, it's normal for any LAMP application to use almost 100% of any memory available all the time. This doesn't necessarily mean there's a problem, it's just that these applications will "stake out" their claim on the memory in anticipation of using it. For example, if you've got 1 gig of memory today (900mb used) and install another 1gig, you'll find that suddenly 1.8gb is used when nothing has changed. This is normal.

Vivvo is, by nature, a processor/memory intensive application since it has to make a database call for almost every action it takes; cacheing should actually reduce this in the long run.

A VPS/shared option is never a good solution for a complex web application since you're sharing all the resources. If you're going to run a large Vivvo site, you'll need to expect it to take more resources and a dedicated solution will offer much better performance.

On that note; we're considering offering Vivvo hosting when CustomVivvo! opens. Is this something that anyone would be interested in? What we would offer would be limited to a certain number of users, and a valid Vivvo license would be required. We use a dedicated server environment with 4gb RAM, Dual 250gb drives (RAID), nightly backups, and 100% network uptime. Data center is in Dallas, Texas. I'd love some input on who might be interested in this to see if we should offer it as an option, and the price which might be fair.

[Elton]

Just to let you know that the cacheing worked like a dream

Yes, it's supposed to releive the CPU. What's unique and great about Vivvo is that it does not simply cache EVERYTHING, but rather allows you to pick and choose which areas are cached. This way you won't run into issues with having banners cached, etc.

Originally Posted by northlandadv

Well, it's normal for any LAMP application to use almost 100% of any memory available all the time. This doesn't necessarily mean there's a problem, it's just that these applications will "stake out" their claim on the memory in anticipation of using it. For example, if you've got 1 gig of memory today (900mb used) and install another 1gig, you'll find that suddenly 1.8gb is used when nothing has changed. This is normal.

Vivvo is, by nature, a processor/memory intensive application since it has to make a database call for almost every action it takes; cacheing should actually reduce this in the long run.

A VPS/shared option is never a good solution for a complex web application since you're sharing all the resources. If you're going to run a large Vivvo site, you'll need to expect it to take more resources and a dedicated solution will offer much better performance.

On that note; we're considering offering Vivvo hosting when CustomVivvo! opens. Is this something that anyone would be interested in? What we would offer would be limited to a certain number of users, and a valid Vivvo license would be required. We use a dedicated server environment with 4gb RAM, Dual 250gb drives (RAID), nightly backups, and 100% network uptime. Data center is in Dallas, Texas. I'd love some input on who might be interested in this to see if we should offer it as an option, and the price which might be fair.

I have the same problem..
the VPS with 30gb and unlimited transfer is crashiing from the visits.When i enable cashe the problem is with the journalist who update the web page, the dont see changes on the web site aftr they add articles.Tha's why i have disabled the cashe option.

I regulary archive the articles but all the time there are about 1000 active articles.