|
Maximum Leader posted:mariadb is a good database (works) but i hear postgres is faster. my queries are simple though so why bother changing what works. hope you've intenalised the 1000 weird mysql edge cases here's a bunch of them from someone who likes mysql http://mysql.rjweb.org/doc.php/ricksrots eg quote:⚈ OR may be very inefficient; turn into UNION. ah yes, good query optimiser we have here
|
# ¿ May 12, 2016 23:20 |
|
|
# ¿ Apr 29, 2024 06:25 |
|
Salt Fish posted:It doesn't matter which one you use because your boss wants to store every single hit to the website in a single 300gb table with no index. *adds index to speed up reporting, website slows to a crawl due to huge index size*
|
# ¿ May 12, 2016 23:35 |
|
tmesis posted:we use mysql and we put it on os x and we like it that way um
|
# ¿ May 13, 2016 07:04 |
|
SpaceAceJase posted:Debian mysql stack don't even say mysql is good tia
|
# ¿ May 19, 2016 12:37 |
|
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 isn't it just?? getting a slave up on a large existing database is a huge pain in the dick that involves special percona perl tools that barely work and non trivial amounts of downtime due to needing a long global lock on the master. or even more downtime if you do it hte official way and shutdown the master and rsync the data the slave
|
# ¿ May 19, 2016 23:35 |
|
300gb. bless.
|
# ¿ May 20, 2016 00:26 |
|
|
# ¿ Apr 29, 2024 06:25 |
|
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 |