Hi,
Anybody know how can i safely and easily rename a database in MySQL 5.0.19.
Have tried some tips from google results (most of them are for MySQL 4.x)
but no luck till now.
Any help would be greatly appreciated.
Rgds/Hardi
Guys,
So many thanks for you kind help. I was able to find the culprit, just
adding 1 index i can get as fast as 30 thousands record per hour. So that I
can proccess 2 million data in about 4 days only.
But now, after my main tables loaded with more than 2 million data (2,9
million), i have
Hi,
I have 1 SP that does INSERT and UPDATE query to 1-2 tables. It runs ok
for sometime, but i sometime got this error message:
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
The message would ussually dissapear and the SP runs well for sometime until
the same
Hi Forums,
I have a frustrating problem on my Stored Procedure. It can only proccess
about 100 records in 10 minutes. I have 2 million initial records that need
to processed. Meaning that with this speed i will around 200 days to finish
all of them.
To make it worse, the data itself grows at
Hi,
When I used the EXPLAIN command, i see that all of my query are using the
correct index. That's why i was quite sure that index won't be the cause of
my slow query problem.
So, i now should alter the table: remove primary key and recreate index?
Many thanks,
Hardi
On 4/28/06, Daniel