MySQL Table Description
  • Vote Up0Vote Down sdancer75sdancer75
    Posts: 99Member
    Is there any guide or docs of the MySQL Tables Description ? 

    I want to know if some tables like  
    RequestObjects, 
    Requests, 
    RequestStats, 
    Sessions are needed because are taken too much space inside the MySQL DB and if i empty them what are the consequences ?

    Where can I change the DB table names prefix ?

    Regards,

    Post edited by sdancer75 at 2012-01-30 06:27:17
  • 4 Comments sorted by
  • Vote Up0Vote Down Martin SaturkaMartin Saturka
    Posts: 40Member, Sourcefabric Team
    These tables are (mostly) used for (flawed) statistics. I would suggest to set "Collect statistics" to "No" at "System Preferences" first - if you have new enough version of Newscoop.
    As far as I remember, you would just remove data for statistics on articles, may be logouting users too (if your version of Newscoop uses these tables for session management).
    M.
  • Vote Up0Vote Down sdancer75sdancer75
    Posts: 99Member
    Hi,

    Thank you for your answer.

    1. Campsite 3.4 does not support this option inside the system preferences. I don't know If I can disable this inside a php file. Anyway, Is there any document that describes the usages of mysql tables ? Appearntly some of them are obvious but some other no.
    2. How can I change the DB table prefix name ?

    Regards,
    George
  • Vote Up0Vote Down mark cassonmark casson
    Posts: 219Member
    i was told you can delete requests and sessions without any problems

    you will have to change the prefix in phpMyAdmin

    also change the conf/database_conf.php if you already got a site running

    take a backup first though!
  • Vote Up0Vote Down Andrey PodshivalovAndrey Podshivalov
    Posts: 1,526Member, Administrator, Sourcefabric Team
    currently Newscoop doesn't support table prefix settings
Add a Comment