myisam
Importing ISAM table files (ISD, ISM) from one mysql to another
Problem: My db-host suddently switched my mysql db from one server to another. Unfortunately I has 1 table that was running ISAM, all other tables are MyISAM.[详细]
2023-01-24 13:24 分类:问答best mysql table type for a lookup table (heavy read, no write)
i have an ip-to-country lookup table. this table is updated max once a month while开发者_如何学C read to very frequently. i currently have it as innodb. is this the best table type for a table that is[详细]
2023-01-23 07:30 分类:问答MySQL InnoDB Text Search Options
Knowing full well that my InnoDB tables don\'t support FULLTEXT searches, I\'m wondering what my alternatives are for searching text in tables ? Is the performance that bad when using LIKE ?[详细]
2023-01-22 17:04 分类:问答MyIsam vs NDB On Inserts
I\'m considering ways to increase performance of our persistence layer. We want to achieve as many inserts per second as we can and we don\'t need any transactions at the moment. What I want to know i[详细]
2023-01-22 05:00 分类:问答InnoDB or MyISAM?
I have two tables: Users and Friendships. The actions I have in the website are: Register Log in Select friends/people from users table[详细]
2023-01-22 04:24 分类:问答Should I use InnoDB or MyISAM for a "write-only" table?
I have a table where I\'m esentially only writing. Think of it as a \"transactions\" list, where开发者_如何学Go I keep all the details, and I also have a \"total\" stored in another table. That tota[详细]
2023-01-19 10:45 分类:问答How to lock a single row
I have a user table with field lastusedecnumber. I need to access and increment lastusedecnumber. During that accessing开发者_运维问答 time I need to lock that particular user row (not the entire ta[详细]
2023-01-19 04:53 分类:问答Should a forum posts table use MyISAM or InnoDB
For a forum, should I use MyISAM or InnoDB for the table that stores th开发者_JAVA百科e text? I know that MyISAM supports full text searching, which sounds like it\'s what I should go for, but while[详细]
2023-01-18 18:10 分类:问答How can I recover MySQL tables from data files?
I\'ve got a database (all MyISAM tables) and the machine where MySQL was running is no longer bootable. However, we have all the MySQL data files from the data directory. How can I restore the data fr[详细]
2023-01-17 11:52 分类:问答MySQL - how to backup database to a different server?
I have 2 databases with MyISAM tables which are updated once a week. They are quite big in size (one DB is 2GB and the other is 6GB). I currently back them up once a week with mysqldump and keep the l[详细]
2023-01-15 14:59 分类:问答