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.
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
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 ?
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
I have two tables: Users and Friendships. The actions I have in the website are: Register Log in Select friends/people from users 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
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
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
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
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
加载中,请稍侯......