0
votes
0answers
39 views

which books can make me DBA expert [duplicate]

I'm trying to find great books to read, so, I will have expert knowledge to become #1 MySQL DBA. Please provide me list of great books or video training or YouTube channels.
0
votes
1answer
160 views

I need advice on these queries

could you help me optimize these queries? here are queries, please note that you see something like OR 1=1 OR those are values I pass via php and may change. query#1: SELECT posts.status, ...
1
vote
1answer
551 views

InnoDB, What would cause: “db1/tableABC contains 6 indexes inside InnoDB, which is different from the number of indexes 5 defined in MySQL”

MySQL 5.5.24 . We have InnoDB tables that grew almost by double (from 50GB to 100GB - file-per-table enabled) in a few weeks due to a project we are working on. The tables were freshly dumped and ...