Danblack: would it make.

 
Callinan: Well, it’s not really, the code tests take about 10 minutes to go

Sackrider: Given i don’t even know which language you are using any attempt at an answer is probably flawed.

Shareef: Hi, I am trying to upgrade mysql 5.1 to 5.5 on a windows server however it appears that the mysql 5.5 doesn’t register that 5.1 is installed and upgrade it, it only installs a second copy of mysql

Chapko: Danblack: well, to get the code to a system and for it to run in chef takes a while.

Keiter: Riceandbeans: I’m sure you’ll figure out a way – what language are you using to make the prepared statement, anyway?

Dambach: Ahhhh devops problems

Ramsour: What’s the longest you’ve ever had a db dump take?

Rhue: A day. not sure how that helps you though.

Krings: But my DBAs were complaining about 8 hours for a specific DB

Mantooth: I didn’t know if that was totally absurd or not

Marrett: I’ve never managed a DB that took more than a minute to dump

Harralson: If I am running a Windows Server 2012 R2 webserver with IIS and mysql on it, do I want mysql to start before IIS?

Keiter: Mr_Midnight: why would it matter?

Salzman: Keiter: dunno but the webserver in question that I inherited when I took over at this job has an issue where mysql takes about 30 min to start up and have a database accessible

Stansell: Riceandbeans: there are ways to optmise time, DBAs should be able to present some options with tradeoffs made.

Kreke: I’ve not done much with web servers previously and so I wasn’t sure if mysql likes to start up first. I can’t figure out why it takes it 30+ minutes to start up

Keiter: Mr_Midnight: check the mysqld logs, perhaps.

Bhakta: Wow, 30+ minutes startup time seems excessive

Stiliner: Lost_soul: especially since the only database that exists on this server is a wordpress install

Keiter: Maybe InnoDB was recovering

Bulliner: Well. 3 empty wordpress databases then the real one.

Whittington: Mr_Midnight: read the mysql log file. if in doubt pastie.org it and ask.

Jadoo: Danblack: where can I find the mysql log file?

Goeltz: If you have it running – show global variables like ‘%error%’;

Patrylak: Could be hostname.err in the datadir.

Dornseif: Http://pastebin.com/FxELPTAz

Peat: Danblack: that’s what the standard startup logs look like

Bayuk: How big are ib_logfiles*

Marsha: Why are unclean shutdowns occuring?

Brafford: Why is the innodb_buffer_poolsize only 107M?

Gallimore: The last “unclean” shutdown was a reboot of the server

Koskinen: Was done via start menu, then restart

Cvetkovic: The two ib_logfiles are 55 MB

Zoss: I don’t know anything about configuring a mysql server. this was setup by the previous network admin using the wordpress guide to installing via IIS which called for using the Microsoft Web Platform Installer. I know some changes were made to the my.ini but I don’t know exactly what

Losey: Hey guys, I’m trying to store a JSON string into a column thats defined as a LONGTEXT. In the JSON string, I am trying to store a directory path that ends up having two forward slash c://tmp. However, when I read the JSON string back from the table, the directory path only has on forward slash c:/tmp. Am I doing something wrong when I insert the JSON string?

Swancutt: Lol, storing JSON in a LONGTEXT.

Schweppe: Mr_Midnight: well ib_logfile sizes seem sane. your clean reboot obviously isn’t. increasing innodb_buffer_poolsize will speed up recovery size if you have ram available. generally increase this to contain a lot of any free ram on the server.

Swancutt: In case you need to store 3gb of JSON in a row, I guess.

Mahran: Danblack: would it make sense to setup a scheduled task on shutdown of the server to run a proper mysql shutdown command?