Re: Replication problems
That got me greping through my Master's log and I came accross the following : Error reading packet from server: log event entry exceeded max_allowed_packet - increase max_allowed_packet on master (server_errno=65535) This seems to have happened in the date ranges where replication was failing. I cant confirm it is related but is it possible this would cause replication to fail on the server ? Also a new table is created every day therefore a single failure cant have been the reason for replication failure over a period of time. It also brings me to a critical question what do I set as the max_allowed_packet so that I will successfully save all updates to a TEXT field? TEXT fields dont have a size limit so how do I make sure I will never see this error ? Mithun Jeremy Zawodny wrote: I can successfully run the SQL on the slave manually and it obviously has run successfully on the master. Why is that obvious? It's telling you that the slave expected to get an error but didn't. Those expectations come from the master's binlog. I'd repair the table on the master, since it's likely in some sort of trouble. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Group by and Count query
What about SELECT COUNT(DISTINCT(host)) FROM TABLE_HOST WHERE path_a=; Mithun Karl J. Stubsjoen wrote: Hello, I am trying to count the number of unique records that exist in my database based on a given criteria. My table looks like this: TABLE_HOST id host path_a path_b The field host will have duplicates like: myway.com hisway.com hisway.com hisway.com someway.com someway.com yourway.com The given criteria is: only count the records where path_a is blank (path_a='') Here is the query I'd like to run (which fails - but is exactly what I need for a query): select sum(count(host)) from TABLE_HOST where path_a='' group by host This is the next query I tried... (nothing distinct about the result of a count) select distinct count(host) from TABLE_HOST where path_a='' So, is it possible to perform this query? Karl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]