in \"High Performance MySQL\" from o\'Reilly I\'ve read, that MyISAM could be a good alternativ开发者_开发知识库e to InnoDB for logging situations.
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?
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)
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
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
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
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
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
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.
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
加载中,请稍侯......