storage-engines
MyISAM or InnoDB for a mostly-write table
I\'ve got a table that receives around 50 inserts per second. Right now there are 700k records, using 160 MiB. My little VPS with 1 gig of ram is keeping up, but just barely.[详细]
2023-03-15 11:23 分类:问答How to check if MySQL table is UTF-8 and has storageEngine InnoDB?
Googling around just finds instructions for changing from one format to another, but I can\'t seem to find how exactly to make sure which of开发者_StackOverflow社区 these I have first.[详细]
2023-03-08 07:51 分类:问答Fast at selects/joining MySQL storage engines?
I have some very large databases (some up to 150M rows) I\'m working with & after initially inserting the data there isn\'t much INSERT\'s going on; just a lot of SELECT\'s & usage of JOINS.[详细]
2023-03-07 18:01 分类:问答Guideline on how to set InfiniDB options?
I\'ve been trying to find out how to best set these settings, but haven\'t been able to find much info on them. Some of them I\'ve seen before with regular MySQL installations, but some others I haven[详细]
2023-03-07 12:07 分类:问答Having troubles loading data in InfoBright ICE
ICE Version: infobright-3.5.2-p1-win_32 I’m trying to load a large file but keep running into problems with errors such as:[详细]
2023-02-24 08:13 分类:问答pitfalls with mixing storage engines in mysql with django?
I\'m running a django system over mysql in amazon\'s cloud, and the database default is innodb. But now I want to put a fulltext index on a couple of tables for searching, which evidently requires myi[详细]
2023-02-16 20:43 分类:问答Memory-Mapped Storage Engine
From MongoDb\'s site, the current only support storage engine is Memory-Mapped Storage Engine. I am wondering how it supports atomicity in the presence of system crash(i.e power failure)? Does it depe[详细]
2023-02-10 14:23 分类:问答Fastest MySQL storage engine for storing data without concurrency
I\'m using a mysql base to store results from various test over a large amount of data (hundred of millions reco开发者_如何转开发rdings).[详细]
2023-01-26 21:08 分类:问答Django set Storage Engine & Default Charset
Creating my tables from my models.py. I donno how to do 2 things - I want to specify MySQL to create some of my tables as InnoDB & some as MyISAM. How do I do it?[详细]
2023-01-24 17:57 分类:问答MySql, InnoDB & Null Values
Formerly I was using MyISAM storage engine for MySql and I had defined the combination of three fields to be unique.[详细]
2023-01-02 16:21 分类:问答