Linked Questions

Ask Question
72 questions linked to/from What are the main differences between InnoDB and MyISAM?
Hot Newest Score Active Unanswered
-1 votes
1 answer
856 views

Does it really matter if the default storage engine is InnoDB? My default storage engine is MyISAM
EGB's user avatar
  • 1
64 votes
4 answers
142k views

How can MyISAM be "faster" than InnoDB if MyISAM needs to do disk reads for the data? InnoDB uses the buffer pool for indexes and data, and MyISAM just for the index?
jcho360's user avatar
  • 2,019
34 votes
3 answers
32k views

This is a purely theoretical question. Let's say I have an application deployed on multiple servers. A load balancer, Multiple/scalable applications servers A (single) database server (for the ...
Zenklys's user avatar
  • 451
38 votes
5 answers
59k views

I have quite an annoying problem. I want to use INNODB as my main database engine and give up on MyISAM as I need the former for using galera-cluster for redundancy. I copied (description follows) ...
jollyroger's user avatar
  • 563
10 votes
2 answers
71k views

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 ...
32bitfloat's user avatar
  • 647
13 votes
3 answers
42k views

I am having problems with a website with 600MB of MySQL database. The website is way too slow. I noticed the bigger the MySQL database gets, the slower it goes. When it was 5MB, the website was very ...
grant tailor's user avatar
  • 379
4 votes
2 answers
38k views

I have a database whose entire size is ~44GB, out of which ibdata1 is ~35GB. That doesnt make sense, since the size of the data shouldn't be more than 10GB. I use the following query to get an ...
Ran's user avatar
  • 1,573
7 votes
4 answers
8k views

What are the benefits of table level locking which is used by the MyISAM storage engine? Row level locking has lots of benefits like concurrent updates and reads that do not lock the table. Edit Its ...
Rick James's user avatar
  • 1,271
8 votes
2 answers
39k views

Our company servers are currently hosted on a VPS and we've decided to move into dedicated servers. When choosing the best hardware for a DB server, what should we invest more resources: better CPU (...
Ran's user avatar
  • 1,573
6 votes
2 answers
10k views

I have created a database on MySQL 5.0.15. I have a query and when I run this query on this MySQL version, I get 0.9 s run time. When I import this database to another MySQL server with same hardware ...
user3731's user avatar
  • 205
4 votes
4 answers
16k views

Currently my main culprit of poor performance is MySQL and I'm not DB savvy. So far, I've had little luck in optimizing MySQL configs on my server, which has a Sandy Bridge processor with 16GB RAM and ...
alfish's user avatar
  • 3,024
5 votes
2 answers
17k views

I have two databases one of size 170 MB and second one is of 15 MB, both having INNODB tables and innodb_buffer_pool_size is set to 8 MB. My queries are responding well now i.e under mili seconds. ...
JP Chauhan's user avatar
  • 1,361
10 votes
2 answers
16k views

i'm running a facebook app which currently has 300 - 600 concurrent users (and growing). To get the hardware ready for growing i changed my i7 / 12gb ram / 2x 80gb intel x25 ssd's (debian 5.0 / mysql ...
Kilian's user avatar
  • 201
4 votes
1 answer
25k views

I need to performance tune a mysql server and need help. I have a 16G server dedicated to MySQL with 1 MyISAM table with about 2 million rows that gets a significant amount of traffic. There are ...
rho's user avatar
  • 41
8 votes
3 answers
5k views

I am creating a module where every user often gets a record into a table for 10 to 300 seconds. When the time expires a record gets deleted. The case is: there will be a lot of users and records will ...
Aivaras's user avatar
  • 183

15 30 50 per page
1
2 3 4 5