MySQL Forums
Forum List  »  InnoDB

Re: Server going away after a few seconds
Posted by: David Wright
Date: April 09, 2016 08:08PM

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, 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

Options: ReplyQuote

Written By
Re: Server going away after a few seconds
April 09, 2016 08:08PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.