say that it is done intentionally but could not point anyone because
we did not enable the logging feature in MySQL.
You already said it yourself: you don't have logging enabled, so that data
is not available.
If you have binary logs, you could comb through those for the delete
statements; t
Hello.
We have a table using the memory engine and we notice in PMA that the overhead
continues grow over time. Normally we'd optimize with such an issue but that
is not applicable to memory based tables. So... does this pose a problem for
long term use of the table? If so, is there a reco
.
--
From: "Geoff Galitz"
Sent: Thursday, January 06, 2011 10:46 AM
To:
Subject: mysql 5.5 optimize changes?
Hello.
Our team has upgraded a few of our mysql servers from 5.0.77 on centos to
5.5.8. Since then mysqlcheck -Ao has been fa
Hello.
Our team has upgraded a few of our mysql servers from 5.0.77 on centos to
5.5.8. Since then mysqlcheck -Ao has been failing with permissions errors:
mysqlcheck: Got error: 1142: SELECT,INSERT command denied to user
'root'@'localhost' for table 'XXX' when executing 'OPTIMIZE TABLE ...
Re-sending... my mail client or server somehow mangled my original
message... sorry.
--
Hello,
We are having issues with one of our servers sometimes hanging up and when
attempting to shutdown the DB, we get "cannot
Hello,
We are having issues with one of our servers sometimes hanging up and when
attempting to shutdown the DB, we get "cannot create thread" errors.
This server has 6GB of RAM and no swap. According to some reasearch I was
doing I found this formula for calculating memory size:
key_buffer_s
Hello.
I need to migrate a master and slave to new hardware. The DB is approx 50G on
disk and my time window for downtime is approximately 4 hours.
My question is, is it advisable to do a mysqldump from the old master and then
load on the new master and slave, or is it faster to just set th
