Posted by Baron Schwartz |
…one chunk:
time mysql -e “set foreign_key_
checks=0; set sql_log_bin=0; set
unique_
checks=0; load data local infile ‘infile….]; do
time mysql -e “set foreign_key_
checks=0; set sql_log_bin=0; set
unique_
checks=0; load data local infile ‘/tmp/…
Posted by peter |
… only with spatial extenrsions anyway.
Speaking about
UNIQUE it is interesting. If you have
UNIQUE(… queries but It is other story.
UNIQUE is both Index and constraint, but …one ether have to create extra index or do
unique checking on application.
Posted by
peter @ 1:54 am ::
tips ::
Posted by Santiago |
… ENGINE=INNODB DEFAULT CHARSET=latin1;
SET
UNIQUE_
CHECKS=0;
START TRANSACTION;
– SOME MULTIPLE INSERTS KIND OF
INSERT INTO transferido_…LIMIT 100000,100000
);
–ETC.
COMMIT;
SET
UNIQUE_
CHECKS=1;
ALTER TABLE transferido RENAME…
Posted by peter |
…, for example MyISAM can build non-
unique indexes by sort which is very fast … MyISAM build indexes via sorting not by BTREE insertion. For Innodb SET
UNIQUE_
CHECKS=0 may be used to speed up load to tables with
unique keys.
So as you can see there…
Posted by Maciej Dobrzanski |
… waiting to enter the InnoDB queue or inside that queue waiting for execution.
InnoDB_pages_distinct tells the number of
unique pages accessed by the query. This is actually an approximation based on a small hash array representing the entire buffer …
Posted by peter |
…mysql> show index from antest_innodb;
+—————+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+
| Table | Non_
unique | Key_name | Seq_in_index | Column_name …
Posted by Raj |
… db pages 0
restart mysql and
check the count of (rajid):
mysql>…when you use a secondary index.
Check the buffer pool usage:
Total memory…default NULL,
PRIMARY KEY (`comment_ID`),
UNIQUE KEY `rajidx` (`rajid`)
) ENGINE=InnoDB DEFAULT…
Posted by peter |
… see something like
PRIMARY KEY(id),
UNIQUE KEY id(id), KEY id2(id…as object identifier, now we create
UNIQUE because we want it to be… KEY and it will enforce
unique values and will be used in… which will help you to
check your schema for redundant and …
Posted by
peter @ 1:54 am ::
tips ::
Posted by Baron Schwartz |
…
your application is not as
unique as you think, and we … is pretty common, I can
check whether MegaCli is installed, and use… etc. Nothing unusual. Next I
check what the MySQL version is, … all the things he’d
checked, which was extensive indeed. After …
Posted by
Baron Schwartz @ 9:42 pm ::
tuning ::
Posted by peter |
… to build summary tables as we want to count
uniques, but it should be fixed once we rewrite … and rating of Domains In both cases we
check how many links each of domains is getting and from how many
unique sites. For domains we split domains which are …
Posted by
peter @ 9:59 am ::
site ::
del.icio.us
digg