#mysql
02 January 2008
Total 23 pages. You are browsing page 4/23.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:35 <****> hm
03:35 <****> freebsd 6.2?
03:35 <****> can't go to the datacenter right now
03:35 <****> both with mysql on our dbs and with pf+carp+bridge psuedo-device on our firewalls
03:35 <****> why are you using fbsd for mysql?
03:36 <****> because it's a vastly superior OS? :)
03:36 <****> it's not a good combinaison.
03:36 <****> linux and mysql much better combination
03:36 <****> mysqld on *BSD does not work well, normally.
03:36 <****> http://jeffr-tech.livejournal.com/5705.html
03:36 <****> so should think about going with linuxß
03:37 <****> druid: I've always ran MySQL with freebsd, if this were prior to a lot of the SMP And threading changes that were made, I might not disagree, but you should be fine
03:37 <****> read the tuning docs for FreeBSD, do make sure you use libthr
03:38 <****> ishiboo: nice article.
03:38 <****> Druid_: test your memory before anything else
03:41 <****> http://pastebin.com/m7f1d571c
03:42 <****> I am anxious to run the workload on 7.0 when the RC comes out and see what happens
03:42 <****> ishiboo: I have to admit that I did believe the myth until now.
03:43 <****> thumbs: what myth?
03:43 <****> that fBSD cannot act (reliably) as a mysql server.
03:43 <****> obviously that doesn't disprove any myth, but I have real world experience that a properly configured setup provides excellent mysql performance/reliability
03:44 * chadmaynard has had too many problems with mysql/bsd to not believe the myth
03:44 <****> we used to be a LOT more heavily loaded around feb/march of 07
03:44 * thumbs refrains from commeting.
03:44 <****> I use obsd and fbsd for almost everything except mysql
03:44 <****> thats when the bigger boxes lost sql server and moved to freebsd :-)
03:45 <****> im the opposite, I am running linux on the web servers because they're RLX blades, and linux is the only os with the specialized serial console support
03:45 <****> everything else is freebsd and openbsd
03:45 <****> we use fBSD for the firewall
03:46 <****> actual fbsd or some packagetized version?
03:46 <****> worst thing was getting NIS/yp running with linux clients on freebsd servers
03:46 <****> thumbs: I used freebsd, running carp for failover... but with openvpn whenever the bridge device became heavily loaded, the box would freeze with no panic or reboot... had to switch the firewalls to openbsd.
03:47 * chadmaynard hugs openbsd
03:47 <****> ishiboo: I can't say I've seen that behaviour.
03:48 <****> are you running failover thumbs!?!??!?
03:49 <****> chadmaynard: no.
03:49 <****> then you wouldn't see it.
03:49 <****> I've never seen it but i've heard similar reports
03:49 <****> oh, don't be a smartass :/
03:49 <****> haha
03:49 * chadmaynard kicks chadmaynard
03:50 * thumbs kicks chad too.
03:50 <****> thumbs: I'd feel bad if you werent the first person I insulted in 2008
03:50 <****> I feel honoured.
03:50 <****> good.
03:51 * chadmaynard mumbles something about stupid canadians.
03:51 * thumbs grumbles
03:52 <****> pf/pfsync/carp are really cool.
03:52 <****> I would join #apache so you can have the upperhand but I'm still hurt from the last time.
03:52 <****> ishiboo: yes, I really like pf
03:53 <****> ishiboo: have you played with m0n0wall or pfsense?
03:53 <****> no
03:53 <****> oohhh I know. I'll just firewall chadmaynard away from #mysql with pf
03:54 <****> you'll never catch me
03:54 <****> iptables isn't bad either, I think pf took a lot from iptables
03:54 <****> but having switched to pf I've been _very_ happy
03:55 <****> hm
03:55 <****> now again
03:55 <****> no queries
03:55 <****> 99%
03:55 <****> pf has simpler syntax than iptables
03:55 <****> yeah, the rulesets are very clean
03:56 <****> so my winning combo is two dual 3.2ghz xeons (the old xeons), 4gb of ram, they run pf+carp+pfsync and then haproxy which does the web server load balancing, they've been able to handle some huuuge loads
03:57 <****> the marketing geniuses decided it would be a good idea to sell $90 nintendo wii's back last february when they were in uberdemand
03:57 <****> I also run memcached on them because there's lots of unused memory
03:58 <****> that is so weird
03:58 <****> my config.inc file changed to an older version
03:58 <****> automatically?
03:58 <****> lol
03:59 <****> Druid_: you must have trolls on your server.
03:59 <****> has this issue survived rebooting?
03:59 <****> if not I highly recommend it
03:59 <****> Druid_: has your server been compromised?
03:59 <****> not that i know of
04:00 <****> if the config file changed on "it's own", then I would argue against it.
04:01 <****> could be ZDE fucked something up
04:01 <****> if you use a graphical system manager, sure.
04:01 <****> the obvious answer is NOT to use it anymore.
04:02 <****> zde? zend?
04:02 <****> jep
04:02 <****> zend
04:02 <****> hm
04:02 <****> if you just installed the platform or whatever
04:02 <****> it could have modified my.cnf
04:02 <****> no
04:03 <****> zde only local
04:03 <****> where can i find a mysql 64bit vs 32bit guide and benchmarks?
04:06 <****> bardyr: just go for 64bit where possible
04:06 <****> kimseong, i want to but there are evil forces that does not like 64bit
04:07 <****> kimseong, a 4GB dedicated mysql, go for 64bit?
04:07 <****> no legacy needed
04:07 <****> 4gb ram
04:07 <****> depends on the workload, keep in mind only 3gb of that is usable with a 32-bit system
04:08 <****> give or take
04:09 <****> 3.25 GB
04:09 <****> depends on the os.
04:10 <****> hm
04:10 <****> my mysql.slow_log also logs 0 seconds queries?
04:11 <****> its supposed to log SLOW queries, 0 seconds is pretty fast... there is a configurable threshhold
04:11 <****> it logs query not using index too if configured to do so
Total 23 pages. You are browsing page 4/23.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last