Re: Server going away after a few seconds
Many problems with the table design ...
> GradYear text(12),
Nonsense, should be smallint unsigned.
Me: this field also needs to contain some text when the year isn't exact, such as 'Unknown'
> Email varchar(25),
Email addresses can be 127 chars long.
Me: All of these are well under the 25 character length.
> ChangeDate char(12),
Yikes, should be type DateTime or Timestamp
Me: This contains not only full dates, but also things like 'Dec 2016' or simply '2016?'.
> DeceasedDate char(12),
Should be type Date.
Me: Same as for ChangeDate
> Obituary varchar(40)
If that's supposed to hold URLs, it's too small.
Me: Holds a pointer to another table, no need for anything larger.
Slapdash table design like that leads to data errors and poor performance. Take a bit of time to read about relational databases, work through a few web tutorials on
the subject, then work through the opening chapters of the MySQL manual.
Me: No Comment
-------------------------------------------------------------------------
> 1) Loading Schemas takes about 1 1/2 minutes.
> 2) Loading Tables takes about the same time.
Sounds like a severely underpowered or misconfigured system. Let's start with what version of MySQL are you running, What is the OS, how much RAM is there,
what is innodb_buffer_pool_size?
MySQL 5.5.42 This is a commercial hosting provider, Hostmonster.com. I doubt that it is underpowered.
Have no idea about RAM size, (I suspect that it is large), nor innodb_buffer_pool_size.
Workbench is running on Windows 8.1
Processor Intel(R) Core(TM)2 Duo CPU e8400 @ 3.00GHz 2.99 GHz
Installed Memory (RAM) 8.00 GB (7.84 GB usable)
System type: 64-bit Operating System, x64-based processor