HackerTrans
TopNewTrendsCommentsPastAskShowJobs

HugThem

no profile record

comments

HugThem
·7 वर्ष पहले·discuss


    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 वर्ष पहले·discuss


   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 वर्ष पहले·discuss
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 वर्ष पहले·discuss
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 वर्ष पहले·discuss


    Is there any reason to ever use it
It is faster, uses less disk space and has a more logical filesystem layout.
HugThem
·7 वर्ष पहले·discuss
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 वर्ष पहले·discuss
I fire the queries sequentially. So there is never more then one query running.
HugThem
·7 वर्ष पहले·discuss
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 वर्ष पहले·discuss
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 वर्ष पहले·discuss
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.