myisam
MyISAM for logging and export?
in \"High Performance MySQL\" from o\'Reilly I\'ve read, that MyISAM could be a good alternativ开发者_开发知识库e to InnoDB for logging situations.[详细]
2023-02-03 13:34 分类：问答InnoDB or MyISAM - Why not both?
I\'ve read v开发者_JAVA百科arious threads about which is better between InnoDB and MyISAM. It seems that the debates are to use or the other. Is it not possible to use both, depending on the table?[详细]
2023-02-01 20:38 分类：问答mysql tables and deleting strategies
I\'m working on a social network, like a subset of Facebook. I think this means that the application will be more read-heavy than write-heavy (i.e. more SELECTS than INSERTS, UPDATES, OR DELETES)[详细]
2023-01-31 01:50 分类：问答MyISAM key length limitation, trying to speed things up with md5 of fields
I work on small MyISAM table - around开发者_JS百科 30k entries, size - 10mb. One of the fields is varchar(500+), because I use utf8_unicode_ci I can\'t index this field(I hit 1000 bytes limit) and at[详细]
2023-01-30 18:59 分类：问答Do InnoDB vs MyISAM comparisons still hold true in terms of speed of reads vs writes? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a[详细]
2023-01-30 17:08 分类：问答Two tables, with indexes, with the same column names, containing different info... will there be a conflict?
So I have a class that creates a table to be populated with data. Right now I have all the column names the same (product_name, date, etc). I noticed that when I view my tables in Webmin that there is[详细]
2023-01-29 05:08 分类：问答MySQL: How to keep entire myisam table in memory?
I have a lot of RAM (1 gb) on my server, and I have a table (100 mb) that I would like to increase the speed of. Is it possible to keep the entire table in memory (while开发者_StackOverflow中文版 keep[详细]
2023-01-28 12:05 分类：问答MyISAM Selects locks inserts inside procedure only
We have a large MyISAM table to which rows get inserted to the bottom of the table only. While doing some benchmarks, i realized that selects do not (always) lock other inserts to that same table. Ho[详细]
2023-01-28 06:16 分类：问答MySQL MyISAM relationship diagram
We\'re using this pretty large MySQL database with a bunch of tables. The most important table is a \"plants\" table, which contains about 1 million records.[详细]
2023-01-26 21:45 分类：问答prevent mysql MyISAM table crashes
I\'ve been having problems with a database repeatedly having crashed tables. Luckily it\'s easy enough to fix by repairing the crashed table, but it\'s hardly good practice to have to watch for the ta[详细]
2023-01-24 23:03 分类：问答
加载中,请稍侯......