If you are getting table full error,may be your table
size is exceeding the maximum default size allowed.
check the table size and default size.
You can change the maximum size of the table using
Alter table command.
Somthing like following,but it is better so back up
the database before doing thi
there is no index
> on tableB.user_id your join will not work well,
> since the actual join
> would be on tableB.user_id=tableA.user_id
>
> Either change your index on table b to be
> user_id,user_data2 or add
> this index.
>
> Hope this helps,
> Ken
> Ken
>
Hi,
I'm new to mysql.
I have two big tables ,tableA>4GB and tableB>1GB.
both tables around 10 million rows,each.
tableA has following two cols.
user_id(varchar(255) PRIMARY KEY
user_data1(MEDIUMTEXT)
entries looks like
user1 xyz
user2 x1..
table