Run the query on your new.

 
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