myisam
Why does table-create fail when everything's innodb, but not when one table is MyIsam?
I find innodb quite annoying when I try to design a db structure, at least compared with MyIsam, which seems to have less limitations[详细]
2023-03-16 06:12 分类：问答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 分类：问答Full text searching in innodb using a myisam slave/ghost table
I need to do full text indexing for two different colums in two different tables. The only problem is that I\'m using innodb and there is no way for me to do full text indexing.[详细]
2023-03-15 00:42 分类：问答MySQL Autoincrement InnoDB like MyISAM
MyISAM allows very convenient way to create serials. E.g. In the table primary key is id+seq(-uence) id seq[详细]
2023-03-13 13:01 分类：问答Move MySQL tables and data from storage engine MyISAM to InnoDB
This question is probably for MySQL experts and admins that have done this sort of migration before. I have 17 MySQL tables, triggers and stored procedures on MyISAM storage engine. These tables have[详细]
2023-03-10 12:46 分类：问答MyISAM alternative that is not InnoDB?
I have issues with using the MyISAM engine in my database. It is constantly corrupting and has severely varying query times. Thus I can not use it any more. I have found the InnoDB to be a good altern[详细]
2023-03-10 11:22 分类：问答UPDATE LOW_PRIORITY does it return the correct number of affected_rows?
I need to make a lot of UPDATE and I don\'t need to read the table often. So I thought of using UPDATE LOW_PRIORITY but does it return the correct number of affected_rows() ?[详细]
2023-03-10 09:34 分类：问答MyISAM vs. InnoDB vs. others...?
On a very limited environment (slow CPU, little RAM, but a lot of disk space), what would be the advantages of using different storage engine than MyISAM assuming an optim开发者_如何学Cized php script[详细]
2023-03-10 06:24 分类：问答MySQL optimization tips specific to a completely static database?
I have a database that is about 20 GB in size. I want to know if there are any optimization tips specific to working with a database that is static.When I mean static, I don\'t mean changes infrequent[详细]
2023-03-09 23:22 分类：问答MySQL InnoDB query performance
I\'m trying to optimize a simple sql query that will be run over a ton of data lot of times. This is the scenario:[详细]
2023-03-09 18:00 分类：问答
加载中,请稍侯......