Re: Global read lock on delete

Artem - > |THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA > TABLE_NAME > 268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock > 270022 MDL_INTENTION_EXCLUSIVE MDL_STATEMENT Global read lock > 268871 MDL_SHARED_NO_READ_WRITEMDL_EXPLICITTable

Re: Spatial changes in InnoDB - Details?

The What's new in MySQL 5.7 manual page [1] says: * InnoDB now supports spatial data types. What is the difference to previous releases in this respect? The 5.7.1 Release Notes are a bit more specific: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-1.html InnoDB: Added support

Re: MySQL Monitor and Percona

2012/10/25 Sabika M sabika.makhd...@gmail.com: We are in the process of switching to percona binaries of MySQL . I am using Percona 5.5.27 and monitoring the MySQL server with the MySQL Enterprise monitor. It starts up fine, but after a while I end up with MySQL monitor connections stacking up