WordPress Database

  • booksandmorejordan

    (@booksandmorejordan)


    2 years, 8 months ago

    Hi Dears,
    I have discovered that my website has 10 database in MySQL Databases.
    Please note that I have migrated my site many times before and I believe.
    There is only one of the database in use and others are not in use.
    5 of these databases are large about 7gb each one in total around 30gb.
    My question is will it effect my site or main database if I delete them and keep the main one only! Are they linked to each other!
    Thank you!

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    2 years, 8 months ago

    I assume you know this by the table prefixes, so check your wp-config.php file to see which table_prefix is active. Do you have any other WP sites on this server that might be using the same database? If not, it should be safe to delete the tables with non-used table_prefixes. Of course, export your database first and put that someplace safe, just in case.

    Thread Starter booksandmorejordan

    (@booksandmorejordan)

    2 years, 8 months ago

    Hi Steven,
    I have checked wp-config.php and there is only one database active.
    But I have no idea if these databased linked to each other in somehow or deleting them will cause any crash.
    The other case is one of the databases is failing to backup.
    I really don’t know what to do, especially, I have speed issue when browsing products, and I believe the main reason of this is these databases.
    Any more advises please!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    2 years, 8 months ago

    Unused dbs should not affect the speed of your site. Do you have more than one site on this host? If you’re not sure, ask your host’s support team. Databases do not cross link.

    For the purposes of our discussion here, by database, I mean a set of tables beginning with the same prefix (e.g., “wp_”). A single MySQL server instance can contain multiple databases.

    Thread Starter booksandmorejordan

    (@booksandmorejordan)

    2 years, 8 months ago

    Thank you Steven,
    No, I don’t have any other sites in the host or server, I have dedicated server with very high specifications as below:

    E3-1270v5/v6 | 64GB – 2 x 1TB NVMe
    Memory: 64GB RAM
    Drive Bay 1: 1TB NVMe
    Drive Bay 2: 1TB NVMe
    Drive Bay 3: None
    Drive Bay 4: None
    Add On 1: No RAID
    Datacenter Location: Chicago, IL
    IPv4 Addresses: /29 Allocation (5 Usable)
    Network Port Speed: 1gbps (Comes Standard!)
    Bandwidth: 1Gbps 100TB Transfer
    DDoS Protection: 10gbps / 30,000,000 pps (Included Free)
    Operating System: Alma 8 (NVMe)
    Below is the databases that I am talking about:
    ********_wp161 Size: 6.8 (this is the active database)
    ********_wp_awjlb Size: 161.78 KB
    ********_wp_cskul Size: 1.08 MB
    ********_wp_ffaxg Size: 2.55 MB
    ********_wp_j95dl Size: 6.92 GB
    ********_wp_s3gwi Size: 729.35 KB
    ********_wp_twabp Size: 6.81 GB
    ********_wp_vdwbk Size: 1 MB
    ********_wp_vflvj Size: 6.58 GB
    ********_wp_w4gxh Size: 6.75 GB

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    2 years, 8 months ago

    backup and cleanup.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘WordPress Database’ is closed to new replies.

Tags