Linked Questions

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

In one application, we have an audit table that uses the ArchiveEngine in conjunction with a few triggers to capture 100% of the changes that occur. The upside to this is that 20+ million rows ...
Bryan Agee's user avatar
  • 801
1 vote
1 answer
589 views

I have a write-intensive web app, and I bought a VDS with 768M RAM Is this my.cnf good for my purposes? I specified bulk_insert_buffer_size to 126M and some other parameters as below: [mysqld] ...
Alireza's user avatar
  • 3,696
1 vote
2 answers
3k views

So I'm testing on our dev server to change MyISAM to InnoDB and am having a huge performance loss. Here is my.cnf: innodb_file_per_table=1 innodb_flush_method=O_DIRECT innodb_buffer_pool_instance=2 ...
Marc Alexander's user avatar
  • 147
1 vote
1 answer
1k views

We use INNODB for all of our tables, but I have one special table, a 100+ GB reference table (only read-queries against it). We are loading changes to this table in a nightly batch job using LOAD ...
David Parks's user avatar
  • 551
1 vote
1 answer
752 views

I want to test two different disks, one of them is HDD and another is SSD. I use exactly the same information and app for both servers. They are exactly the same, just one of them is SSD and another ...
Ata's user avatar
  • 141
2 votes
1 answer
1k views

I want to convert my MySQL DB (46 Tables, 2.1 GB) from MyISAM to InnoDB. I have a couple of questions about this process. Since I have a Master/Slave structure, do I need to manage this and change the ...
jjadams's user avatar
  • 21
3 votes
1 answer
1k views

I have a replicated database setup, mostly Innodb databases/tables. The query that I believe caused the issue ran in about 20 minutes on the master database. This is where it gets weird. Show ...
Paul's user avatar
  • 31
0 votes
1 answer
1k views

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being ...
Dan's user avatar
  • 1
5 votes
2 answers
171 views

I developed an application with MySQL 5.1 back-end four years ago. After that, I only gave remote support a couple of times, but that too for application crashes, and not for database. The database is ...
RPK's user avatar
  • 1,425
1 vote
2 answers
834 views

Windows Server 2008 R2 x64 MySQL Server 5.6.14 x64 Is anyone else having an issue in where some tables are marked as crashed on a Microsoft Windows server? We have a couple of Windows servers (not by ...
Van's user avatar
  • 328
0 votes
1 answer
729 views

I am running on MariaDB 10.0.15 on a 4GB RAM cloud server with Local SSD disk for database. My model: users <n---n> right_holders <n---n> tracks ---n> raw_detections I have this table ...
Daniel Cukier's user avatar
  • 165
1 vote
1 answer
895 views

I have just made a check for my server with mysqltuner. -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB +Federated +InnoDB -ISAM -NDBCluster ...
Toi Lee's user avatar
  • 55
4 votes
1 answer
271 views

I have to work on a project which would have a extra large table with billions of records but only two fields one is id and another is text. And id would be set to BIGINT and PK then if 8+2 (extra 2 ...
Gary Lindahl 's user avatar
  • 443
2 votes
2 answers
397 views

As Innodb is my default engine, all my tables are innodb. But while monitoring with the help of a tool, I found a constant spike in key_write_requests and key_read_requests. These two variables are ...
Aravind's user avatar
  • 45
1 vote
1 answer
642 views

I am running MySQL 5.5.37. I have a cronjob set to run every 6 hours to flush the query cache. I realized that if I don't do that, then the cache becomes fragmented and average query response time ...
brant's user avatar
  • 113

15 30 50 per page
1 2 3
4
5