A clients Bluehost account was deactivated today.  We upgraded to the latest Magento on 12/15.  Here is what bluehost said:

----------------------
Server load has been high in part from excessive MySQL usage by this account. Since Dec15, this account has examined 2,908,584,469,857,940 rows (581,716,893,971,588/day), taking 219 CPU seconds (43/day). Anything above about 5 billion rows or 70,000 CPU seconds per day is considered excessive for a shared hosting environment. Please reduce mysql usage or find a new host. Source data from which above calculations were based… User CPU_time Rows_examined esoteri3_wordp 13.343195 31500 esoteri3_magento 206.379530 2908584469826440 Most referenced databases today in ~/tmp/mysql_slow_queries… The top 10 busiest tables on this account are as follows… 90551 esoteri3_magento.catalog_product_entity_varchar 80483 esoteri3_magento.eav_entity_attribute 55332 esoteri3_magento.catalog_product_entity_text 41822 esoteri3_magento.catalog_product_entity_int 31108 esoteri3_magento.log_url_info 31108 esoteri3_magento.log_url 19208 esoteri3_magento.eav_attribute_group 18363 esoteri3_magento.l
og_visitor 16915 esoteri3_magento.log_visitor_info 15006 esoteri3_magento.catalog_product_entity
-------------------------

Then sent the following:

The solutions are:

A few things you can do to assist with the problem.

1. Optimize your databases. To do this go into phpMyAdmin in your cPanel.
you will see a list of your databases on the left. for each one, click on
it, then go to the bottom of the page on the right. Click “check all” then
use the drop down menu and select optimize. Do this for every database.

2. Repair your databases. Follow the instructions above, but this time
select repair in the menu for each database.

3. Make sure your Simple Scripts/Fantastico applications (Joomla,
Wordpress, etc...) are up to date and upgrade if needed.

4. Add appropriate indeces to your SQL tables can often help reduce CPU.

5. Use static .html documents instead of painful .php scripts will
practically eliminate CPU usage.

6. Archive older portions of your database into new databases.

7. **Be sure to do this one!!** Update your application(s) and the
plugins/modules for the application(s). (Applications are things like
Joomla, Wordpress, PhpBB, etc...)

The following article has more information on CPU exceeded errors.

http://helpdesk.hostmonster.com/kb/index.php?x=&mod_id=2&id=361

The following articles have information about improving MySQL queries
performance.

http://helpdesk.hostmonster.com/kb/index.php?x=&mod_id=2&id=357
http://helpdesk.hostmonster.com/kb/index.php?x=&mod_id=2&id=358
http://helpdesk.hostmonster.com/kb/index.php?x=&mod_id=2&id=359
http://helpdesk.hostmonster.com/kb/index.php?x=&mod_id=2&id=360

---------------

I guess Bluehost doesn’t support an active Magento site that is actually getting traffic.
Any ideas from anyone?

Seeing as they don’t yet have Magento within the Fantastico panel I FTP’ed the files onto my server space, after which it gave me the “oops wrong PHP version” message.

Went to the PHP admin icon within the control panel and there it was, an option to upgrade PHP from 4.x to 5.x.  Made the change and Bob’s yer Uncle, job done.  Interestingly it didn’t adversely affect any of my existing CMS installations on BlueHost

I’m actually hosting Magento on HostMonster , but it’s run by the same company and has (basically) the same features.  Anyway, I was able to install successfully through Simple Scripts (in the Software/Services section of cPanel), which was (as the name suggests) simple!  It created the database for me and had it up and running in a few minutes.  You can easily use it to add multiple magento installs, so you can use one as a “test bed” for new features/upgrades and try different things without messing up the live store.

It’ scurrently installing version 1.0.19870, then you can use the admin Connect Manager to upgrade to the latest.  The only glitch I encountered was that after upgrading, I needed to enable “Fast CGI” to get things to work correctly, otherwise a couple of the scripts were throwing 500 errors.

I just completed the install over the July 4th holiday weekend.  If I was smart like riddle930, I would have enabled ssh long ago.
After uploading the files (using ftp), I noticed that the installer did not recognize some of the required extensions required.  I then looked at the PHP setup, and changed from PHP5 Fast CGI to PHP5.  After that change, the install went smoothly.

Hope this info helps,

Wrongsauce