我有以下几点:
TableA -20米行TableB-500 K行
许多查询,特别是下面的查询,都要花费很长时间。
UPDATE
TableA AS A
INNER JOIN
TableB AS B
ON B.Value IS NOT NULL AND A.Key=B.Key
SET
A.Value = B.Value
WHERE
A.Value IS NULL;
我知道我的MySQL (MyISAM)不是为大型表配置的,我确信它可以使用更多可用内存(总计4GB)或CPU (i7)。我应该查看my.ini中的哪些参数?
我从key_buffe
使用来自ms access查询的此命令的->:
insert into mysqlInnoDb_remoteTable select * from test_localTable
insert intomysqlMyIsam_remoteTable select * from test_localTable
delete * from mysqlInnoDb_remoteTable
delete
我有以下MySQL RoR迁移:
class ReindexRpushNotification < ActiveRecord::Migration
def up
execute("DROP INDEX `index_rpush_notifications_multi` ON rpush_notifications;")
execute("ALTER TABLE rpush_notifications ADD INDEX index_rpush_notifications_multi (delivered, failed, processing,