Hi Berry,
Beegee wrote:
> My test results. I installed
> mysql-standard-5.0.20-linux-x86_64-glibc23. Created a completely new
> database and restored a backup from my 'old' django database into the
> newly created MySql 5 instance.
>
> Restarted Apache and everthing was up and running again. Gre
My test results. I installed
mysql-standard-5.0.20-linux-x86_64-glibc23. Created a completely new
database and restored a backup from my 'old' django database into the
newly created MySql 5 instance.
Restarted Apache and everthing was up and running again. Great!
I checked with SHOW variables LI
Beegee wrote:
> Currently I am using MySQL version 4.0.24. Looking at all the answers
> the best thing to do is to try MySQL v5. I will do some testing over
> the weekend and post my experiences.
>
> Thanks very much for your help.
Just FYI, binary upgrading 4.0 to 5.0 is a bad idea: dump data u
Currently I am using MySQL version 4.0.24. Looking at all the answers
the best thing to do is to try MySQL v5. I will do some testing over
the weekend and post my experiences.
Thanks very much for your help.
Berry
--~--~-~--~~~---~--~~
You received this message
Hi Berry,
Beegee wrote:
> This is a part from the manual of MySQL: "In MySQL 4.0, the query cache
> is disabled within transactions (it does not return results). Beginning
> with MySQL 4.1.1, the query cache also works within transactions when
> using InnoDB tables (it uses the table version numb
.
-Original Message-
From: django-users@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Beegee
Sent: vrijdag 21 april 2006 8:19
To: Django users
Subject: Re: MySQL Query cache hits stay zero
This is a part from the manual of MySQL: "In MySQL 4.0, the query cache
is disabled w
I don't know if this is helpful at this point, but on my MySQL 5 server,
the query cache hit count is quite high for Django queries.
--Ned.
Beegee wrote:
> This is a part from the manual of MySQL: "In MySQL 4.0, the query cache
> is disabled within transactions (it does not return results). Beg
This is a part from the manual of MySQL: "In MySQL 4.0, the query cache
is disabled within transactions (it does not return results). Beginning
with MySQL 4.1.1, the query cache also works within transactions when
using InnoDB tables (it uses the table version number to detect whether
its contents
On 4/20/06, Andy Dustman <[EMAIL PROTECTED]> wrote:
> Do statements generated by Django have columns in a deterministic order?
Just for the record, yes, the columns will always be in the same order.
Adrian
--
Adrian Holovaty
holovaty.com | djangoproject.com
--~--~-~--~~
On 4/20/06, Andy Dustman <[EMAIL PROTECTED]> wrote:
> I've reopened that bug, but I am very skeptical that anything in
> MySQLdb can be causing it.
And I'm probably right, since it seems he is using MySQL-4.0 which,
while it does have the query cache, it is disabled for transactions on
InnoDB. 4.
On 4/20/06, Adrian Holovaty <[EMAIL PROTECTED]> wrote:
>
> On 4/20/06, Beegee <[EMAIL PROTECTED]> wrote:
> > No, then it also doesn't work. When I repeat the following query:
> >
> > cursor.execute('select * from wifidog_businesses limit 10')
> >
> > using MySQLdb the number of Cache hits do not i
On 4/20/06, Beegee <[EMAIL PROTECTED]> wrote:
> No, then it also doesn't work. When I repeat the following query:
>
> cursor.execute('select * from wifidog_businesses limit 10')
>
> using MySQLdb the number of Cache hits do not increase. However, the
> number of Qcache_queries_in_cache also do not
No, then it also doesn't work. When I repeat the following query:
cursor.execute('select * from wifidog_businesses limit 10')
using MySQLdb the number of Cache hits do not increase. However, the
number of Qcache_queries_in_cache also do not increase. Strange.
I did find an issue on the MySQL fo
On 4/20/06, Beegee <[EMAIL PROTECTED]> wrote:
> When I manually type in a query on the MySQL command line and execute
> it several times, the Qcache_hits indeed increases. So, the cache
> functionality is working.
That's strange. I don't use MySQL, so I haven't encountered this
issue, but one str
14 matches
Mail list logo
