We have been optimizing our server (db and caching) since our recent launch and one thing we've been looking at is our server status:
Total queries: 4,307,827 Com_admin_commands: 3,754,356 Com_insert: 37,790 Com_select: 1,354,134 Com_set_option: 172,319 Com_update: 52,759 Com_commit: 88,107 (this is approx over 10 hours uptime, 10K visitors/day). Running Django trunk, mysql Ver 14.12 Distrib 5.0.32, python 2.5, Debian. The com_admin_commands seems extremely high. I have tested on another machine with similar setup and can confirm that almost every SELECT run through the Django ORM (and possibly INSERT/UPDATE/DELETE) is running a com_admin_command. Running queries separately on MySQL or through connection.cursor() do not cause this. For example: from django.contrib.auth.models import User u = User.objects.get(pk=1) will cause an increase in com_admin_commands but not from django.db import connection c=connection.cursor() c.execute("select * from auth_user") I have 3 questions: 1) Have other django/mysql developers encountered this? 2) Have they encountered perfomance issues as a result ? 3) Which command (if any) is being fired to cause an increase in com_admin_commands ? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---