myisam
Write on InnoDB read from MyIsam
I\'m working on a project that requires lots of database inserts. I also need to be able to use something like full-text-search to retrieve the data.[详细]
2023-01-14 23:48 分类：问答MySQL Analyze and Optimize - Are they required if only inserts - and the table has no joins?
I have a MyISAM table in MySQL which consists of two fields (f1 integer unsigned, f2 integer unsigned) and contains 320 million rows. I have an index on f2. Every week I insert about 150,000 rows into[详细]
2023-01-14 06:49 分类：问答Why MySQL Full text index doesn't work?
After trying everything I could, I finally created this test table: CREATE TABLE test_table ( id int(11) NOT NULL AUTO_INCREMENT,[详细]
2023-01-14 03:52 分类：问答Make a query in mysql without invoking a trigger (How to disable a trigger)
I have 2 tables: comments and comments_likes. comments id message likes triggers: AFTER DELETE DELETE FROM comments_likes WHERE comment_id = OLD.id;[详细]
2023-01-13 12:23 分类：问答Index for a VARCHAR field with a 384 length in a MySQL database
I have a varchar(384) to store emails in a MyISAM table and I want check when the email exists 开发者_Python百科but the index length limit is 333 bytes (because I\'m using utf8 (1000 bytes/3 bytes)).[详细]
2023-01-12 23:10 分类：问答Which database for a web crawler, and how do I use MySQL in a distributed environment?
Which database engine should I use for a web crawler, InnoDB or MYiSAM? I have two PC\'s, each with 1TB hard drives. If one fills up, I\'开发者_StackOverflow社区d like for it to save to the other PC a[详细]
2023-01-12 11:36 分类：问答Best Table Engine for massively updated MySQL table. MyISAM or HEAP?
I am creating an application which will store a (semi) real-time feed of a few different scales around a certain 开发者_开发技巧location.The weights of each scale will be put in a table with only as m[详细]
2023-01-12 08:43 分类：问答Using a different MySQL database engine
I am having problems trying to use a different MySQL database engine.(I want to change from MyISAM to InnoDB)[详细]
2023-01-12 06:29 分类：问答Using Entity Framework with MyIsam tables
Got a question about Entity Framework and MyIsam tables. My production database consists of MyIsam tables only. Often with a primary key li开发者_StackOverflowke UserId and then a secondary KeyId tha[详细]
2023-01-08 05:51 分类：问答How to use Oracle without transactions?
MySQL has special table type MyISAM that does not support transactions. Does Oracle has something like this? I\'d like to create write-only database(for logging) that needs 开发者_如何学Pythonto be ve[详细]
2023-01-07 06:33 分类：问答
加载中,请稍侯......