innodb
SELECT FOR UPDATE [duplicate]
This question already has answe开发者_运维百科rs here: Closed 11 years ago. Possible Duplicate: SELECT … FOR UPDATE and MAX()[详细]
2023-03-17 20:13 分类:问答InnoDB Optimization Tips Needed - mysql
I recently got a new dedicated MySQL machine. Now it\'s running fine, but sometimes it gets slowed down a lot by queries that state: Copying to tmp table. It seems to happen randomly.[详细]
2023-03-16 23:07 分类:问答When exactly MySQL locks a row on updating InnoDB table?
If I have this multiupdate query UPDATE user u INNER JOIN user_profile up ON up.user_id = u.id SET u.name = \'same_name_i_already_had\', up.profile.age = 25[详细]
2023-03-16 12:18 分类:问答Search page engine PHP with MYSQL database?
I\'m going to generalize this question so that other people can use the answers. Let\'s 开发者_如何学JAVAsay I have a website driven by a MYSQL database.[详细]
2023-03-16 11:54 分类:问答Why does table-create fail when everything's innodb, but not when one table is MyIsam?
I find innodb quite annoying when I try to design a db structure, at least compared with MyIsam, which seems to have less limitations[详细]
2023-03-16 06:12 分类:问答MySQL : add constraint gives:ERROR 1452 (23000): Cannot add or update a child row?
i have the following: mysql> show create table rc_profile_table \\G; *************************** 1. row ***************************[详细]
2023-03-16 03:14 分类:问答MySQL/InnoDB Plugin: Will NULL values for VARCHAR fields still take up storage spaces?
I\'m using InnoDB Plugin in the Barracuda file format with: ROW_FORMAT=DYNAMIC If I define a field as VARCHAR(255), and then insert a record that has a NULL value for that field, will that record st[详细]
2023-03-15 21:50 分类:问答How can I check for referential integrity in a given row after the row has been added?
I\'m trying to see if开发者_运维技巧 there is a way to check the referential integrity of a single row after it has been inserted into an InnoDB table while foreign_key_checks is set to 0.[详细]
2023-03-15 17:32 分类:问答MyISAM or InnoDB for a mostly-write table
I\'ve got a table that receives around 50 inserts per second. Right now there are 700k records, using 160 MiB. My little VPS with 1 gig of ram is keeping up, but just barely.[详细]
2023-03-15 11:23 分类:问答Full text searching in innodb using a myisam slave/ghost table
I need to do full text indexing for two different colums in two different tables. The only problem is that I\'m using innodb and there is no way for me to do full text indexing.[详细]
2023-03-15 00:42 分类:问答