mysql does not utilize my cpu and ram enough?
- by vick
Hello Everyone!
I am importing a 2.5gb csv file to a mysql table. My storage engine is innodb. Here is the script:
use xxx;
DROP TABLE IF EXISTS `xxx`.`xxx`;
CREATE TABLE `xxx`.`xxx` (
`xxx_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`yy` varchar(128) NOT NULL,
`yyy` varchar(64) NOT NULL,
`yyyy`…
