List:General Discussion« Previous MessageNext Message »
From:Karthik Date:August 27 2002 4:49am
Subject:Re: max_allowed_packet size!
View as plain text  
This is the query i run first -

select user.userid, user.name, plan.duration, plan.hour, plan.minute,
plan.status, plan.date, project.projectname,project.projectid from user,
plan, project where user.userid = plan.userid and project.projectid =
plan.projectid and plan.date >= '2002-8-13' and plan.date<='2002-12-31' and
user.userid in
('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras
ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada
','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra
jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih'
,'saroop') group by plan.userid,plan.date,plan.hour

The abover returns around 13000 records

When i run the below query it only returns 8000 odd records. The only change
is adding of user.designation colum in the query.

select user.userid, user.name, user.designation, plan.duration, plan.hour,
plan.minute, plan.status, plan.date, project.projectname,project.projectid
from user, plan, project where user.userid = plan.userid and
project.projectid = plan.projectid and plan.date >= '2002-8-13' and
plan.date<='2002-12-31' and user.userid in
('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras
ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada
','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra
jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih'
,'saroop') group by plan.userid,plan.date,plan.hour


Thanks,
Karthik.


----- Original Message -----
From: "Dicky Wahyu Purnomo" <dicky.wahyu@stripped>
To: "Karthik" <karthik@stripped>
Cc: <mysql@stripped>
Sent: Tuesday, August 27, 2002 10:07 AM
Subject: Re: max_allowed_packet size!


> Pada Tue, 27 Aug 2002 10:03:59 +0530
> "Karthik" <karthik@stripped> menulis :
>
> > Hi,
> >
> > Does the mysql max_allowed_packet restrict the amount of data that a
query
> > can fetch ?
> >
> > I am facing a problem wherein my query specifies all the 13000 odd
records
> > if i specify only a few columns. If i run the same join query with lots
of
> > columns, it only fetches 8000 odd records.
>
> could u show us both of the queries ? :D
>
> --
> Let's call it an accidental feature.
> -- Larry Wall
>
> MySQL 3.23.51 : up 67 days, Queries : 357.150 per second (avg).
>
> --
> Dicky Wahyu Purnomo - System Administrator
> PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
> Phone : +62 21 79199577 - HP : +62 8551044244 - Web :
http://www.1rstwap.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread118030@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-karthik=maximizelearning.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
max_allowed_packet size!Karthik27 Aug
  • Re: max_allowed_packet size!Dicky Wahyu Purnomo27 Aug
  • Re: max_allowed_packet size!Karthik27 Aug