my client want me to do publish all, actually that 13GB is a CSV that converted to table.
and i have to publish all,
i
so i just do "select * from table_data_cache" i waited for 5 days to load the data, but it wont load. the query hung up when i check the process, it said sending data, i checked in mysql docs sending data means the data is being readed , but it is past 5 days , i stopeed the query and i check my disk, my server admin said, my server are using xen as virualization, after that i tried to find solution , and i have idea to benchmark the disk speed, i tried it with sysbench, i…