Linked Questions
10 questions linked to/from Any gotchas at all with converting from MyISAM to InnoDB?
282
votes
10
answers
284k
views
What are the main differences between InnoDB and MyISAM?
What are the main differences between InnoDB and MyISAM?
- 3,049
10
votes
2
answers
70k
views
way to prevent queries from waiting for table level lock
We've encountered a problem after moving the database of our customer to an extra server. This should have had positive effects on the site's performance, but there is a problem with table locking in ...
- 637
16
votes
3
answers
11k
views
From where does the MySQL Query Optimizer read index statistics?
I'm trying to determine from where the MySQL optimizer obtains the list of indexes that are available for a table when it estimates the cost of (prepares) a query from.
- 533
7
votes
1
answer
8k
views
When to switch from MyISAM to InnoDB?
We have a MySQL 5.0 server running all tables as MyISAM. We have two slaves that, in the last month, we have upgraded to MySQL 5.5. Their tables are also still MyISAM.
My original plan was to upgrade ...
- 642
6
votes
2
answers
3k
views
How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?
I have a database that, because of some issues, I needed to convert some tables from MyISAM to InnoDB.
I basically did this:
set sql_log_bin = 0;
set sql_mode = 'STRICT_ALL_TABLES';
ALTER TABLE `...
- 61
3
votes
2
answers
4k
views
How can I optimize this mySQL table that will need to hold 5+ million rows?
The table has about 12 rows.
Indexes:
idint(11), Unique, auto-increment, primary
ATTACHMENTIDvarchar(14), Unique
MLSNUMBERbigint(20)
POSITIONint(10)
FILETYPEvarchar(32)
I'm doing an extended ...
- 175
3
votes
1
answer
8k
views
MySQL high CPU usage (MyISAM table indexes)
I have a problem with an inherited MySQL database.
From time to time mysqld uses up to 2300% CPU..
The only solution is to service mysql stop and run an myisamchk -r on a table.
After the indexes have ...
- 55
1
vote
2
answers
9k
views
Cache all mysql table
Maybe it sound's like i'm an idiot... But i'm developing app with huge db on RoR. Also i see that if i do some query and after that do it one more it is doing much faster, becouse it has been cached......
- 111
7
votes
2
answers
3k
views
Why does MyISAM support FULLTEXT Searching and InnoDB does not?
I know the basic differences between the MyISAM and InnoDB engines. In MySQL 5.6 beta, InnoDB will support fulltext search. But, I wonder why previous versions of InnobDB didn't support FTS? My guess ...
- 256
4
votes
1
answer
3k
views
Can I partially invalidate the MySQL table cache?
I want to set a fairly large table to MyISAM mode to keep it cached proactively. The table file is approximately 3GB.
After several hours, MySQL invalidates the entire table from cache, while < ...
- 41