SmartCJ Support Forum

Agreed, i have send them your wiki about it many times.

It's a managed server aim not a teck.

Do you want ssh access?

There's no need.

do you know how to run sql command ? can you google it ?
I think it's better to explain something once then ask for ssh access each time.

These is not my strong side, i rather just send any q to my host.

WHat do you need?

What engine uses each table in your db ?

Short Description: check server
Update:

Here is the list of all tables in indianxxx_scj database:

+--------------------+--------+
| table_name | engine |
+--------------------+--------+
| admin_access_log | InnoDB |
| admins | InnoDB |
| blacklist | InnoDB |
| bookmarks | MyISAM |
| browsers | MyISAM |
| countries | InnoDB |
| day | MyISAM |
| day_last_hour | MyISAM |
| forces | MyISAM |
| ga_categories | InnoDB |
| ga_sites | MyISAM |
| history | MyISAM |
| inrules | InnoDB |
| ips | MyISAM |
| language | MyISAM |
| links | MyISAM |
| out_ips | MyISAM |
| out_ips2trader | MyISAM |
| outrules | InnoDB |
| quality_settings | InnoDB |
| refs | MyISAM |
| reports | InnoDB |
| rot_cell_data | MyISAM |
| rot_cell_skimming | InnoDB |
| rot_comments | InnoDB |
| rot_content | MyISAM |
| rot_crop_profiles | InnoDB |
| rot_gal2group | MyISAM |
| rot_gal2model | MyISAM |
| rot_gal2tag | MyISAM |
| rot_galleries | MyISAM |
| rot_gallery_data | InnoDB |
| rot_gallery_stats | MyISAM |
| rot_groups | MyISAM |
| rot_groups_data | MyISAM |
| rot_import_sets | InnoDB |
| rot_linked_db | MyISAM |
| rot_models | MyISAM |
| rot_page_items | MyISAM |
| rot_pages | InnoDB |
| rot_replacements | MyISAM |
| rot_search_queries | MyISAM |
| rot_servers | InnoDB |
| rot_settings | InnoDB |
| rot_sponsors | MyISAM |
| rot_sponsors_data | InnoDB |
| rot_tags | MyISAM |
| rot_user_fav | InnoDB |
| rot_users | InnoDB |
| script_messages | InnoDB |
| settings | InnoDB |
| skim_rules | InnoDB |
| toplists | InnoDB |
| trader_groups | InnoDB |
| trader_plugs | MyISAM |
| traders | InnoDB |
+--------------------+--------+

http://smartcj.com/wiki/doku.php?id=mysql_tunning

read this plz and say - what tables should be in innodb format ?

Should a standard server have enugh ram to run the db in innodb?

I don't know how many memory "standart server" has and how big is your DB - so it's pretty hard to say ... )

8gb dual xeon and its just a install with 5k embeded videos.

More then enough