myisam
Will deadlocks affect me, even if I don't use transactions?
We want to switch from MyISAM to InnoDB for several reasons, but we do not intend to use transactions with BEGIN/COMMIT etc.[详细]
2023-04-11 18:49 分类：问答Prevent deletion for specific id
For ex I have a table1 with id and name field. I use bind开发者_开发百科ingsource to bind data to datagridview. Now I expect that user can not delete row which table1.id = 1 or table1.id = 2.[详细]
2023-04-09 20:35 分类：问答MySQL & FK constraints
Is there any point in defining FK constraints in MyISAM? MyISAM doesn\'t enforce referential inte开发者_如何转开发grity, right? So maybe there is no point to FK constraints. Although MySQL parses and[详细]
2023-04-08 10:41 分类：问答Slow insertion speed on MYISAM table
I need to create a table containing two attributes: id and author. These two attributes form the composite key. Moreover I need to perform an index search on the author field.[详细]
2023-04-07 04:31 分类：问答Should I use MyISAM or InnoDB Tables for my MySQL Database?
I have the following two tables in my database (the indexing is not complete as it will be based on which engine I use):[详细]
2023-04-06 01:58 分类：问答Re-synchronize MySQL auto-increment field
I have a table which has an auto-increment column and I made a mistake last night and accidentally inserted a few bad rows, so I deleted them.[详细]
2023-04-05 07:10 分类：问答What should i do with partitioning in a table require 2 ways of selections for best performance in MYSQL - myisam?
I have a table like bellow: CREATE TABLE `hosts` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(60) NOT NULL,[详细]
2023-04-03 07:57 分类：问答Migrating from MyISAM to InnoDB
I\'ve searched a bit on this topic and found a few results. However, I\'m looking for if anyone knows about or could point m开发者_如何学Ce to to some authentic or reputable case studies that detail t[详细]
2023-04-03 00:35 分类：问答Does MyISAM load all indexes into memory?
First of all you should already 开发者_Go百科know MyISAM index doesn\'t include the actually data, it only has the address of data.[详细]
2023-04-01 19:05 分类：问答Optimising sql query performing internal comparison
I have the following query which is a little expensive (currently 500ms): SELECT * FROM events AS e, event_dates AS ed[详细]
2023-04-01 14:15 分类：问答
加载中,请稍侯......