65,488 reputation
1067153
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 7 months
seen 55 mins ago

One of JEHOVAH's Witnesses

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


Sep
26
reviewed No Action Needed Is it okay to put dots in SQL Server database names?
Sep
26
reviewed No Action Needed Subquery or multiple left joins, or both?
Sep
26
reviewed Reviewed Restoring Magento MySQL db to
Sep
26
reviewed Close CROSS JOIN and updatable model design for Ruby on Rails
Sep
26
reviewed Close Get records that have associations in other tables
Sep
26
revised How to make MySQL log to 2 separate remote servers?
added 5 characters in body; edited title
Sep
26
answered Mysql got signal 11 error
Sep
26
comment SQL: SOS: MySQL indexes overloads disk
You should post that as a separate question
Sep
26
comment Using an index for both asc and desc on a string column
Marvelous collation demo :-O !!! +1
Sep
26
revised SQL: SOS: MySQL indexes overloads disk
added 725 characters in body
Sep
26
answered SQL: SOS: MySQL indexes overloads disk
Sep
26
comment SQL: SOS: MySQL indexes overloads disk
Almost that same amount of space. BTW is the table MyISAM or InnoDB ?
Sep
26
comment SQL: SOS: MySQL indexes overloads disk
@akuzminsky is correct. Free some space. Do you some binary logs that can be deleted ? Can /var/log/messages be truncated ? Do you have any uncompressed mysqldumps that can be deleted ?
Sep
26
comment SQL: SOS: MySQL indexes overloads disk
Dropping indexes does not free up the space. It simply marks the indexes as deleted. Attempting to run OPTIMIZE TABLE requires space for temp table operation.
Sep
26
comment Threads_cached 0 while thread_cache_size > 0
If the cache miss rate is that high, your thread_cache_size may still be too small and needs to be increased. I am basing it on the MySQL Documentation (dev.mysql.com/doc/refman/5.6/en/…)
Sep
26
comment Threads_cached 0 while thread_cache_size > 0
During the mysqlslap execution, please run select format(TC*100/CN,2) CacheMissRate from (select variable_value TC from information_schema.global_status where variable_name='Threads_created') A,(select variable_value CN from information_schema.global_status where variable_name='Connections') B; multiple times and tell me you get.
Sep
25
revised want to find out which databases are used in last 30 days or not
added 1168 characters in body
Sep
25
revised How to export mysql databases with different ENGINE?
deleted 1 character in body
Sep
25
answered want to find out which databases are used in last 30 days or not
Sep
25
comment Threads_cached 0 while thread_cache_size > 0
Please try this select G.variable_name,G.variable_value GlobalValue,S.variable_value SessionValue from (select * from information_schema.global_status) G inner join (select * from information_schema.session_status) S using (variable_name) where G.variable_name like 'Threads%'; to see if you note any difference.