/var/lib/mysql/ib_logfile0
/var/lib/mysql/ib_logfile1
их удалил уже, не помогло
/var/lib/mysql/ibdata1 - это же моя бд?! если ее удалить, все данные пропадут, ее размер 8гб
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
performance-schema = 1
#default-storage-engine = InnoDB
collation-server = utf8mb4_general_ci
init-connect='SET NAMES utf8mb4'
character-set-server = utf8mb4
#
# * Fine Tuning
#
#key_buffer_size = 512M
#table_cache = 2048
#open_files_limit = 2048
#max_allowed_packet = 5000M
thread_stack = 256K
sort_buffer_size = 512K #default: 2M, larger may cause perf issues
read_buffer_size = 512K #default: 128K, change in increments of 4K
read_rnd_buffer_size = 512K #default: 256K
join_buffer_size = 512K #default: 128K
binlog_cache_size = 64K #default: 32K, size of buffer to hold TX queries
## Connections
max_connections = 2000 #multiplier for memory usage via per-thread buffers
max_connect_errors = 100 #default: 10
concurrent_insert = 2 #default: 1, 2: enable insert for all instances
connect_timeout = 30 #default -5.1.22: 5, +5.1.22: 10
max_allowed_packet = 32M #max size of incoming data to allow
## Table and TMP settings
max_heap_table_size = 1G #recommend same size as tmp_table_size
bulk_insert_buffer_size = 1G #recommend same size as tmp_table_size
tmp_table_size = 1G #recommend 1G min
#tmpdir = /data/mysql-tmp0:/data/mysql-tmp1 #Recommend using RAMDISK for tmpdir
thread_cache_size = 16
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
#myisam-recover = BACKUP
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#thread_concurrency=16
# MySQL/MariaDB default is Latin1, but in Debian we rather default to
# the full utf8 4-byte character set. See also client.cnf
#query_cache_limit = 100M
expire_logs_days = 4
long_query_time = 3
Наталья, нужно смотреть к чему инстаграм вам разрешил доступ (лайки, подписки, базовую инфу)
Я перешел в 16м году на private api intsgram т.к. в инстаграм заблокировали мне некоторые действия через api
У меня сайт (php), куски кода брал с https://github.com/mgp25/Instagram-API
Весь сайт работает на api как в приложение на android insta.tflop.ru