#24675: Unnecessary queries since MySQL 5.6
----------------------------------------------+--------------------
Reporter: ssjunior | Owner: nobody
Type: Cleanup/optimization | Status: new
Component: Database layer (models, ORM) | Version: 1.8
Severity: Normal | Keywords: mysql
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
Every connection mada to MySQL is issuing an unnecessary query setting
SQL_AUTO_IS_NULL to 0. Since MySQL this is not needed anymore and this can
be set in the server variables too. Avoiding this query will result in
better performance. This shoud be a settings options that allow user to
enable or disable this unnecessary query.
http://dev.mysql.com/doc/refman/5.6/en/server-system-
variables.html#sysvar_sql_auto_is_null
System Variable Name sql_auto_is_null
Variable Scope Global, Session
Dynamic Variable Yes
Permitted Values Type boolean
Default 0
--
Ticket URL: <https://code.djangoproject.com/ticket/24675>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/051.21feb5b171467bccadd5cf598d21dade%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
