tmsr - Search: a

68000+ entries in 0.467s

CompanionCube: mircea_popescu: do you plan to write an article about mysql being a shit?

shinohai goes back to remotely setting up a lovense ....

shinohai: A fictional cargo cult.

CompanionCube: 'Wakanda is a fictional nation appearing in American comic books published by Marvel Comics.[1] It is the most prominent of several fictional African nations in the Marvel Universe, and it is home to the superhero Black Panther. Wakanda first appeared in Fantastic Four #52 (July 1966), and was created by Stan Lee and Jack Kirby.'

shinohai: Which begs the question, wtf is a Wakanda

trinque: well, not everybody can snark on a qntra level.

mircea_popescu: which is how one ends up with a multi-gb db. apparently it got executed even though no ; at end or anything

mircea_popescu: get a load of this :

CompanionCube can't speak for mysql but knows that postgres dumps can be a mixture of text and binary data

mircea_popescu: mysql stores mysiam rows as a myd / myi pair of files

Framedragger: (but output of mysqldump is *supposed* to be a set of sql statements.)

Framedragger: typical small .sql is usually just a set of "INSERT INTO .. VALUES ..", but mircea_popescu is running a large escher megasite, so i'm less certain..

Framedragger: seems mysql does not have a 'binary dump' option. so basically, yes

mircea_popescu: i wasn't aware .sql is supposed to be a text file.

mircea_popescu: Framedragger and if i store a jpeg the dumper is supposed to do what, base64 it ?

Framedragger: mircea_popescu: .sql is a set of statements which you can run on db to put it back into the state which produced the .sql in question, no? but, if there's mysql specific convention bullshit tho, i wouldn't know :/

asciilifeform: seems like a massive reddit paste ?

gabriel_laddel_p: http://btcbase.org/log/2017-04-06#1639114 < I didn't realize that this "sharing" link would open in google drive. Here is a link to the same file that you can open in emacs, curl etc https://raw.githubusercontent.com/gabriel-laddel/masamune/master/slate-star-codex-no-wrap80.txt ☝︎

mircea_popescu: Framedragger myisamchk'd the extant MYI/MYD pair, got a db file which works but is too large, had mysqldump drop it as a .sql

mircea_popescu: here's a heads-up : head has been going for ~4 minutes. i expect it to crash without output.

mircea_popescu: -- Dump completed on 2017-04-06 15:10:30 << at least i know for a fact i got an integral mysqldump. sadly it's 40.9 gb.

Framedragger: mircea_popescu: recently had to tail multigb files, it was *instant* (because, seeks to end of file). seems like a disk prob to me

mircea_popescu: i can see the theoretical "benchmarks" online too. the problem is they're bs, "test file generated by seq 100mn". hurr. how about generate a file with lines of random length between 1kb and 1mb, then benchmark it.

a111: Logged on 2017-04-06 19:05 mircea_popescu: head doesn't work on a large file.

mircea_popescu: anyway, im dumping teh table as a sql and will be wanting to hack it up. but i have no tools with which to identify the CUT HERE spot

mircea_popescu: head doesn't work on a large file. ☟︎

asciilifeform: it doesn't even have a concept of sane process interruption + resumption.

mircea_popescu: i dunno why this is such a tall order.

jhvh1: mircea_popescu: bannon :: When a person or animal gets high on a substance, often in unexpected places. This usually ends in chaos for everyone. [ex:] At school all my friends bannoned on sharpies. [/ex]

jhvh1: mircea_popescu: trump :: 1. To have superior power over.2. To surpass or outdo.3. When a person says "trump," you are required to do whatever you just claimed you would do, no matter how exaggerated it was. If you don't do it, you get a [spartan kick] to the chest. [ex:] 1. Bob: The president's word trumps yours, Joe, you homeless piece of shit. When he says something it must be done.2. Joe: Man, I'll trump your ass (5 more messages)

jhvh1: mircea_popescu: obama :: The Messiah for brain-dead Democrats. [ex:] No matter what he says, no matter what he does, they'll worship the great Obama. [/ex] | An acronym standing for One BigAss Mistake,America! [ex:] Q: What was the result of the 2008 election?A: OBAMA [/ex] | Has no real experience, because most of his time as "senator" was spent campaigning for his own election to President. Is praised (10 more messages)

jhvh1: asciilifeform: haskell :: 1 -- A general purpose, polymorphicly typed, lazy functional programming language largely based on lambda calculus. 2 -- A constant source of frustration for those who have been brainwashed by the OO paradigm. [ex:] You: How do I write a 'while' loop with Haskell?Me: You can't, freshman. [/ex] | A town in Northern New Jerse located between Ringwood and Pompton Lakes, smaller district of (5 more messages)

mircea_popescu: a cool

ben_vulpes: ubi is a statal self-crit

ben_vulpes: "you know i really like this ubi idea; imagine the cambrian explosion of art and culture that would happen if people didn't have to work to eat, right? well imagine if *everything* were free, not just food internet and housing. it's not like we need tax receipts to pay for it, just increase the national debt a little! i doubt it would even come close to the cost of an f35 to make everything free."

ben_vulpes: everything must be a pale simalacrum of something that existed as a real item at some point

jhvh1: mircea_popescu: Error: "ud" is not a valid command.

ben_vulpes: "but then from a justice perspective it's just inherently gender inequitable, so i don't know! i just don't know."

shinohai: I want time off for male menopause, like a sabbatical.

asciilifeform: next day ben_vulpes went to a boar hunt, could not resist eating the bacon he brought in a bag himself...

gabriel_laddel_p: trinque: ported to lisp at what level? Could you please describe in more detail? Eg, is there a new ebuild format, do you interpret the old one, do you have lisp that translates shell scripts...

gabriel_laddel_p: Framedragger: I saw the discussion, and will not be doing a DOM dump because I'm not going to spend any time in the browser internals.

Framedragger: gabriel_laddel_p: ideally it would also save a full 'rich' version (whole DOM) but without JS, the way archive.is does

gabriel_laddel_p: asciilifeform: SF. I have a Masamune that will sit on here as a bot, archive all links that show up & git push them to github.

gabriel_laddel_p: Framedragger: trinque: I'm interested in ditching the web & eventually x86 as a whole, not somuch in sanitizing my crappy setup.

gabriel_laddel_p: if someone has a problem with it, speak now

asciilifeform: at no point, interestingly, is there much of any kind of pressure to make a widget that ~actually works~

asciilifeform: pretty lulzy inversion of the usual corporate dynamic, where there are shareholders and they want growing profits; instead there is a printolade supplier, who wants manageable (or -- optimistically -- slowing!) bleed

asciilifeform: the way i currently understand the 'microinverter' nonsense, is that enphase found a further chineseification of the solar scamatron, by replacing the traditional massive dc-ac inverter with a multitude of small chinese turds, made for use in autos

asciilifeform: and the company is on track to make a profit in the second half of 2017. Its employees have worked to significantly cut the cost of producing its signature devices, microinverters that take DC, or direct current, power from solar panels and transform it into AC, or alternating current, power for homes.'

asciilifeform: https://archive.is/k58t9 >> gourmet liquishit, e.g., 'The energy tech company with 350 employees has reported annual losses every year since it went public in 2012, including nearly $67.5 million worth of red ink last year. Since September, it has gone through two rounds of layoffs and raised about $26 million by issuing new stock and bringing in two major investors. Enphase officials say with confidence that a turnaround is underway

asciilifeform: hey shinohai et al : they have a twatter! https://twitter.com/enphase

asciilifeform: 'February 16, 2017 ... Enphase Energy, Inc. (ENPH), a global energy technology company, today announced that it has refinanced and extended its term loan facility with certain funds managed by Tennenbaum Capital Partners ("TCP") from $25 million to $50 million.'

trinque: aw fuck that's what I get for typing a privmsg by hand

jhvh1: I, jhvh1, am a wrathful bot

asciilifeform: ( once in a while some exceptionally poorly written spamatron shows up, which ~can't~ tell, on first try)

asciilifeform: i suppose they can tell that there isn't actually a wordpress installed.

mircea_popescu: a that no

mircea_popescu: you (all of you, really) are very well linked since all the trilema mentions and etc. we've built like a coven

Framedragger: ^ new (trivial) command. a bunch of URLs so may be useful

asciilifeform: (though to grind it to an ~unusable halt, for a long time -- is quite easy)

mircea_popescu: in fairness it's entirely my fault, i got bored with sql import and interrupted it. didn't work so well seeing how it was a write op.

asciilifeform: i recall, we had a thread where mircea_popescu: 'it never once crashed'

mircea_popescu: this is also the first time a mysql db crashed in my personal experience.

Framedragger: not a boring day!

mircea_popescu: a superficial cat | strings | grep yielded a bunch of old stuff so it doesn't appear dataloss is guaranteed.

mircea_popescu: i still have nfi elephantiazis hit that poor file that it ended up 40g, but anyway, im moving the whole shebang on a tb partition and will see wtf myisamchk does.

Framedragger: mebbe you had a separate /var partition from linux install long ago, mircea_popescu.. this can bite

asciilifeform: ( aug. 3, 2016 : 'Enphase entered into a $25 million loan agreement with a lender specializing in "rescue financing" that furnishes capital "to avoid a restructuring or insolvency.'"' )

mircea_popescu: anyway, turns out the myslq files are stored on a tiny partition for some incomprehensible reason. fancy that wonder.

phf: i usually pipe du through sort or awk >n. i kind of wish there was an "h" command instead that would take a column number an humanize that column

asciilifeform: Framedragger: for some reason i am reminded of a cartoon i saw when i was very small, incidentally iirc it was made in some baltic country, where an eagle decides that frog is his son and threatens constantly to 'teach him to fly' by throwing from a cliff

Framedragger: i'm waiting for the day that freenode goes down while datacenters with logotrons are experiencing issues. everyone's gonna freak out, there will be a new more urgent push for gossipd, it's gonna be great!

mircea_popescu: "every thing you do will resolve 99% of the problem at the most". always a little bit left. gah.

asciilifeform: that's what 'db' is, a massive pile of shit that pretends to be 'one size fits all' data structure

a111: Logged on 2017-02-19 03:54 asciilifeform: (iirc we had a thread where i described how corporate ameritards, if given a problem like phuctor, would happily soak up a few $mil and megawatt of iron)

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: 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.

Framedragger: ftr, useful SO answer (yes, SO): http://stackoverflow.com/a/13155778

Framedragger: there are ways to list/remove locks but i reeeeally dunno if it's a good idea

Framedragger: do you still have a running mysql cli session mircea_popescu?

asciilifeform has lived there for a while, knows where the good beaches and restaurants are.

mircea_popescu: why is there a metadata lock and how do i turn it off

mircea_popescu: there's a "repair by sorting" going and five billion agents waiting for metadata lock

Framedragger: there's a KILL QUERY

Framedragger: hmh it should at least fail, or sth. is it still running mircea_popescu? can you do `show processlist` with separate mysql client session? (NB, am not a mysql guy)

mircea_popescu: because why ? because OH MY FUCKING GOD SOMEONE RAN A 2MB SQL an hour ago!!1

mircea_popescu: well apparently trilema's going to be offline for a while for reasons of unexpected explosion.

mircea_popescu is undeterred, created sql file, is importing it, which apparently takes A WHILE

Framedragger: so on account of that n-gate guy being reachable via twitter only, and me not wanting to miss any replies, i've actually had to visit twitter lately. my homepage now is http://imgur.com/a/aTcpY and fuck this shit

Framedragger: mircea_popescu: you're putting it in mysql aren't you, and making php generate a table or sth?

mircea_popescu: aaaand in other lulz...trilema can't actually hold a 3mb data dumb.

mircea_popescu: well, old man lasted almost half a year.

asciilifeform: meanwhile, in monkeystan, https://archive.is/z8x2c >> 'You don't handle sarin-saturated bodies *without gloves* - unless you're a Syrian rebel trying to pull off yet another hoax.'

asciilifeform: aseriousgogetta (~Kimberley@ip-64-134-144-245.public.wayport.net) has joined #trilema << hey mircea_popescu , can haz hammer ? every time that monkey's connection cycles, i feel like a chimp is throwing shit in my face

Framedragger: i sed'ed the relative urls, as in "<a href="/">Submit GPG Key</a>", to point them to phuctor, etc

asciilifeform: want a csv ?

mircea_popescu: shave like a megabyte off this turd