89200+ entries in 0.029s
mircea_popescu: load average: 0.01, 0.05, 0.21 <<< meanwhile i am... waiting... for it to... repair.
mircea_popescu: "every thing you do will resolve 99% of the problem at the most". always a little bit left. gah.
mircea_popescu: entirely not fucking iron-bound problem in trilema case for instance. wtf can "repair table" need >1200 s !
mircea_popescu: i can't comprehend what'd possibly take this long to repair it.
mircea_popescu: weirdly enough, also not timing out. how the fuck long can a thing waiot for a lock ?
mircea_popescu: Framedragger you trying to tell me that process'd have somehow survived a mysql restart ?
mircea_popescu: so far the table is crashed, and the repair thing seems to take forever.
mircea_popescu: why'd i want to kill 150 processes by hand. let them timeout.
mircea_popescu: but the box doesn't deliver, theoretically, anything but a text line now
mircea_popescu: insanely, i am still getting a lot of www requests, so i guess i incidentally found some other issue here as well.
mircea_popescu: no it's fine, trying to figure out how to rescue the table.
mircea_popescu: ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
mircea_popescu: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mircea_popescu: turns out this whole "read while dirty" thing is "implemented" except notrly.
mircea_popescu: on the basis of too many dorks hammering it on the www!
mircea_popescu: there's a "repair by sorting" going and five billion agents waiting for metadata lock
mircea_popescu: because why ? because OH MY FUCKING GOD SOMEONE RAN A 2MB SQL an hour ago!!1
mircea_popescu: in other lulz : mysql use db; results in... the process simply hanging. > 1 minue by now.
mircea_popescu: well apparently trilema's going to be offline for a while for reasons of unexpected explosion.
mircea_popescu is steeling self for discovering mysql dosn't allow over x bytes in any one column or such closely managed nonsense
mircea_popescu is undeterred, created sql file, is importing it, which apparently takes A WHILE
mircea_popescu: Framedragger mught as well tell him where to show up an' thassat.
mircea_popescu: aaaand in other lulz...trilema can't actually hold a 3mb data dumb.
mircea_popescu: that's not something i, or anyone else, can be "cured" of.
mircea_popescu: (which is very good and useful as it is, not the problem there. but gotta fix it here)
mircea_popescu: asciilifeform it's not missing, it has an extra 1 megabyte of Framedragger 's hello world
mircea_popescu: consider the string : "hurr\n1-1-1-1\ndurr\n2-2-2-2\nfoo54-54-54-54". the job is to turn it into "hurr\n1\ndurr\n2\nfoo\n54"
mircea_popescu: now, how do i tell awk to turn the blather quoted above into the intended result ? hm ? HM ?
mircea_popescu: i am taking the entire table as found on stats page and putting it on trilema.
mircea_popescu: into a more reasonable (ssh-rsa key from 60.213.15.140 13-14 June 2016 extraction) ?
mircea_popescu: <tr><td>60.213.15.140 (ssh-rsa key from 60.213.15.140 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <sshscan-queries+60.213.15.140@mkj.lt>; </td></tr>
mircea_popescu: thing is, it doesnt' crash, it always comes up but you gotta know to retry.
mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
☟︎ mircea_popescu: Framedragger maybe they're serious, and intend to redeliver on your mum!!11
mircea_popescu: even at a time people couldn't be arsed to ~physically inspect~ russkis anymore, just paid for the cargo whole.
mircea_popescu: "queries should be sent to the address above, where you will helpfully be informed they can not say anything else besides reading this notice to you."
mircea_popescu: whoa, so they want VAT, AND a "royal mail intl handling fee" that's 10 bux.
mircea_popescu: i teach some basic mechanical engineering to ~all~ my girls. just because i can.
mircea_popescu: now tell me she wouldn't be happier as a declared slave for a republican lord ; rather than a doublespoken slave for nobody-in-particular in the stupid empire.
mircea_popescu: holy shit they got some kefir in this country that'll melt your heart.