diff options
| -rw-r--r-- | nova/db/sqlalchemy/session.py | 6 | ||||
| -rw-r--r-- | nova/flags.py | 4 |
2 files changed, 10 insertions, 0 deletions
diff --git a/nova/db/sqlalchemy/session.py b/nova/db/sqlalchemy/session.py index fe1b44c41..eeadd9611 100644 --- a/nova/db/sqlalchemy/session.py +++ b/nova/db/sqlalchemy/session.py @@ -93,6 +93,12 @@ def get_engine(): 'convert_unicode': True, } + # Map our SQL debug level to SQLAlchemy's options + if FLAGS.sql_connection_debug >= 100: + engine_args['echo'] = 'debug' + elif FLAGS.sql_connection_debug >= 50: + engine_args['echo'] = True + if "sqlite" in connection_dict.drivername: engine_args["poolclass"] = NullPool diff --git a/nova/flags.py b/nova/flags.py index fb73182cf..430abe67e 100644 --- a/nova/flags.py +++ b/nova/flags.py @@ -99,6 +99,10 @@ core_opts = [ default='sqlite:///$state_path/$sqlite_db', help='The SQLAlchemy connection string used to connect to the ' 'database'), + cfg.IntOpt('sql_connection_debug', + default=0, + help='Verbosity of SQL debugging information. 0=None, ' + '100=Everything'), cfg.StrOpt('api_paste_config', default="api-paste.ini", help='File name for the paste.deploy config for nova-api'), |