innodb
MySQL InnoDB: Index Locks - Advice Needed
I have an application that is sending function calls to my mySQL database. Once sent, the function does what it needs (which includes single line selects, INSERT and UPDATE by index).[详细]
2023-03-21 08:29 分类：问答Duplicate entry '6343' for key 'PRIMARY'
I\'ve begun receiving the above error when trying to add a record to a database. The column in question is set to \'auto_increment\' and is of datatype \'INT\' with a length of 10.[详细]
2023-03-21 04:39 分类：问答Redundant MySQL Index?
ActionKeyname TypeUniquePackedColumnCardinality CollationNullComment EditDropPRIMARY BTREEYes NoTickerID23200A[详细]
2023-03-20 13:05 分类：问答mysql deadlocks started after upgrade from 5.0 to 5.1
Old server: We w开发者_JAVA百科ere using mysql 5.0.77 for more than a year- centos New server: We have upgraded our server and came with mysql 5.1.49 - ubuntu recently.[详细]
2023-03-20 12:30 分类：问答mysqldump vs innodb hot-backup
I need to perform a backup of entire innodb-database into local file with possibility to restore data from it. Currently I use MySQL Community Edition, but it doesn’t have innodb hot-backup features.[详细]
2023-03-20 09:49 分类：问答InnoDB SELECT ... FOR UPDATE statement locking all rows in a table
MySQL Server version 5.1.41 with InnoDB plugin enabled. I have the following three tables for invoices: invoices, invoice_components and invoice_expenses. Table invoices has invoice_id primary key. Bo[详细]
2023-03-20 01:15 分类：问答MySQL: Each index on InnoDB table takes longer to create than the last
I\'ve got a MySQL table that looks like this: CREATE TABLE my_facts ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,[详细]
2023-03-20 00:02 分类：问答select for update and 3 users
I have this code and test with 3 users <?php mysql_query(\"BEGIN\"); $r=mysql_query(\"SELECT max(Ticket) from ticket FOR UPDATE\");[详细]
2023-03-19 05:31 分类：问答SELECT LOCK IN SHARE MODE
i have read this article from dev.mysql. in that page is a example that when use select for update and dont use lock in share mode and says[详细]
2023-03-19 00:15 分类：问答Can't create InnoDB table (error -1)
I\'m porting a rather simple table to my live db server and it\'s giving me this strange error when I try to create a InnoDB table, table create is:[详细]
2023-03-18 22:27 分类：问答
加载中,请稍侯......