65,423 reputation
1066152
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 7 months
seen 2 hours 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


2d
comment Threads_cached 0 while thread_cache_size > 0
Glad I could help. I just wanted earn by upvote and acceptance :-)
Sep
26
comment SQL: Repair With Keycache
Please run SHOW GLOBAL VARIABLES LIKE 'tmpdir';
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
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
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.
Sep
25
comment Threads_cached 0 while thread_cache_size > 0
You keep using show status where variable_name like 'Threads%';. That's the same as running show session status where variable_name like 'Threads%';.Try show global status where variable_name like 'Threads%';
Sep
25
comment Speed Up Index Creation in MySQL
@BillKarwin ... and your feet tied also with a hood over your head :-)
Sep
25
comment Threads_cached 0 while thread_cache_size > 0
Remember, Normally, this does not provide a notable performance improvement if you have a good thread implementation.
Sep
25
comment MySQL: Adding innodb_log_file_size in my.cnf causes not starting MySQL service
If you had MySQL 5.6, the log files would get resized for you. Before 5.6, you have to do it manually.
Sep
24
comment MySQL permission denied for database
Did you actually run any SELECTs, INSERTs, UPDATEs, or DELETEs after you ran use abc ? Note that you ran SELECT CONCAT(QUOTE(user),'@',QUOTE(host)) from mysql.user WHERE user='root'; and it did not work. It should work now. When your grant was GRANT ALL PRIVILEGES ON mydb.* TO 'root'@'%' WITH GRANT OPTION;, you were not restricted from running use abc. Once inside, you were restricted from running SELECTs, INSERTs, UPDATEs, or DELETEs.
Sep
24
comment MySQL permission denied for database
Please run SHOW GRANTS FOR root@'%'; and SELECT CONCAT(QUOTE(user),'@',QUOTE(host)) from mysql.user WHERE user='root'; and post them as well. (Please hide the encrypted password).
Sep
24
comment MySQL permission denied for database
Please run mysql -h x.x.x.x -uroot. When you get in, run SELECT USER(),CURRENT_USER(); and post that output.
Sep
24
comment What are good practices if I want to learn DBA?
possible duplicate of What are the concepts that need to be gone through for MySQL DBA?
Sep
23
comment Innodb issue is preventing MySQL from starting
Please post the contents of your my.cnf
Sep
23
comment mysql.proc keeps crashing, cannot do a mysqldump?
Although the accepted answer already says to do this, you actually showed how. +1 !!!