innodb
MySQL全文索引在数据库中的应用和优势（模糊查询不用like+%）
目录前言创建全文索引使用全文索引Natural LanguageBooleanQuery Expansion删除全文索引总结前言[详细]
2024-09-08 09:00 分类：数据库Storing serialized objects in MySQL and performance
We want to store a serialized object in a table along with a unique internal ID. We\'d only ever want to read/write/(rarely)u开发者_开发问答pdate the rows.[详细]
2023-04-12 18:05 分类：问答MySql InnoDb auto-increment pre-fetching values
How do I get future keys from a Mysql InnoDb? Oracle and Postgres both have the concept of sequences and a nextval-function. Mysql seems to be a bit different.[详细]
2023-04-12 17:19 分类：问答Will deadlocks affect me, even if I don't use transactions?
We want to switch from MyISAM to InnoDB for several reasons, but we do not intend to use transactions with BEGIN/COMMIT etc.[详细]
2023-04-11 18:49 分类：问答Mysql InnoDB Error code #1025
We are using Mysql 5.1 in our production servers and trying to run an alter query to change the datatype of a column from tinytext to varchar(200). On running the alter query we are seeing this error[详细]
2023-04-09 13:37 分类：问答MySQL foreign keys with non-identifying relationships
All I need is to create 2 tabeles with next structure: The SQL: CREATE TABLE IF NOT EXISTS `ds_cats` ( `id` int(11) NOT NULL AUTO_INCREMENT,[详细]
2023-04-09 06:38 分类：问答How can I speed-up the table reconstruction in MySQL when altering the schema?
I have a relatively big MySQL InnoDB table (compressed), and I sometimes need to alter its schema (increasing column size or adding a field).[详细]
2023-04-08 15:51 分类：问答What MySQL my.ini parameters should I change for a large table join and update?
I have the following: TableA - 20M rows TableB - 500K rows And many queries, in particular the following, take forever.[详细]
2023-04-08 09:44 分类：问答ERROR 1005 (HY000): Can't create table '......\issue.frm' (errno: 150)
This is the SQL: CREATE TABLE user ( userID INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, username VARCHAR(100) NOT NULL,[详细]
2023-04-08 07:38 分类：问答Recover unconnected tables from ibdata1
I\'m encountering data loss of mysql, below is the steps: 1.I converted Table_A from MyISAM to InnoDB (with innodb_file_per_table OFF), saw the ibdata1 size increased;[详细]
2023-04-08 06:08 分类：问答
加载中,请稍侯......