All this code is out of nova now, removing it ** No longer affects: nova
-- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1007027 Title: Unnecessary "SELECT 1" statements spamming MySQL server Status in Oslo Database library: Incomplete Bug description: Nova is issuing a lot of unnecessary "SELECT 1" queries against its MySQL database. I believe this is due to the MySQLPingListener() function in nova/db/sqlalchemy/session.py. Even though "SELECT 1" is a light-weight database call, it is unnecessary and wasting resources (database CPU cycles) and time (extra network round trips), and is not guaranteeing a valid database connection. In other words, it is just a waste of resources. See http://www.mysqlperformanceblog.com/2010/05/05/checking-for-a -live-database-connection-considered-harmful/ for a longer discussion of why this should be removed. To manage notifications about this bug go to: https://bugs.launchpad.net/oslo.db/+bug/1007027/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
