innodb
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 分类:问答How innodb_log_file_size would affect performance?
I am using MySQL-v5.5.12 and I got the same performance as MySQL-v5.5.1.39. So I decided to increase the innodb_log_file_size.[详细]
2023-03-18 12:34 分类:问答MySQL Cost: InnoDB on Cascade or MyISAM separate deletes
I\'m curious as to which would be more cost efficient in terms of resourc开发者_StackOverflowes used by the server: On Cascade Delete that traverses multiple tables or multiple delete statements with[详细]
2023-03-18 08:27 分类:问答Creating a Foreign Key constraint with multiple fields in MySQL innodb
I have two tables: invoices & invoice_items. I need a one to many relationship between the two with cascading delete (so if the invoice is deleted, the items also get deleted).[详细]
2023-03-18 07:36 分类:问答