p-lang thread: (now (have you (problems two)))

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > p-lang thread: (now (have you (problems two)))

«‹›1784 »

akadajet: Sep 14, 2003

# ? Dec 6, 2015 21:55

Adbot: ADBOT LOVES YOU

# ? May 8, 2024 06:46

ultramiraculous: Nov 12, 2003; "No..."; Grimey Drawer

ultramiraculous fucked around with this message at 01:45 on Dec 9, 2015

# ? Dec 7, 2015 13:08

Blinkz0rz: May 27, 2001; MY CONTEMPT FOR MY OWN EMPLOYEES IS ONLY MATCHED BY MY LOVE FOR TOM BRADY'S SWEATY MAGA BALLS

lol if you actually buy books instead of reading a few tutorials and the documentation

# ? Dec 7, 2015 14:06

Sapozhnik: Jan 2, 2005; Nap Ghost

your database is a piece of poo poo

if your database doesn't have a table with at least a million rows in it somewhere then it's not a database, it's an excel spreadsheet with delusions of grandeur

# ? Dec 7, 2015 15:47

Bloody: Mar 3, 2013

or its a sqlite database

# ? Dec 7, 2015 16:13

Wheany: Mar 17, 2006; Spinya^{ha^{ha^haha}ha}ha_{ha_{ha_haha}ha}ha!; Doctor Rope

Mr Dog posted:

your database is a piece of poo poo

if your database doesn't have a table with at least a million rows in it somewhere then it's not a database, it's an excel spreadsheet with delusions of grandeur

SELECT count(*) FROM <table>;
12723774

fight me irl

# ? Dec 7, 2015 16:24

Wheany: Mar 17, 2006; Spinya^{ha^{ha^haha}ha}ha_{ha_{ha_haha}ha}ha!; Doctor Rope

ps. it's mysql

# ? Dec 7, 2015 16:25

MononcQc: May 29, 2007

is it running on MyISAM for you to be running these blatantly frivolous SELECT on the whole table? Is MyISAM still terrible and taking full table locks for writes (and forcing you to use InnoDB, which made SELECT ... FROM table very costly?)

I haven't looked at MySQL stuff in years by now.

# ? Dec 7, 2015 16:43

Sweeper: Nov 29, 2007; The Joe Buck of Posting; Dinosaur Gum

lol come to the ~*cloud*~ where your 12mm rows is noise

# ? Dec 7, 2015 16:45

Wheany: Mar 17, 2006; Spinya^{ha^{ha^haha}ha}ha_{ha_{ha_haha}ha}ha!; Doctor Rope

Sweeper posted:

lol come to the ~*cloud*~ where your 12mm rows is noise

well, at least it's not an excel spreadsheet with delusions of grandeur

# ? Dec 7, 2015 16:49

MononcQc: May 29, 2007

we have a replica that's stuck at >3MM rows lagging behind right now

# ? Dec 7, 2015 17:54

Spime Wrangler: Feb 23, 2003; Because we can.

my db is literally a couple megs of parsed excel spreadsheets, its got like 70k rows max

but the tables are all data on actual physical keep-civilization-running infrastructure so your ~webscale~ advertising systems can suck it

# ? Dec 7, 2015 19:07

Bloody: Mar 3, 2013

i once had a two terabyte mssql server on my home computer

it was very slow

lotta rows tho

# ? Dec 7, 2015 20:54

jre: Sep 2, 2011; To the cloud ?

MononcQc posted:

we have a replica that's stuck at >3MM rows lagging behind right now

Single threaded replication, glad I don't have to deal with mysql any more

# ? Dec 7, 2015 21:00

Wheany: Mar 17, 2006; Spinya^{ha^{ha^haha}ha}ha_{ha_{ha_haha}ha}ha!; Doctor Rope

oh yeah?! well my dick is bigger than yours!

# ? Dec 7, 2015 21:14

Wheany: Mar 17, 2006; Spinya^{ha^{ha^haha}ha}ha_{ha_{ha_haha}ha}ha!; Doctor Rope

that is most likely not true. i'm sorry.

# ? Dec 7, 2015 21:14

MononcQc: May 29, 2007

jre posted:

Single threaded replication, glad I don't have to deal with mysql any more

It's postgres and it had some weird-rear end case where a WAL segment went missing. It was simpler to boot new replicas and swap them than fix anything else.

# ? Dec 7, 2015 21:21

suffix: Jul 27, 2013; Wheeee!

MononcQc posted:

is it running on MyISAM for you to be running these blatantly frivolous SELECT on the whole table? Is MyISAM still terrible and taking full table locks for writes (and forcing you to use InnoDB, which made SELECT ... FROM table very costly?)

I haven't looked at MySQL stuff in years by now.

myisam kept track of the exact number of rows in each table so as a special case it could answer "select count(*)" queries really quickly

with innodb it's a simple full table scan, same as most postgresql and most other dbs i think

# ? Dec 7, 2015 23:02

MeruFM: Jul 27, 2010

3.7 billion lines of tracking data

spare no expense

# ? Dec 7, 2015 23:56

tef: May 30, 2004; -> some l-system crap ->

MononcQc posted:

It's postgres and it had some weird-rear end case where a WAL segment went missing. It was simpler to boot new replicas and swap them than fix anything else.

sounds like your postgres team are idiots

# ? Dec 8, 2015 01:14

MononcQc: May 29, 2007

tef posted:

sounds like your postgres team are idiots

you should see the bugs we create for ourselves in our own data sync layers.

# ? Dec 8, 2015 01:27

FamDav: Mar 29, 2008

in case your yospos.dat is out of date, these two work at the same company

# ? Dec 8, 2015 01:35

tef: May 30, 2004; -> some l-system crap ->

MononcQc posted:

you should see the bugs we create for ourselves in our own data sync layers.

we'll fix it with kafka

# ? Dec 8, 2015 01:36

JawnV6: Jul 4, 2004; So hot ...

FamDav posted:

in case your yospos.dat is out of date, these two work at the same company

should be obvious from the subtef

# ? Dec 8, 2015 01:36

suffix: Jul 27, 2013; Wheeee!

tef posted:

we'll fix it with kafka

our kafka randomly deletes replicated partitions left and right but it syncs them up again pretty fast so it still passes as one of our more reliable components

we'll probably even hold up on upgrading to the version that fixes the problem until the next point release

# ? Dec 8, 2015 02:37

Soricidus: Oct 21, 2010; freedom-hating statist shill

FamDav posted:

in case your yospos.dat is out of date, these two work at the same company

I switched my yospos.sqlite to cassandra and now i can't even tell whether it's up to date or not

# ? Dec 8, 2015 03:52

Sapozhnik: Jan 2, 2005; Nap Ghost

Soricidus posted:

I switched my yospos.sqlite to cassandra and now i can't even tell whether it's up to date or not

# ? Dec 8, 2015 07:26

ahmeni: May 1, 2005; It's one continuous form where hardware and software function in perfect unison, creating a new generation of iPhone that's better by any measure.; Grimey Drawer

I can't think of a good consistency joke now but it'll come to me eventually

# ? Dec 8, 2015 08:13

tef: May 30, 2004; -> some l-system crap ->

suffix posted:

our kafka randomly deletes replicated partitions left and right but it syncs them up again pretty fast so it still passes as one of our more reliable components

we'll probably even hold up on upgrading to the version that fixes the problem until the next point release

that's pretty good for an apache project

# ? Dec 8, 2015 08:58

gonadic io: Feb 16, 2011; >>=

ahmeni posted:

I can't think of a good consistency joke now but it'll come to me eventually

# ? Dec 8, 2015 10:09

Cybernetic Vermin: Apr 18, 2005

suffix posted:

our kafka randomly deletes replicated partitions left and right but it syncs them up again pretty fast so it still passes as one of our more reliable components

we'll probably even hold up on upgrading to the version that fixes the problem until the next point release

built-in chaos monkey, p. next-level

# ? Dec 8, 2015 10:19

karms: Jan 22, 2006; by Nyc_Tattoo; Yam Slacker

ahmeni posted:

I can't think of a good consistency joke now but it'll come to me eventually

# ? Dec 8, 2015 14:27

Symbolic Butt: Mar 22, 2009; (_!_); Buglord

today I just said in passing "java is pass by reference I think.... right?"

lol at the discussion that followed

# ? Dec 9, 2015 20:19

JawnV6: Jul 4, 2004; So hot ...

Symbolic Butt posted:

said in passing

# ? Dec 9, 2015 20:20

Soricidus: Oct 21, 2010; freedom-hating statist shill

Symbolic Butt posted:

today I just said in passing "java is pass by reference I think.... right?"

lol at the discussion that followed

well, if you will go round being wrong ...

# ? Dec 9, 2015 20:28

Symbolic Butt: Mar 22, 2009; (_!_); Buglord

I'll never use the terms "pass by reference" or "pass by value" ever again

# ? Dec 9, 2015 20:35

Elder Postsman: Aug 30, 2000; i used hot bot to search for "teens"

hey what do y'all think of Go

there are people here talking about it and one person using it, i don't know anything about it except it's from google.

# ? Dec 9, 2015 20:43

qntm: Jun 17, 2009

code:

function modify(input) {
	input = "red"
}

var x = "blue"
modify(x)
print(x) // "blue" indicates variable was passed by value
         // "red" indicates variable was passed by reference

# ? Dec 9, 2015 20:44

Cybernetic Vermin: Apr 18, 2005

Elder Postsman posted:

hey what do y'all think of Go

there are people here talking about it and one person using it, i don't know anything about it except it's from google.

it is a bad language design somewhat salvaged by having experienced people doing library and platform work on it

a bit like og java in that way

# ? Dec 9, 2015 20:50

Adbot: ADBOT LOVES YOU

# ? May 8, 2024 06:46

jre: Sep 2, 2011; To the cloud ?

Elder Postsman posted:

hey what do y'all think of Go

there are people here talking about it and one person using it, i don't know anything about it except it's from google.

It's ability to create a single binary which you just plonk on any server without needing to install a 100,000 packages loving owns,
as does the cross compilation

# ? Dec 9, 2015 20:56

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > YOSPOS > p-lang thread: (now (have you (problems two)))

«‹›1784 »