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.
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?