All Questions

Filter by
Sorted by
Tagged with
0
votes
3answers
445 views

Configuring the max_connections setting in MySQL

I've gone through a number of docs and forums but can't quite find the right answer for how to determine the number of maximum connections I should set. I tried using MySQLTuner, that gave me: ...
1
vote
2answers
2k views

Should I turn off GTID to fix this error?

Recently, a query has started failing. It is a query in the Magento software core (not a module) that Reindexes Catalog Search. I have receive the following error. Catalog Search Index index ...
1
vote
0answers
80 views

Specific install of MySQL 5.6

I'm download this version mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz. I would like to make a specific install for example : basedir = /sgbd/mysql/5.6/mysql datadir = /data/mysql/MYSDTESTP02 socket = /...
0
votes
1answer
69 views

Frequent Corrupt Indexes in MySQL 5.6. Is this a MySQL bug?

I´m having problems with mysql indexes with INNODB getting corrupted. Initially I solved it by rebuilding the tables but now the tables are to large to rebuild, and i´m tired of mysql not showing ...
4
votes
1answer
410 views

Optimizing MySQL 5.6 for unit tests

We have a MySQL instance for unit tests. Our unit tests work very heavily on MySQL. Therefore, we put /var/lib/mysql dir in tmpfs file system because we don't need persistent data in unit tests. Our ...
3
votes
1answer
1k views

Mysql high cpu usage - cpanel [closed]

After an update from whm, I see a high CPU usage from MySQL (5.6). my.cfg: [mysqld] slow_query_log=1 slow_query_log_file="/var/lib/mysql/slow-query.log" long_query_time=1 skip_name_resolve ...
1
vote
2answers
6k views

Mysql Server 5.6 Mysqld high memory consumption

I have MySQL Server 5.6 installed in a development machine with these specs: RAM: 4 GB Windows 7 Professional 64 bits Intel Pentium CPU G630 @ 2.70 GHZ Since I installed the MySQL Server, the ...
0
votes
0answers
546 views

Unable to install mysql 5.6.17and configure mysql on Win 7 -64 bit Os

Already seen this post but not my type of question as iam stuck in the installation itself I am trying to install MySQL 5.6.17 on Windows 7 64-bit Operating System. Everytime I try I am stuck in this ...
1
vote
1answer
584 views

MySQL Server 5.6 only runs when making swapfile

I am new to MySQL server. I have set up a dedicated MySQL server. I am aiming to install MySQL server version 5.6 and since version 5.6 is not available on the Ubuntu repository, I have to upgrade it ...
1
vote
2answers
12k views

How to force higher values of open_files_limit or table_open_cache?

I'm having a frustrating problem where setting my.cnf to values higher than I currently have them does not 'take'. This is MySQL 5.6.14 on MacOS X 10.8.3 I'm trying to address dropped connections ...