Learn More
Resend Email
8
Aldar
4y

Client be like:
Hello,

could you please restore our database from today's backup?

At a first glance - nothing out of the ordinary. Daily backups are standard...

Until we get the backed up snapshot running.

MySQLDump is somehow... Stuck. It... Doesn't seem to be doing... Like, anything. For ages. Wtf.

So we check the database. Connect, change scheme and... The commandline tool gets stuck, too. Weird.

So a layer lower, we check the datadir and... ls... After also getting stuck for a bit, lists about 500k files O_o

Yea, dumping a database with roughly ~250k tables is not fun. No wonder it takes ages.

rant

mysql

why

that's a lot of tables
Favorite
Ranter
Comments
  • 6
    4y
    I have seen some shit in my life, but 250k tables?

    This makes me question what's actually stored in that thing.

    1 table per user? I've seen that before...
  • 3
    4y
    Who the fuck needs 250k tables?!
  • 0
    4y
    @RustyCookie tables? What the fuck does WP create so many tables for
  • 0
    4y
    @eval I wish I had a clue.
    Doing a SELECT * on the tables returns nothing.

    Maybe a bug in the app? Might be manually created temporary tables or something. Most of the tables' names were 32 chatacters from the hexadecimal range...
  • 0
    4y
    @RustyCookie ok that makes sense but that would mean you run 50k blogs on a single DB?! I cannot get my head around how that would happen/make sense.
  • 0
    4y
    @RustyCookie i wanna hear the story
  • 1
    4y
    @RustyCookie what the hell? How? What kind of webapp from hell created that monstrosity?!
  • 1
    4y
    You know ... WordPress XD
Related Rants
devRant © 2021 Hexical Labs LLC
Privacy Policy  |  Terms of Service
Add Comment