HugThem · HackerTrans

7 years agodiscuss

    You should mostly treat it as a black box

Again, check the very link you posted. People do that. Until shit hits the fan. And then they have to take that black box apart. Which is not easy.

HugThem

7 years agodiscuss

   only the following is stored in ibdata1

You say "only", I say "clusterfuck".

Just look at the very page you linked to. It's a totally confusing concept that befuddles users and causes questions "we often receive", starts "panic", can "unfortunately" not easily be analyzed and you might need to "kill threads" and initiate "rollbacks" to fix the problems it brings.

MyISAM got that right. One dir per database.

HugThem

7 years agodiscuss

I hade the same suspicion. Especially since the provider indeed runs a nightly backup of the VMs. But even after turning that off, the VM stalled the next night again.

HugThem

7 years agodiscuss

A flag with that name exists, yes. But it does not seperate table data into one file per table. It will still put stuff related to the tables into the central ibdata1 file.

Google "ibdata1 one file per table" to see all the pain it causes.

HugThem

7 years agodiscuss

    Is there any reason to ever use it

It is faster, uses less disk space and has a more logical filesystem layout.

HugThem

7 years agodiscuss

I tried sleeping 0.1s every 5s or so. It did not help. Still crashed.

I don't think swapping would even occur since neither mysql nor php grow their memory usage over time.

It's not an SSD. It's good old rusty HD.

HugThem

7 years agodiscuss

I fire the queries sequentially. So there is never more then one query running.

HugThem

7 years agodiscuss

I witnessed MySQL bringing linux servers down two.

In my case it happens like this:

I have a long running PHP process that constantly fires away mostly SELECT but also a bunch of INSERT and UPDATE statements and also some DELETEs.

Since the DB and the key files do not fit into memory, its all disk bound work.

All tables are MyISAM.

Like clockwork, this stalls the virtual machine once per day.

All I can do is to hard power down the VM and restart it. Afterwards the table data is corrupted beyond repair.

Not sure it is related to memory though. Because the memory usage of PHP and MySQL seem to be constant. Most RAM seems to be used by Linux for caches.

HugThem

7 years agodiscuss

Why on earth is the text of Home/Explore/Notifications etc on the left bold and twice as big as the content aka the tweets?

You see the navigation every day. You know where it is. Its not that you have to read through it. So if anything, shouldn't it be smaller?

HugThem

7 years agodiscuss

I don't see such a limit. When I search, I still can scroll. Just tried and it worked all the way down to 2011.

comments