MySQL Forums
Forum List  »  Backup

Re: Can't restore databases, Error 1214
Posted by: Rick James
Date: May 24, 2013 07:29PM

You appear to be running entirely (or mostly) MyISAM.

( Uptime ) = 269 -- How long (in seconds) the server has been running.
-- Comment: The system has not been up long enough to get reliable suggestions for many of the issues. Fix what you can, then come back with fresh values after a few hours.

( open_files_limit ) = 1,024 -- ulimit -n
-- Comment: To allow more files, change ulimit or /etc/security/limits.conf or in sysctl.conf (kern.maxfiles & kern.maxfilesperproc) or something else (OS dependent)
-- Recommendation: change open_files_limit to 16000

( table_open_cache ) = 64 -- Number of table descriptors to cache
-- Comment: Several hundred is usually good.

You have the Query Cache half-off.
You should set both query_cache_type = OFF and query_cache_size = 0 .
There is (according to a rumor) a 'bug' in the QC code that
leaves some code on unless you turn off both of those settings.

( long_query_time ) = 10.000000 = 10 -- Cutoff (Seconds) for defining a "slow" query.
-- Comment: Suggest 2

( thread_cache_size ) = 0 -- How many extra processes to keep around
( Threads_created / Connections ) = 7 / 8 = 87.5% -- Rapidity of process creation
-- Comment: INcrease thread_cache_size:
0 good for Windows
0 is inefficient for non-Windows
-- Recommendation: change thread_cache_size to 5.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Can't restore databases, Error 1214
2057
May 24, 2013 07:29PM


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.