OS:Scientific Linux release 6.4 (Carbon)
Kernel : 2.6.32-358.el6.x86_64
gcc : 4.4.7
Memory space:24GB

Hi,

Could you provide a more thorough description of the problem and if you have repeatable set of commands/test case or database that would help to start resolving the actual issue.

Thanks for your quick reply. I just attach two files, primary_info is the file which I'd to load into MariaDB, and there are 1720 sections. But I can just see 911 rows after I query the table. I also attach the end of the result of "select * from primary_info". Here is how I created my table: create table primary_info ( Hostname varchar(20) not null flag=1, MM_IP varchar(20) not null, Bay varchar(10) not null, Location varchar(20) not null, Purpose varchar(15), Annotation varchar(50)) engine=CONNECT table_type=INI file_name='/tmp/asgc_resource/primary_info/primary_info';
Thanks a lot.

Best Regards,
W.J. Chang

Actually the documentation is out of date and you have been mislead because of this.

The default section buffer size is not 2K but 8K, and the option name is not seclen but secsize. Specifying:

option_list='secsize=16K'

I was able to display the 1720 sections.