#maria Log v0.1

logs Catalogue

This page loads from the db, refresh as and when. It displays 24 hrs
For older data http://marialog.archivist.info/previous.php, logs go back to 2009-01-18
Some user stats
Table logs
date_time
user
message
2015-02-28 14:38:39
fefo
MariaDB-server-10.0.14-1.el6.x86_64 -> does anyone experience memory leaking leading to swap consumption to +-100% ??
2015-02-28 14:39:30
fefo
it's running live, and I have to restart it approximately every 2 weeks (swap =20G)
2015-02-28 14:44:49
Geoff_Montee
fefo: i haven't seen that happen. have you thought about upgrading to 10.0.16 to see if that changes things?
2015-02-28 18:00:34
serg
Geoff_Montee: to 10.0.17 now :)
2015-02-28 19:24:05
paul_uk
hey, can anyone help me with something simple. im retrieving 2 columns and doing a calculation. but the sql result is vastly different: http://pastie.org/private/onld6ekieh5nvpzxtqofwq
2015-02-28 19:27:31
ebergen
um
2015-02-28 19:27:58
ebergen
http://pastie.org/9989962
2015-02-28 19:31:16
paul_uk
ebergen: oh god. i have some remnant code multiplying the result by 100.
2015-02-28 19:31:28
ebergen
nice
2015-02-28 22:42:38
fefo
Geoff_Montee: there was already one upgrade done.. from 5 -> 10 (major)
2015-02-28 22:43:01
fefo
Geoff_Montee: I hoped it would help, but it didn't help
2015-02-28 22:43:53
fefo
I did run mysqlperftunner to see, if there are some "misconfigured limits" but everything looks normal so far..
2015-02-28 22:44:32
fefo
and even if there were some stupid limit, it shouldn't act like this..
2015-02-28 23:38:08
mynameisdeleted
so.. read intensive database application limited in speed by reads from a table rarely written to
2015-02-28 23:38:12
mynameisdeleted
will 24 cores run well for far more users than just 4 cores or does the one table thing limit this to 1 effective thread used at a time?
2015-02-28 23:38:35
mynameisdeleted
do more cores allow a single table to be read faster from more users at the same time?
2015-02-28 23:38:45
mynameisdeleted
or will it only imrpvoe speed of reading from differnet tables at the same time
2015-02-28 23:40:37
mynameisdeleted
does this answer depend on innodb vs myisam?