max_allowed_packet size!

restriction is it because of ? Thanks, Karthik. - 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 <[EM

Re: max_allowed_packet size!

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

Re: ERROR 1062

this query in all probability violates some referential integrity... and this in all probability is a primary key defined in your table. So please check whether the query is trying to insert duplicate values in a primary key field - Original Message - From: "Osman Omar" <[EMAIL PROTECTED

Query not returning all records

bytes returned by a query. Is this the case ? How do i change the same ? Is there any mysql setting? I work on mysql 3.23.51 on WinNT. Thanks, Karthik P.S. - The Queries are as under - This is the query i run first - select user.userid, user.name, plan.duration, plan.hour, plan.minute

Re: problem with date/time column

its select date_sub(now(),INTERVAL 1 DAY) - Original Message - From: "Erick Papadakis" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 1:25 PM Subject: problem with date/time column > hi, > > i have a date/time column. i insert into it using "now()

Re: problem with date/time column

Instead why don't you try select date_sub(now(), INTERVAL 1 DAY) Karthik. - Original Message - From: "DL Neil" <[EMAIL PROTECTED]> To: "Erick Papadakis" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]> Sent: Wednesday, September

Re: max_connections

yes. put an entry "set-variable=max_connections=300" after "set-variable = thread_concurrency=8" in your my.ini. Make sure this change is done in the my.ini that is in the windows directory. Karthik. - Original Message - From: "Stefan Faist" <[EMAIL

Help me

I have created a table as follows but i was not able to use full text search on a specific data. create table racebike (id int auto_increment not null primary key, name varchar(10), user text,fulltext(name,user)); The table is as follows, ++-+-+ | id | name|

cant establish connection at application side.

plication would solve but thats not a solution for my situation .. i have configured max number of connections to 500 .. and the total number of connections hardly reach 100 .. Any help please .. Thanks Karthik.

Re: cant establish connection at application side.

tion was established but takes extra time ) .. The application says 'Can not establish connection' => cant establish connection in a specified timeout.. Am i guessing anything wrong or can I get any ideas please ? Thanks Karthik. On Thu, Sep 2, 2010 at 8:32 PM, Michael Dykman w

Re: cant establish connection at application side.

Wow .. Cool that solved our problem... Thanks a lott .. On Thu, Sep 2, 2010 at 9:20 PM, Jangita wrote: > On 02/09/2010 4:57 p, karthik kumar wrote: > >> Hi .. I am facing a problem in mysql. >> >> I am getting error 'Can not open connection' at the

Trouble with large data in MySql

(loggingTime ,'%d/%m/%Y') logDate, count(distinct requestid) adpages from SMAS where sucess = 1 GROUP BY 1,2,3,4; Any help will be highly appreciated. -Karthik

RE: Trouble with large data in MySql

I have not specified any values for join_buffer_size and sort_buffer_size. What should be the optimal values for this? -Karthik From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2008 10:03 AM To: Karthik Pattabhiraman Cc: mysql@lists.mysql.com Subject

RE: Trouble with large data in MySql

illion records and it takes hours to come out. In this table requestid is unique. What other indexes can I create to speed up the response time of my query? What should I configure in mysql? Can you help me with this? I have 6GB RAM, 2 cores and 7200 RPM disk with 1TB size. Thanks in adv

RE: Trouble with large data in MySql

Hi Martin, Sorry, I am not able to understand this. Can you explain in detail please? -Karthik From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2008 6:56 PM To: Krishna Chandra Prajapati; Karthik Pattabhiraman Cc: mysql@lists.mysql.com Subject: RE: Trouble

optimizing a select statement over a database with >50 million recs

Need help on optimizing the select statement: Table structure table1 -- id p_id table2 -- p_id out_id table3 -- out_id name_id table4 --- name_id (unique) prev_id start_id (unique) end_id (unique) Only table4 has unique fields all other fields are not unique. The followin

Re: optimizing a select statement over a database with >50 million recs

y a list. Any advice on this will be really useful. Is there anything I could do with the mysql and php configuration to increase the performance? The server has just 1GB ram, will adding more memory help? Thanks Karthik. > Need help on optimizing the select statement: > > Tab

RE: optimizing a select statement over a database with >50 million recs

| 1 | | | a | ref | p_id | p_id | 4 | b.p_id | 3 | Using where | e | eq_ref | PRIMARY,start_id,combine,name_id | PRIMARY | 4 | d.name_id | 1 | Distinct | f | range | PRIMARY,name_id | PRIMARY | 4 | NULL | 2 | Using | where; | Distinct | Karthik > Can you send us a new explain on t

RE: optimizing a select statement over a database with >50 million recs

doesnt show the "Using temporary" but I dint see any difference in the time also. Please let me know if you need any further information Thanks Karthik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

memory issue: paging, disk activity, table size -> was: optimizing a select statement

largest table size. is this true even if the query uses only few columns of big tables? Thanks for your help Karthik. At 07:44 PM 2/29/2004, you wrote: So if this is your query and based on the explain this is what I would recommend. SELECT Distinct (a.id) From table1 a INNER JOIN table1 b USING