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 metad

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 su

Re: MySQL Monitor and Percona

2012/10/25 Sabika M : > 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 until the server beco