Search the Community
Showing results for tags 'my.cnf'.
-
Please guys help me. I have a site with high traffic. Sometimes over 1k people online. I just got this brand new server because my other server was crashing all the time. I need to configure my.cnf and appache to handle the traffic without issues. Server stats. Dual Intel Xeon 5639 2.13Ghz - 2 Processors 12 Cores / 24 Threads 24GB DDR3 RAM Current My.cnf config: [mysqld] key_buffer=32M myisam_sort_buffer_size=64M join_buffer=2M sort_buffer=2M table_cache=2048 thread_cache_size=512 connect_timeout=60 wait_timeout=500 interactive_timeout=500 max_allowed_packet=16M tmp_table_size=128M max_heap_table_size=128M query_cache_limit = 2M query_cache_size = 512M query_cache_type = 1 #open_files_limit = 20000 thread_concurrency=16 max_connections=1000 log-slow-queries local-infile=0 connect_timeout = 60 Current httpd.conf config <IfModule prefork.c> StartServers 20 MinSpareServers 15 MaxSpareServers 35 ServerLimit 2000 MaxClients 2000 MaxRequestsPerChild 10000 </IfModule> <IfModule worker.c> StartServers 20 MaxClients 2000 ServerLimit 2000 MinSpareThreads 30 MaxSpareThreads 305 ThreadsPerChild 355 MaxRequestsPerChild 10000 </IfModule> Thanks in advance for the help.
-
Hello, The title says it all: MySQL is not using the hostname, user, and password that I have specified in my MySQL configuration file (my.cnf). I have a my.cnf file located at /etc/mysql and a .my.cnf file at ~/. The file in my ~ direcotry contains the following: [client] host = localhost user = root password = ***** In my php script, I have the following: try { $pdo = new PDO('mysql:dbname=grad'); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec('SET NAMES "utf8"'); } catch (PDOException $e) { echo $e; exit(); } When I run mysql --print-defaults I can see that MySQL has indeed loaded the host, user and password from my config file, but it does not seem to take effect as my php script gives me the following error: exception 'PDOException' with message 'SQLSTATE[42000] [1044] Access denied for user ''@'localhost' to database 'grad'' in /var/www/ ... MySQL version: 5.5.29-0ubuntu0.12.04.1 Web server: Apache 2.2.22 (Ubuntu) Any suggestions? Thanks!