Solusi -> error #1205 – Lock wait timeout exceeded September 15, 2008
Posted by budijati in Database Mysql.trackback
Utak-atik database Mysql… tipe tabelnya inno_db…ehm..buat dulu relasi (cascade, restric, set null, no action) di fieldnya , trus waktu lakukan insert atau delete keluar pesan error #1205 – Lock wait timeout exceeded;..
cara ngatasinnya cari file my.ini biasanya ada di (folder)\mysql\bin , trus edit bagian innodb_lock_wait_timeout jadi 0..
innodb_lock_wait_timeout = 0
kemudian restart MySql…
betul..betul..betul.
tp kl pake wamp yg diedit bukan file my.ini -ny tp file my-innodb-heavy-4G. adany di (folder) \Mysql ,
thank you…