innodb
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 分类：问答concurrency in innodb
i have a code like this reserve.php $r=mysql_query(\"select count(*) from ticket\"); $rec=mysql_fetch_array($r);[详细]
2023-03-14 16:32 分类：问答Renaming an InnoDB table without updating foreign key references to it?
I am trying to replace an InnoDB table with a new table, and I want all foreign key references that point to the old table to point to the new table.[详细]
2023-03-13 20:32 分类：问答MySQL Autoincrement InnoDB like MyISAM
MyISAM allows very convenient way to create serials. E.g. In the table primary key is id+seq(-uence) id seq[详细]
2023-03-13 13:01 分类：问答Nulls in InnoDBs clustered index?
Using InnoDB in MySQL, I want to speed up selects by utilizing the clustered index better, thus including more frequently used columns in the primary key.[详细]
2023-03-13 11:51 分类：问答Has anyone tried the new MySQL 5.5 InnoDB for performance?
I would like to know if anyone has personally benchmarked the new InnoDB with large data sets. I don\'t use the latest version but I have implemented ISAM tables with over 20 million records. It\'s w[详细]
2023-03-12 08:23 分类：问答MySQL InnoDB count(*) vs counting rows on server side
I have a MySQL InnoDB table. I need to count the number of rows in the table, but I have read in many performance tuning books that count() does not execute very quickly. Would it be faster to count t[详细]
2023-03-11 22:36 分类：问答Row versioning in MySQL
I would like to include an integer version field in my table, auto-incrementing on each update made to a row. Is it possible to do this in MySQL?[详细]
2023-03-11 06:45 分类：问答
加载中,请稍侯......