¿Es normal que tarde taaaaanto en insertar 3000 atributos?

[NBlack]

Ya tiro la toalla en optimización, no se si es problema de prestashop o mío.

Tengo las especificaciones siguientes:

RAM: 8GBs

6VCores

100GB Raid 10

 

El caso es que me tarda 1 hora o más en insertar 3306 atributos a diversos productos y el caso es que tengo hasta 18000 atributos para meter.

 

He mirado el slow-query de mysql, he mirado el mytop y veo que hace un montón de sleep entre consulta y consulta.

 

mi configuración de my.cnf es la siguiente:

[mysqld]

 

#local-infile=0

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

#bind-address=127.0.0.1

sort_buffer_size=256k

read_buffer_size=128k

max_connections=200

max_user_connections=50

query_cache_type = 1

query_cache_size = 50M

query_cache_limit = 50M

join_buffer_size=100M

read_rnd_buffer_size=8M

max_allowed_packet = 10M

tmp_table_size=50M

max_heap_table_size=50M

table_cache = 5000

thread_cache_size = 50

open_files_limit=30000

key_buffer_size = 200M

myisam_sort_buffer_size = 256M

innodb_buffer_pool_size = 500M

slow_query_log = 1

slow_query_log_file = log-slow.log

long_query_time = 0.1

log-queries-not-using-indexes

connect_timeout = 2

read_buffer=1000M

join_buffer_size=4M

 

 

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

 

Y la de mi apache esta:

ysql.default_host =

request_order = "GP"

display_errors = Off

mysqli.default_socket =

safe_mode_exec_dir =

html_errors = Off

session.entropy_length = 0

y2k_compliance = On

post_max_size = 8M

asp_tags = Off

memory_limit = 3G

short_open_tag = on

SMTP = localhost

precision = 14

session.bug_compat_warn = Off

sybct.min_server_severity = 10

mssql.min_message_severity = 10

session.gc_maxlifetime = 1440

session.gc_probability = 1

allow_url_include = Off

mysqli.default_host =

mysqli.default_user =

session.referer_check =

pgsql.log_notice = 0

mysql.default_port =

odbc.defaultlrl = 4096

pgsql.ignore_notice = 0

mysql.trace_mode = Off

engine = On

odbc.allow_persistent = On

track_errors = Off

pgsql.allow_persistent = On

session.auto_start = 0

auto_append_file =

disable_classes =

mysql.default_password =

url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry"

allow_call_time_pass_reference = Off

ignore_repeated_source = Off

sql.safe_mode = Off

session.cookie_path = /

session.entropy_file =

expose_php = off

report_memleaks = On

session.gc_divisor = 1000

mssql.max_persistent = -1

serialize_precision = 100

odbc.check_persistent = On

sybct.max_links = -1

define_syslog_variables = Off

session.cookie_httponly =

session.cache_limiter = nocache

enable_dl = Off

ignore_repeated_errors = Off

mysqli.default_port = 3306

disable_functions =

magic_quotes_sybase = Off

soap.wsdl_cache_enabled = 1

soap.wsdl_cache_dir = "/tmp"

session.use_cookies = 1

mysql.default_user =

implicit_flush = Off

bcmath.scale = 0

 

 

¿Haré algo mal? ¿o es normal?

 

Me llego incluso a plantear si comprar algun programa tipo manager para insertar todo más rápido...

 

Gracias chicos

 

[shacker]

pues si, inserta en muchas tablas, por lo que te tardara. a armarse de paciencia (no se si una hora  , pero demora)