read_log_event(): 'Event too big', data_len: 1769103726, event_type: 44
Could not read entry at offset 572573:Error in log format or read error
../*!40019 SET @@session.max_insert_delayed_threads=0*/;

now see the size?
1.7 Gb

but how it's bigger
i've duplicated two tables
on DB
replicate-do-table=one, two
and not it's more than 10Mb

what is the file size of that bin log file?

5812

if the tables are small, maybe you should just setup the slave again
the file cannot be so small right

setup the slave again
?

since the table is only 10MB, and you have a few other bin log, maybe setup the slave again is easier

how i can? can you help me please?
and thanks, for all

how did you setup that in the first place, do the same

http://www.howtoforge.com/mysql_database_replication
i try this howto

redo it all over again
thrash all data in the slae
*slave

how i can trash all date
mysql run with other services

i hope the procedure is right, since I am not going to read that

are on production

then? how did you setup in the first place
jsut do the same
your slave is so far behind anyway

but
i don't understand
why my max_allowed_packet
show 1,7Gb
when my tables size are 10Mb

unless you can see what is that statement, you won;t understand

(i replicate tables not database)
database yes it's so big

all changes get send over

on db?

the slave server hosting decides how to filter

ok
then, my BD it's so big
alwais fails
with this size
and the uniq solution it's set 1,7Gb max_allowed_packet

no idea if the max is 1GB or 4GB

ok, yes

you can try 2GB

ok
then mysql slave determine the tables that it's parse and need to get 1,7Gb to read it and get 5Mb of my tables
?
are correctly?

yes

ok, thanks

hi
on my php page, how can I state the number of records found?
or should I ask in ##php?

mysql_num_rows() in PHP or count(0) in SQL

I have an access database and I really want to convert it to mysql is there any way to do that?

Google

migration toolkit

why would anyone ever dump access???

access has size limitation
but has a frontend for simple apps
to take advantage of it, convert the data to mysql and use odbc to access the data through Access

is it possible to get the number of total records and number of total records that meet a criteria in the same query ? Example: Paging results i need to know the total number of records that meets a search (to build the pagination links) and to get only the records that meets limit 20,10 for
example, could i do that in a single query ?

offsets

than the id's already passed.

mm… so i should make two querys ?
the problem is that the pagination goes trought 100k records doing a mysql full text search, and takes around 1-1.5 seconds… i coul dlive with that, but having to do it twice ruins the experience :/
the problem is that the pagination goes trought 100k records doing a mysql full text search, and takes around 1-1.5 seconds… i coul dlive with that, but having to do it twice ruins the experience :/

MarcosBL, are you doing any order by on top of the fulltext

!m MarcosBL SQL_CALC_FOUND_ROWS

MarcosBL see http://dev.mysql.com/doc/refman/5.0/en/select.html

heh
!m MarcosBL FOUND_ROWS

MarcosBL see http://dev.mysql.com/doc/refman/5.0/en/information-functions.html

i'll take a look
archivist, yes, a order by match desc

do an explain

hi

ok

i've a problem with mysql replication
40019 SET @@session.max_insert_delayed_threads=0*/;(ERROR: Error in Log_event