|
qhat posted:it's un loving believable the amount of hoops you have to jump through to get that DB to work well enough to be considered production ready. but hey i guess if you hate stored procedures and replication because you see those features as just unnecessary and for spergs only, then go loving nuts you can do both of those things w MySQL and it's not hard
|
# ? May 21, 2016 01:42 |
|
|
# ? Mar 28, 2024 16:04 |
|
Tiny Bug Child posted:you can do both of those things w MySQL and it's not hard Your expertise is in hard dicks not hard dbs
|
# ? May 21, 2016 03:30 |
|
Tiny Bug Child posted:you can do both of those things w MySQL and it's not hard i already said you can do them but the way they are implemented in mysql is near totally worthless for production systems
|
# ? May 21, 2016 12:52 |
|
our server guy set up replication so idk too much about it other than how to stop/start it when i gently caress it up but what's wrong with mysql stored procs. i use them p much every day and have never had a problem
|
# ? May 21, 2016 16:48 |
|
qhat posted:i already said you can do them but the way they are implemented in mysql is near totally worthless for production systems why is that? just wondering because we have a thing in maria db and it sucks rear end and we want to go to post gres but we wont be able to get `platinum support` from our massive ops team so we're sorta stuck with mysql unless we want to support the db ourselves (we do not) i was going to try to make the db situation better with sprocs but if that's not an option ugh
|
# ? May 21, 2016 18:35 |
|
can someone explain to me what the gently caress an olap cube is. please keep in mind im a non-technical woman or childe that doesnt touch computers for a living.
|
# ? May 22, 2016 10:20 |
|
refleks posted:can someone explain to me what the gently caress an olap cube is. please keep in mind im a non-technical woman or childe that doesnt touch computers for a living. it's like map of temperatrues, where you have distance x and distance y on different axis and in the cells you have the temperature values. Except maybe you also have height on the z axis and it represents temperature in volumes of the atmosphere, so now you have a cube. And maybe you also have an other axis which represents time, so now you have a hypercube showing temperatures in volumes of the atmosphere over time (don't try and visualise this). etc Then there are loads of ways of extracting subsets of the information. You might only want to know temperature at 8km up, or maybe just how it changed over time at a specific point in time.
|
# ? May 22, 2016 11:40 |
|
you could also have another dimension for measures, eg pressure or humidity (and then all your previous values turn out to just have been in the "temperature" slice). obviously you can quickly end up with a lot of data as the total size of your table is the product of the lengths of the different dimensions e: to be clear you will probably only have one dimension defining all the different measures distortion park fucked around with this message at 11:51 on May 22, 2016 |
# ? May 22, 2016 11:44 |
|
I had to try and make a user interface to help non technical management and children make charts from any slice of an olap cube and failed miserably. we just hard code them now as no one else in the org understands it
|
# ? May 22, 2016 11:46 |
|
MALE SHOEGAZE posted:why is that? just wondering because we have a thing in maria db and it sucks rear end and we want to go to post gres but we wont be able to get `platinum support` from our massive ops team so we're sorta stuck with mysql unless we want to support the db ourselves (we do not) easily the most glaring and severe problem with mysql replication is it's all done in a single thread on the replicas. basically when changes happen on the master they get written to what's called a binary log, and when a slave connects to the master two threads are set up, one that streams the log constantly from the master and the other which executes replication events contained within the log. the thread which executes the replication events from the log is what i mean by single threaded being a limitation. i suppose it's not a huge deal if your use case is fairly small with a low amount of writes and mostly reads, but if you have fucktons of writes coming in then it's a real possibility that your replication will not be able to keep up. ratio doesn't even really matter with large enough DBs, eventually writes are going to scale up. we used to use mysql at our company back in the earlier days and the way we got around it was building an application layer toolkit which literally replicates write queries out to two identical db hosts lol. yeah it's ugly, especially when one of the boxes goes out of service for whatever reason, but still more scalable than dogshit mysql replication. now we use SQL server mostly though and it's great. also wrt stored procedures, when most people think of server side stored procedures, they think about the performance benefits of having the query plans generated and cached server-side waiting and ready for any lucky soul who wants to call it. no not with mysql though, query plans are generated every single time for each new connection, so it's kind of pointless for application that have a high volume of re-connections (like basically any web app that doesn't cache connection objects).
|
# ? May 22, 2016 12:50 |
|
pointsofdata posted:it's like map of temperatrues, where you have distance x and distance y on different axis and in the cells you have the temperature values. Except maybe you also have height on the z axis and it represents temperature in volumes of the atmosphere, so now you have a cube. And maybe you also have an other axis which represents time, so now you have a hypercube showing temperatures in volumes of the atmosphere over time (don't try and visualise this). etc that sounds like a hosed thought from someone who looked at pivot tables in Excel and thought: "This, but only more insane"
|
# ? May 22, 2016 17:28 |
|
yeah someone should pass a law that forces the universe to make all values depend on at most two variables. would solve this whole thing right quick
|
# ? May 22, 2016 17:32 |
|
refleks posted:can someone explain to me what the gently caress an olap cube is. please keep in mind im a non-technical woman or childe that doesnt touch computers for a living. most sql dbs are oltp (on line transaction processing) which means they are optimized for inserting, updating and retrieving rows. you can do joins to do complex queries across tables but they are never as fast as just retrieving rows via indexes already defined olap (on line analytical processing) dbs are optimized instead for those complex queries where you want to see all users that clicked on a certain link, all links on your page they clicked, the times they clicked them and you want it all grouped by the referrer and maybe by the region of the planet they were located in or something. have fun making that query fast with a normalized schema in practice this means refactoring your db to use star schemas and fact tables, using a column store like vertica or redshift or building an olap cube an olap cube is a database that precomputes denormalized rows containing all attributes you might want to query on. so instead of multiple joins and self joins you just do a boring query on a single table with a bunch of indexable WHERE clauses the talent deficit fucked around with this message at 17:45 on May 22, 2016 |
# ? May 22, 2016 17:38 |
|
refleks posted:that sounds like a hosed thought from someone who looked at pivot tables in Excel and thought: "This, but only more insane" more or less, yeah. it's a very useful way of looking at some datasets though though!
|
# ? May 23, 2016 10:10 |
|
BooLoo posted:it's still very boring though. agreed
|
# ? May 23, 2016 10:13 |
|
I know how to HTML is that like sql?
|
# ? May 23, 2016 10:13 |
|
Displeased Moo Cow posted:I know how to HTML is that like sql? how about i inner join your face with a table
|
# ? May 23, 2016 10:22 |
|
wat
|
# ? May 23, 2016 10:28 |
|
I will fight you
|
# ? May 23, 2016 10:28 |
|
your dreams and pride will be crushed
|
# ? May 23, 2016 10:29 |
|
you will be no match for my number 8 wire and a fence post
|
# ? May 23, 2016 10:31 |
|
7 pages and nobody posted http://howfuckedismydatabase.com ?
|
# ? May 23, 2016 10:41 |
|
also if you absolutely need to do an mysql then percona is a better choice than oracle mysql and now mariadb has caught up as well with 5.6 But just use postgres instead
|
# ? May 23, 2016 10:43 |
|
OK
|
# ? May 23, 2016 10:59 |
|
i had some troubles with a percona cluster today, because selinux was enabled. the official advice from percona was "just disable selinux lol". php level garbage.
|
# ? May 23, 2016 13:40 |
|
pointsofdata posted:it's like map of temperatrues, where you have distance x and distance y on different axis and in the cells you have the temperature values. Except maybe you also have height on the z axis and it represents temperature in volumes of the atmosphere, so now you have a cube. And maybe you also have an other axis which represents time, so now you have a hypercube showing temperatures in volumes of the atmosphere over time (don't try and visualise this). etc this sounds insane but also cool
|
# ? May 23, 2016 13:46 |
|
spankmeister posted:7 pages and nobody posted http://howfuckedismydatabase.com ? lol i read that article about the nuclear material and saw "SQL Server 6.5" and thought god dang that's old as gently caress, but then i realised the article was written 14 years ago
|
# ? May 23, 2016 13:53 |
|
a guy at our company recently was trying to connect to SQL Server 2014 servers via multisubnet failover + alwayson using some ancient driver for SQL Server 6.0 but for some reason kept insulting people who recommended he not use a driver from the loving mid-nineties. maybe he's a poster here
|
# ? May 23, 2016 13:57 |
|
the talent deficit posted:most sql dbs are oltp (on line transaction processing) which means they are optimized for inserting, updating and retrieving rows. you can do joins to do complex queries across tables but they are never as fast as just retrieving rows via indexes already defined But cant the same things be achieved with views in SQL, and GROUP CLAUSES, or are those still inefficient?
|
# ? May 23, 2016 19:18 |
|
spankmeister posted:7 pages and nobody posted http://howfuckedismydatabase.com ?
|
# ? May 23, 2016 19:25 |
|
spankmeister posted:7 pages and nobody posted http://howfuckedismydatabase.com ? lol, i remember this ↳ Oracle quote:That depends. quote:It might work!
|
# ? May 23, 2016 20:58 |
|
my stepdads beer posted:i had some troubles with a percona cluster today, because selinux was enabled. the official advice from percona was "just disable selinux lol". php level garbage. lol
|
# ? May 23, 2016 21:12 |
|
St Evan Echoes posted:its actually real good aside from a few weird design decisions like no boolean/bit datatype unsurprisingly, Django does not really work well with Oracle
|
# ? May 23, 2016 21:27 |
|
The oracle one is vgood
|
# ? May 23, 2016 21:28 |
|
refleks posted:But cant the same things be achieved with views in SQL, and GROUP CLAUSES, or are those still inefficient? you can make all the same queries, they're just gonna be slow if you don't do the transformation to a cube or star schema
|
# ? May 23, 2016 21:44 |
|
the talent deficit posted:you can make all the same queries, they're just gonna be slow if you don't do the transformation to a cube or star schema Just lmao if u don't set up a token ring schema
|
# ? May 25, 2016 03:59 |
|
Yo g wash pass that tuple
|
# ? May 25, 2016 07:33 |
|
gem from my annual survey of the festering shitheap of graph dbs and graph db creators and users http://orientdbleaks.blogspot.com/
|
# ? May 25, 2016 07:42 |
|
is there a good olap database that's open source?
|
# ? May 25, 2016 11:17 |
|
|
# ? Mar 28, 2024 16:04 |
|
qhat posted:is there a good olap database that's open source? apache kylin, sort of
|
# ? May 25, 2016 20:59 |