By mengweifu1985 on

i read Pro Drupal Development book , i see

Since Drupal still uses the LOCK TABLE command with InnoDB tables, be sure to disable autocommit
mode within MySQL, or MySQL and InnoDB will both take on table locks

i am modify my.ini file. insert " init_connect = ' SET AUTOCOMMIT = 0 ' " ,
but, i can't login my drupal site , why? like 'select' is good ,but insert,set,delete is incorrect .
i from china .sorry just a lot english , somebody help me? thanks

⋅ Categories: Drupal 5.x

Comments

behindthepage’s picture

behindthepage commented

In over 3 years working with drupal I have never had to change anything on a standard MySQL set up.

Try it without any changes. Then if you have any problems, solve them.

gpdinoz
"Everything should be made as simple as possible, but not simpler." - Albert Einstein

Regards
Geoff

mengweifu1985’s picture

mengweifu1985 commented

maybe .
but performance is important !

mengweifu1985’s picture

mengweifu1985 commented

innodb_flush_log_at_trx_commit=0

my drupal performance