Para crear registros por medio de un loop
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
DELIMITER $$ DROP PROCEDURE IF EXISTS insert_ell_rows $$ CREATE PROCEDURE insert_ell_rows () BEGIN DECLARE crs INT DEFAULT 0; WHILE crs < 11 DO SET crs = crs + 1; Insert into events (id,Valor) Values(crs,0); END WHILE; END $$ |
Para ejecutar la funcion
|
1 |
call insert_ell_rows; |
By default is seems the soft and hard open files limits on MariaDB in CentOS 7 are 1024 and 4096 respectfully. You can see these limits by first getting the process ID:
|
1 |
cat /var/run/mariadb/mariadb.pid |
And then looking at the limits in the proc filesystem:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[root@web1 ~]# cat /proc/7688/limits Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 8388608 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 31209 31209 processes Max open files 1024 4096 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 31209 31209 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us |
Notice the numbers for “Max open files”.
If you run into problems with MariaDB failing and you see errors like this in the log:
|
1 |
systemctl daemon-reload |