MySQL Server
--
Questions
--
Followers
Top Experts
Reindexing MySQL database
I'm not sure if I need to reindex MySQL, but it seems to be corrupted and is acting strange.
I saw this on another answer posted, but I don't know what to do after I do a
mysql -u username -p and I don't know the name of the database or the name of the table (tablename)?
ANALYZE TABLE tablename;
That will help mysql make better choices about index usage.
OPTIMIZE TABLE tablename;
Use to defragment a table that had a large delete.
REPAIR TABLE tablename;
Fixes corrupted tables/index.
Thanks,
HatGuy
I saw this on another answer posted, but I don't know what to do after I do a
mysql -u username -p and I don't know the name of the database or the name of the table (tablename)?
ANALYZE TABLE tablename;
That will help mysql make better choices about index usage.
OPTIMIZE TABLE tablename;
Use to defragment a table that had a large delete.
REPAIR TABLE tablename;
Fixes corrupted tables/index.
Thanks,
HatGuy
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
>>I don't know the name of the database or the name of the table (tablename)
???
You think it's acting strange, but don't know what database/table??
Can you please explain more, I think you are probably like the server admin, and are told to troubleshoot the server/database but have no idea of mysql?!
???
You think it's acting strange, but don't know what database/table??
Can you please explain more, I think you are probably like the server admin, and are told to troubleshoot the server/database but have no idea of mysql?!
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
When doing: mysqlcheck -c --all-databases this is what I'm getting.
fum.admin_note OK
fum.admin_session OK
fum.attachment OK
fum.blacklist OK
fum.blocked_domain OK
fum.campaign OK
fum.campaign_stat OK
fum.campaign_stat_daily OK
fum.clickthrough OK
fum.client OK
fum.client_page_template OK
fum.client_session OK
fum.contact OK
fum.contact_temp_id OK
fum.contact_vr_auth OK
fum.delivery_log OK
fum.import_job OK
fum.import_stat OK
fum.mailq_bcast OK
fum.mailq_followup OK
fum.mailq_message_test OK
fum.mailq_verify OK
fum.message OK
fum.mimetype OK
fum.perf OK
fum.registered_clickthroug
fum.sender_conf OK
fum.smtp_src OK
fum.ttag OK
fumremoved.attachment OK
fumremoved.campaign OK
fumremoved.campaign_stat OK
fumremoved.clickthrough OK
fumremoved.contact OK
fumremoved.message OK
fumremoved.ttag OK
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.host OK
mysql.tables_priv OK
mysql.user
warning : 1 client is using or hasn't closed the table properly
status : OK
test.testac
warning : 1 client is using or hasn't closed the table properly
status : OK
fum.admin_note OK
fum.admin_session OK
fum.attachment OK
fum.blacklist OK
fum.blocked_domain OK
fum.campaign OK
fum.campaign_stat OK
fum.campaign_stat_daily OK
fum.clickthrough OK
fum.client OK
fum.client_page_template OK
fum.client_session OK
fum.contact OK
fum.contact_temp_id OK
fum.contact_vr_auth OK
fum.delivery_log OK
fum.import_job OK
fum.import_stat OK
fum.mailq_bcast OK
fum.mailq_followup OK
fum.mailq_message_test OK
fum.mailq_verify OK
fum.message OK
fum.mimetype OK
fum.perf OK
fum.registered_clickthroug
fum.sender_conf OK
fum.smtp_src OK
fum.ttag OK
fumremoved.attachment OK
fumremoved.campaign OK
fumremoved.campaign_stat OK
fumremoved.clickthrough OK
fumremoved.contact OK
fumremoved.message OK
fumremoved.ttag OK
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.host OK
mysql.tables_priv OK
mysql.user
warning : 1 client is using or hasn't closed the table properly
status : OK
test.testac
warning : 1 client is using or hasn't closed the table properly
status : OK
When I say things are acting strange, keep in mind I don't know much at all about MySQL. When running an operation in software that utilizes MySQL on my server today, it's bringing up aspects of an operation that was ran about a month ago. For a lack of a better word it appears scrambled.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
MySQL Server
--
Questions
--
Followers
Top Experts
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.