The speed is very slow. MySQL database

I installed Xampp and started it through MySQL server. There is a base, tables in the formats * .idb, * .frm, db.opt. They simply copied (the MySQl server is disabled) to the xampp folder (where the MySQL database files are stored) and made an upgrade. I started the server back and connected to the database via navikat. All tables are visible (I open the table, all the data is there), light queries are executed. And when I ask complex queries, it takes a very very long time, it may not be executed, it never happened to the end. (the problem is not in the requests 100% sure, because previously a maximum of 5 minutes was performed, and now even 2 hours is not executed). Tell me what could be the cause of this problem? previously made a dump. This time I’m trying to restore the base from bd.sql (15GB) via Navikat ... I have been waiting for 3 days for the recovery to finish.

># Example MySQL config file for small systems. ># ># This is for a system with little memory (<= 64M) where MySQL is only used ># from time to time and it's important that the mysqld daemon ># doesn't use much resources. ># ># You can copy this file to ># F:/Xampp/mysql/bin/my.cnf to set global options, ># mysql-data-dir/my.cnf to set server-specific options (in this ># installation this directory is F:/Xampp/mysql/data) or ># ~/.my.cnf to set user-specific options. ># ># In this file, you can use all long options that a program supports. ># If you want to know which options a program supports, run the program ># with the "--help" option. ># The following options will be passed to all MySQL clients >[client] ># password = your_password >port = 3306 >socket = "F:/Xampp/mysql/mysql.sock" ># Here follows entries for some specific programs ># The MySQL server >[mysqld] >port= 3306 >socket = "F:/Xampp/mysql/mysql.sock" >basedir = "F:/Xampp/mysql" >tmpdir = "F:/Xampp/tmp" >datadir = "F:/Xampp/mysql/data" >pid_file = "mysql.pid" ># enable-named-pipe >key_buffer = 16M >max_allowed_packet = 1M >sort_buffer_size = 512K >net_buffer_length = 8K >read_buffer_size = 256K >read_rnd_buffer_size = 512K >myisam_sort_buffer_size = 8M >log_error = "mysql_error.log" ># Change here for bind listening ># bind-address="127.0.0.1" ># bind-address = ::1 # for ipv6 ># Where do all the plugins live >plugin_dir = "F:/Xampp/mysql/lib/plugin/" ># Don't listen on a TCP/IP port at all. This can be a security enhancement, ># if all processes that need to connect to mysqld run on the same host. ># All interaction with mysqld must be made via Unix sockets or named pipes. ># Note that using this option without enabling named pipes on Windows ># (via the "enable-named-pipe" option) will render mysqld useless! ># ># commented in by lampp security >#skip-networking >#skip-federated ># Replication Master Server (default) ># binary logging is required for replication ># log-bin deactivated by default since XAMPP 1.4.11 >#log-bin=mysql-bin ># required unique id between 1 and 2^32 - 1 ># defaults to 1 if master-host is not set ># but will not function as a master if omitted >server-id = 1 ># Replication Slave (comment out master section to use this) ># ># To configure this host as a replication slave, you can choose between ># two methods : ># ># 1) Use the CHANGE MASTER TO command (fully described in our manual) - ># the syntax is: ># ># CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>, ># MASTER_USER=<user>, MASTER_PASSWORD=<password> ; ># ># where you replace <host>, <user>, <password> by quoted strings and ># <port> by the master's port number (3306 by default). ># ># Example: ># ># CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306, ># MASTER_USER='joe', MASTER_PASSWORD='secret'; ># ># OR ># ># 2) Set the variables below. However, in case you choose this method, then ># start replication for the first time (even unsuccessfully, for example ># if you mistyped the password in master-password and the slave fails to ># connect), the slave will create a master.info file, and any later ># change in this file to the variables' values below will be ignored and ># overridden by the content of the master.info file, unless you shutdown ># the slave server, delete master.info and restart the slaver server. ># For that reason, you may want to leave the lines below untouched ># (commented) and instead use CHANGE MASTER TO (see above) ># ># required unique id between 2 and 2^32 - 1 ># (and different from the master) ># defaults to 2 if master-host is set ># but will not function as a slave if omitted >#server-id = 2 ># ># The replication master for this slave - required >#master-host = <hostname> ># ># The username the slave will use for authentication when connecting ># to the master - required >#master-user = <username> ># The password the slave will authenticate with when connecting to ># the master - required >#master-password = <password> ># The port the master is listening on. ># optional - defaults to 3306 >#master-port = <port> ># binary logging - not required for slaves, but recommended >#log-bin=mysql-bin ># Point the following paths to different dedicated disks >#tmpdir = "F:/Xampp/tmp" >#log-update = /path-to-dedicated-directory/hostname ># Uncomment the following if you are using BDB tables >#bdb_cache_size = 4M >#bdb_max_lock = 10000 ># Comment the following if you are using InnoDB tables >#skip-innodb >innodb_data_home_dir = "F:/Xampp/mysql/data" >innodb_data_file_path = ibdata1:10M:autoextend >innodb_log_group_home_dir = "F:/Xampp/mysql/data" >#innodb_log_arch_dir = "F:/Xampp/mysql/data" >## You can set .._buffer_pool_size up to 50 - 80 % >## of RAM but beware of setting memory usage too high >innodb_buffer_pool_size = 80% >innodb_additional_mem_pool_size = 4M >## Set .._log_file_size to 25 % of buffer pool size >vinnodb_log_file_size = 5M >innodb_log_buffer_size = 8M >innodb_flush_log_at_trx_commit = 1 >innodb_lock_wait_timeout = 50 >## UTF 8 Settings >v#init-connect=\'SET NAMES utf8\' >#collation_server=utf8_unicode_ci >#character_set_server=utf8 >#skip-character-set-client-handshake >#character_sets-dir="F:/Xampp/mysql/share/charsets" >[mysqldump] >quick >max_allowed_packet = 16M >[mysql] >no-auto-rehash ># Remove the next comment character if you are not familiar with SQL >#safe-updates >[isamchk] >key_buffer = 20M >sort_buffer_size = 20M >read_buffer = 2M >write_buffer = 2M >[myisamchk] >key_buffer = 20M >sort_buffer_size = 20M >read_buffer = 2M >write_buffer = 2M > [mysqlhotcopy] > interactive-timeout