Re: Mysql problem

I second the Daniel Roseman presentation, check out his blog as well – he has a few posts about optimizing querysets. Get debug-toolbar on there and see what's actually causing it. Bad template code is the most common thing I've found, executing the same query 1,000+ times in a loop when once

Re: Mysql problem

On Thu, Feb 23, 2012 at 6:21 AM, kalyani ram wrote: > a backend having about 2lakh records i couldn't resist, and found this: http://en.wikipedia.org/wiki/Lakh translated, it's "about 200,000 records" -- Javier -- You received this message because you are

Re: Mysql problem

use index On Thu, Feb 23, 2012 at 4:51 PM, kalyani ram wrote: > Hey ppl! > > I there anybody who can help me on a problem with a slow page process > with mysql as a backend having about 2lakh records ?? > > Thanks in advance. > > Regards, > kalyani > > -- > You received

Re: Mysql problem

http://www.slideshare.net/danielroseman/advanced-django-orm-techniques -- 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

Mysql problem

Hey ppl! I there anybody who can help me on a problem with a slow page process with mysql as a backend having about 2lakh records ?? Thanks in advance. Regards, kalyani -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group,

Re: how to solve the MySQL problem?

On Thu, May 22, 2008 at 8:58 PM, Qiang <[EMAIL PROTECTED]> wrote: > > how to config the MySQL before i run the manage.py? how do i know that > MySQL is running? > > On May 23, 12:34 am, jonknee <[EMAIL PROTECTED]> wrote: > > > _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL > >

Re: how to solve the MySQL problem?

how to config the MySQL before i run the manage.py? how do i know that MySQL is running? On May 23, 12:34 am, jonknee <[EMAIL PROTECTED]> wrote: > > _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL > > server on 'lo > > calhost' (10061)") > > It can't connect to MySQL. Make

Re: how to solve the MySQL problem?

> _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL > server on 'lo > calhost' (10061)") It can't connect to MySQL. Make sure your settings are accurate and that MySQL is running. --~--~-~--~~~---~--~~ You received this message because you are

how to solve the MySQL problem?

when i use the Manage.py syncdb the creat the database . the django throw me this below. what's the problem about it? anyone can tell me? thanks very much Traceback (most recent call last): File "E:\wiki\manage.py", line 11, in execute_manager(settings) File

Re: MySQL-problem with NULL values (svn rev. 4788)

Malcolm Tredinnick <[EMAIL PROTECTED]> writes: > http://www.djangoproject.com/documentation/model-api/#overriding-default-model-methods > . Found it two minutes before :) Many thanks! Regards, Frank --~--~-~--~~~---~--~~ You received this message because you

Re: MySQL-problem with NULL values (svn rev. 4788)

On Fri, 2007-03-23 at 23:31 +0100, Frank Tegtmeyer wrote: > Hi Malcolm, > > thanks for your replies. > > > In your form processing code, check for empty strings and update it with > > the default value if you wish. > > I use the create_object generic view. I looked for the mentioned > pre_save

Re: MySQL-problem with NULL values (svn rev. 4788)

Hi Malcolm, thanks for your replies. > In your form processing code, check for empty strings and update it with > the default value if you wish. I use the create_object generic view. I looked for the mentioned pre_save hook in all the docs but couldn't find any hint how to use this. I assume

Re: MySQL-problem with NULL values (svn rev. 4788)

On Fri, 2007-03-23 at 22:15 +0100, Frank Tegtmeyer wrote: [...] > Questions: > > 1. Why is the default value in the database not set to 0? The 'default' attribute in Django is intentionally not passed through as a database constraint when the table is constructed. This is partly because there

MySQL-problem with NULL values (svn rev. 4788)

Hi, I just upgraded my two months old Django installation, MySQLdb was already at the required level. I have now the problem that MySQL-warnings come through and throw a Warning exception. The reason is that some smallint values are filled with empty strings when a choice-Field got no

Re: admin connection mysql problem

On 6/26/06, Patrick <[EMAIL PROTECTED]> wrote: > File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 151, > in __init__ > self.converter[types.StringType] = string_literal > > TypeError: object does not support item assignment I don't really know what the actual cause

Re: admin connection mysql problem

Patrick Martini wrote: > Thanks for the answer :) > I have tries to start my site without installed application. > But the admin give me always the same problem. > > I have already broken two keyboards trying to risolve the problem :) > > Have you another suggestion ? nope, sorry!...

Re: admin connection mysql problem

Thanks for the answer :) I have tries to start my site without installed application. But the admin give me always the same problem. I have already broken two keyboards trying to risolve the problem :) Have you another suggestion ? > > Oh well, sorry my suggestion didn't help. > > A brute force

Re: admin connection mysql problem

Now i have tried only the default admin page without any app and the results are the same John DeRosa wrote: > When I've seen messages similar to this, it's usually because an > identifier in the meta.Admin list_display list was not defined as a > field in the class. A good place to start

Re: admin connection mysql problem

Thx john i have checked the spelling of every field listed in Admin class but the error was always there. Patrick John DeRosa wrote: > When I've seen messages similar to this, it's usually because an > identifier in the meta.Admin list_display list was not defined as a > field in the class.

Re: admin connection mysql problem

When I've seen messages similar to this, it's usually because an identifier in the meta.Admin list_display list was not defined as a field in the class. A good place to start would be to check the spelling of every field listed in meta.Admin. John Patrick wrote: > Hi, > when i go in my

admin connection mysql problem

Hi, when i go in my admin site (http://basetta.pupazzo.org/admin) I recieve always this Mod_python error: "PythonHandler django.core.handlers.modpython" Traceback (most recent call last): File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line 299, in HandlerDispatch result =

Re: admin apache solved? / now mysql problem

Andy Dustman wrote: > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > Andy Dustman wrote: > > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > Andy Dustman wrote: > > > > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > OperationalError: (2002, "Can't connect to local MySQL

Re: admin apache solved? / now mysql problem

Todd O'Bryan wrote: > On Mar 28, 2006, at 8:20 AM, Andy Dustman wrote: > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > >> OperationalError: (2002, "Can't connect to local MySQL server through > >> socket '/var/lib/mysql/mysql.sock' (13)") > > > > This indicates your MySQL server isn't

Re: admin apache solved? / now mysql problem

On Mar 28, 2006, at 8:20 AM, Andy Dustman wrote: > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > >> OperationalError: (2002, "Can't connect to local MySQL server through >> socket '/var/lib/mysql/mysql.sock' (13)") > > This indicates your MySQL server isn't running, and you are using >

Re: admin apache solved? / now mysql problem

On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > Andy Dustman wrote: > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > > > > > > Andy Dustman wrote: > > > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > > > > > > OperationalError: (2002, "Can't connect to local MySQL server through > >

Re: admin apache solved? / now mysql problem

Andy Dustman wrote: > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > > > Andy Dustman wrote: > > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > > > > OperationalError: (2002, "Can't connect to local MySQL server through > > > > socket '/var/lib/mysql/mysql.sock' (13)") > > > > > > This

Re: admin apache solved? / now mysql problem

On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > Andy Dustman wrote: > > On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > > > > > OperationalError: (2002, "Can't connect to local MySQL server through > > > socket '/var/lib/mysql/mysql.sock' (13)") > > > > This indicates your MySQL server isn't

Re: admin apache solved? / now mysql problem

On 3/28/06, abe <[EMAIL PROTECTED]> wrote: > OperationalError: (2002, "Can't connect to local MySQL server through > socket '/var/lib/mysql/mysql.sock' (13)") This indicates your MySQL server isn't running, and you are using DATABASE_HOST="localhost". -- The Pythonic Principle: Python works the

Re: admin apache solved? / now mysql problem

Adrian Holovaty wrote: > On 3/24/06, abe <[EMAIL PROTECTED]> wrote: > > I get a blank screen (in the browser) and the > > httpd error logs say : > > > > [Fri Mar 24 18:36:09 2006] [notice] mod_python: (Re)importing module > > 'django.core.handlers.modpython' > > [Fri Mar 24 18:36:17 2006]

Re: freebsd 5.4 mysql problem

I am running Ubuntu 5.10, Python 2.4.2, MySQL 4.1.12, and MySQLdb 1.2.1c3, and I have the same problem. It may be that this is a problem introduced in a recent release, because all three of us have brought it up around the same time. I will post a solution if I find one, but for now, I have to

Re: freebsd 5.4 mysql problem

Dmitry Medvedev wrote: > i've encountered really weird problem on FreeBSD 5.4 , python 2.4.2 , > py24-MySQL-db-1.2.0 and mysql , i've moved my project from Gentoo Linux, > used subversion to get latest branch of django, created mysql > database, set correct values in setting.py , mysql client

freebsd 5.4 mysql problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 i've encountered really weird problem on FreeBSD 5.4 , python 2.4.2 , py24-MySQL-db-1.2.0 and mysql , i've moved my project from Gentoo Linux, used subversion to get latest branch of django, created mysql database, set correct values in setting.py

Re: MySQL problem

Hmm. connection_timeout is 5. Might be the problem. Or not. "Eugene Lazutkin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Simon, > > Thank you for good suggestion. I checked the variable. It's value is > 28800. I am sure that none of my queries takes 8 hours to complete. >

Re: MySQL problem

Simon, Thank you for good suggestion. I checked the variable. It's value is 28800. I am sure that none of my queries takes 8 hours to complete. Most probably Django keeps connections open between requests (make sense for performance). That connection is closed after 8 hours but Django (?)

Re: MySQL problem

This error often occurs when MySQL times out because the query's taking too long. At a guess this would be at the MySQL end of things - try running this command at the mysql prompt: SHOW VARIABLES LIKE 'wait_timeout'; You should get something like this: +---+--+ |

MySQL problem

Hello, I host my Django app on Dreamhost. They provide MySQL. I am getting a weird MySQL-related error on regular basis: "OperationalError: (2013, 'Lost connection to MySQL server during query')". Typical traceback is at the end of this message. Typically it happens when I do 1st-2nd access