LisaShea Forum Logo
Previous Thread
Next Thread
Print Thread
MySQL Database Upgrade #425645
11/28/12 10:24 AM
11/28/12 10:24 AM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
I'm part-way through a large upgrade of the MySQL database that runs this forum. At this point the new MySQL version is running and the forum database is loaded into it. I think it's up and running again - please be patient as I work on poking through various things.

Hopefully this new version will help the system run more quickly.


Lisa Shea, Owner
Re: MySQL Database Upgrade [Re: Lisa Shea] #425665
12/01/12 12:14 AM
12/01/12 12:14 AM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
Dear group -

I've heard from several people that some recent posts seem to have gone missing. First I want to say that I didn't delete *any* posts at all on purpose.

When I did the SQL update from 5.1 to 5.5 I exported out all the data from 5.1, did the uninstalls and fresh installs and update stuff, and then imported all the data into the new clean 5.5 database.

In looking through my process now, I realized what must have happened. I did a trial run for all of this on 11/21 to make sure I had everything I needed. And then I did it "for real" on the night of 11/27-11/28. But it looks like for this forum I accidentally grabbed my test file to import in, the one from 11/21. So any posts made after 11/21 would have been lost.

I'm sorry about that! That's why there's a gap between those dates.

I'll see if I can fill in the missing content without it affecting anything in here now. I'm not sure that would be safe, but I'll at least see if it's possible.


Lisa Shea, Owner
Re: MySQL Database Upgrade [Re: Lisa Shea] #425666
12/01/12 12:38 AM
12/01/12 12:38 AM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
OK I think trying to re-import the missing week would be quite dangerous, because as it tried to add things onto threads it would bump into the things we have manually added onto the threads. But I do have the ability to see what was posted in the week.

So here's what I'll do. I'll manually post them myself one by one and give the proper attribution of who posted it. I realize this will look a little kludgy, but that way we won't lose the posts and we'll be able to have that history.

I apologize again for importing the wrong file! I've been fighting a head cold for about two weeks now. I guess it impacted me more than I thought. I should have triple checked the file I took.


Lisa Shea, Owner
Re: MySQL Database Upgrade [Re: Lisa Shea] #425693
12/01/12 03:18 AM
12/01/12 03:18 AM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
OK I have now manually pasted in each post that was made during the time period between when the backup was made and when I upgraded the database. This should account for all the missing posts.

Please let me know if you think I missed something!


Lisa Shea, Owner
Re: MySQL Database Upgrade [Re: Lisa Shea] #425754
12/14/12 10:10 AM
12/14/12 10:10 AM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
I have just upgraded our UBB forum software to the version that just came out yesterday - version 7.5.7. So we're on the latest and greatest forum software version. I also upgraded our table format to InnoDB.

I'm going to give it a few days to make sure everything is working, and then I'm going to upgrade us to the next level of PHP. One step at a time! Hopefully these will all help us run more quickly.


Lisa Shea, Owner
Re: MySQL Database Upgrade [Re: Lisa Shea] #425817
12/18/12 03:23 AM
12/18/12 03:23 AM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
Here is the status update.

We are now on the latest version of the UBB forum software.
We're on the latest version of PHP, the language this software is written in.
We're on the latest version of MySQL, the database the posts is stored in.
I've added FastCGI which is an accelerator.

In general the boards seem much faster. I've added debug information at the very bottom of each page and it's showing that, in general, a page takes under a half second to draw. So that's good.

The remaining issue seems to be making new posts. It seems that occasionally the act of making a new post causes a lock-up situation that then times out after 90 seconds. The post does get made. But the user sees a "time out" error and has to manually go back to the forums.

I'm working on that now. Our post table is fairly large, but even so we should be able to add to it without it locking smile.

Hopefully I can get this resolved shortly!


Lisa Shea, Owner
Re: MySQL Database Upgrade [Re: Lisa Shea] #425858
12/20/12 09:44 PM
12/20/12 09:44 PM
Joined: Oct 2004
Posts: 8,923
US
Lisa Shea Offline OP

True Blue Soulmate
Lisa Shea  Offline OP

True Blue Soulmate
Joined: Oct 2004
Posts: 8,923
US
I disabled a log file and that seemed to be what was causing the post hangs. So I haven't seen the post process actually "full stop hang" since I did that. It is slow sometimes, but it always seems to finish. So I think we have progress there.

I also tweaked the social networking code - the little icons at the bottom of each post area to work with Google+ or Facebook or so on. So I think that will now fit better on the screen and load more quickly.


Lisa Shea, Owner

Moderated by  Lisa Shea 

Search

Latest Posts
Deadpool 2
by Nathan Lee. 06/11/18 08:52 AM
Lucifer Series Cancelled
by Nathan Lee. 06/11/18 08:49 AM
Parakeet Beak/Face problem
by Nathan Lee. 06/11/18 08:47 AM
New Parakeet
by Markedg. 06/05/18 06:41 PM
Free Online Watercolor Courses
by Lisa Shea. 05/28/18 10:51 PM
Is the Holy Grail in Spain?
by Lisa Shea. 05/28/18 10:47 PM
Parakeets and Travel
by Lisa Shea. 05/28/18 01:04 PM
Name Animals Beginning with A
by Lisa Shea. 05/28/18 12:56 PM
Zoo Mysteries
by Lisa Shea. 05/28/18 12:46 PM
Repairing Chewing Damage
by Lisa Shea. 05/28/18 07:57 AM
Privacy Policy
This forum uses cookies to ensure smooth navigation from page to page of a thread. If you choose to register and provide your email, that email is solely used to get your password to you. Nothing else. Ask with any questions!
Forum Areas
General Discussion
Books, TV, Movies
Da Vinci Code
Dreams
Japanese Culture
Life, Universe, Everything
Online Courses
Politics
Religious Research
Show Your Own Work
Work From Home / Writing

Parakeets
General Parakeet Chat
Keet Stories and Photos
Parakeet Photo Gallery
Budgie Training
Health and Medical Issues
Parakeet Breeding
In Memory Of ...
Non-Budgie Pets and Animals
Non-Budgie Animal Photos
Off-Topic for Keet Owners
Games
Animal Rights
Bird / Animal Books

Subscribe
Forum Guidelines
This forum takes web safety issues very seriously. Please make sure you have read and understood our Forum Guidelines before posting.
Sponsored Link
Support Our Friends
The Animal Rescue Site
Powered by UBB.threads™ PHP Forum Software 7.6.1.1