Sollie: I don’t know what to replace anything with. This is my time to learn.
Keiter: Volund: take your time. Read docs.
Notarnicola: Keiter: I have to find out which docs to read. 😛 there are so many interwoven systems here like apache and mysql and the php configs and the mediawiki configs and augh I dunno where to start. anyways
Chambers: The reason I am so n00b: I am a MUSH administrator, not a Linux admin. D: used to working with a managed server where everything just works and is well-configured. this person whose MUSH I’m helping out is running on their own VPS, which is cheaper, but. waaaaay more complicated.
Proveaux: Brittman and BlaDe , I want to thank you both for your time and information, it helped us a lot.
Nati: Right now I’m still focused on learning Linux itself. :/
Keiter: Volund: it’ll probably take weeks/months to get ahead of this
Villot: _Zodiac: of course, good luck!
Mokriski: Back again :D, having this shocking number found, max_user_connections 2147483647 isnt that not muchhhhhh to high?
Brittman: _Zodiac: what is max_connections?
Brittman: _Zodiac: max_user_connections is bound by max_connections
Boppre: Lmao so setting it to a normal amount would be? 120 ?
Breslawski: Keiter: belatedly, yeah. I only just installed Ubuntu on my desktop after years of being a Windows guy. I’m not -totally- new to the concepts, but am behind on practical experience so everything’s slow.
Perz: I know how to ssh around, navigate the file system, run things and install packages, but a lot of the fine details for what everything is doing. not so much.
Danns: Also thank god for nano because I cannot vi to save my life
Burggraf: At least I started out knowing this much. :
Delung: Volund, use virtualization to your advantage. Instead of testing your fixes in production why don’t you generate a vm in virtualbox/kvm that has similar memory constraints as your vps
Serasio: Delung: yeah, good idea.
Molacek: Any ***istance with gettign this configuration optimized a bit better is appreciated. http://pastie.org/pastes/10436057/text?key=62rwb44lqjv4kkrw8taqdq http://pastie.org/pastes/10436096/text
Cafarella: I upgraded from 5.1 32bit recently to 5.5 64bit and im finding more resources being used than before and slower queries
Caruso: Xgc: how can I do that . the isolation level part, and getting the data that was inserted to be available, sooner than later, for use ?
Honeysucker: Vegivamp: intermediate commits during m*** import /
Mcalpine: That one went over me. didn’t understand
Marshman: Willette: I’m using 5.1.69 in production. I have to dump a table; truncate it; add a column; import all that data back into that same table
Brittman: Scott0_: only mysqld runs on this server? only things changed were os version/arch, mysql version, and innodb_buffer_pool_size?
Brittman: Scott0_: slower queries could just be table statistics, did you compare the EXPLAIN of such a slow query on the older server to see if the same join order, indexes, etc are used?
Funkhouser: Brittman: apache with php and nullmailer, that’s it.
Cowser: Brittman: im getting no slow query logs to mention
Ketola: Just requests for data to build graphs take significantly longer than they did on the previous server
Bluel: I might also mention going from Xen to KvM on the VPS
Kalinger: Not sure if that’s any impact, I’ve heard either direction on that topic
Brittman: Scott0_: “just apache”?
Brittman: Scott0_: what does “build graphs” mean specifically in terms of a specific query in mysql being slower?
Haroldson: The page is built when mysql is finished gathering the data
Herendeen: The data being stored in the database table, and being queried
Goepfarth: Im not sure what you are asking
Brittman: Run the query on your new server and the old server, compare explains. be sure to use: select sql_no_cache . and run the query a few times