0
votes
1answer
28 views

Error changing mysql 5.6 default port

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306. I've tried in mysql 5.5 and it worked fine. C:\Archivos de programa\MySQL\MySQL ...
0
votes
1answer
27 views

Check if MySQL configuration was applied

I'm performing some heavy MySQL operations at my VM and constantly getting the following error: SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size I ...
0
votes
2answers
407 views

Pure-FTPd do not login via mysql

I've got server on Ubuntu 12.04.3 LTS. I need to install Pure-FTPd with MySQL authentication. I'm installed pure-FTPd by typing "apt-get install pure-ftpd-mysql". It was installed. So, there's my ...
0
votes
1answer
609 views

MySQL, bind-address, Windows, Error 1067 my.ini

I trying to set alternate IP for gain access to MySQL Server (accessing from a PC with IP 192.168.1.20) in the file: my.ini MySQL starts without problem, when in the configuration file, in the ...
3
votes
2answers
210 views

Environment Varibales in MySQL configuration file?

It is possible to use environment variables in an Apache .conf file, but what about MySQL, is there a way to use them in the MySQL configuration file (my.ini/my.cfg)? The closest thing I could find ...
1
vote
1answer
225 views

ProFTPd MySQL query %u resolves to proftpd, not username

I am trying to use ProFTPd's MySQL configuration to set up FTP login to my server. I have a SQLNamedQuery that is used to get the user info from the database (see Setting up ProFTPd with default home ...
0
votes
1answer
180 views

How do I limit sender domain for mail sent to specific forwarding addresses in Postfix?

I presently have a Postfix installation happily delivering mail (webmail/IMAP) for 100+ users at our company, broadly divided among several domains (sales, operations, management, etc). Recently, ...
0
votes
1answer
141 views

Server Recovery from Denial of Service

I'm looking at a server that might be misconfigured to handle Denial of Service. The database was knocked offline after the attack, and was unable to restart itself after it failed to restart when the ...
1
vote
0answers
1k views

mysqld_safe Can't log to error log and syslog at the same time. Remove all --log-error configuration options for --syslog to take effect

When I'm trying to install MySQL 5.5 community edition on my Ubuntu 10.04 by compiling the source code, I met the following problem: $ fg % 1 sudo ../bin/mysqld_safe ...
1
vote
1answer
112 views

Recommended Configuration to setup Tomcat 7 on windows OS

I have created a small web application using java/jee which will be deployed in LAN environment. I want to know the recommended hardware configuration. Details are as follows 1) Expected number of ...
0
votes
1answer
642 views

MySQL slow query log logging all queries

We have a MySQL 5.1.52 Percona Server 11.6 instance that suddenly started logging every single query to the slow query log. The long_query_time configuration is set to 1, yet, suddenly we're seeing ...
0
votes
1answer
138 views

Connecting to external MySQL server from phpMyAdmin

How can I connect to external MySQL server to which I have granted access for my IP. What I have is: A website FTP link (like: ftp.domain.com) MySQL username and password Granted access to the ...
0
votes
1answer
2k views

How to disable LOCAL INFILE in MySql 5.5 Ubuntu 12.04

Cannot disable LOCAL INFILE ( for security reasons ) in mysql Ver 14.14 Distrib 5.5.25a, for debian-linux-gnu (i686) using readline 6.2 on ubuntu 12.04; Here is my /etc/mysql/my.cnf [client] port ...
0
votes
1answer
193 views

Sharing Mysql Workbench configuration among multiple machines

Suppose I have many employees who connect to the same set of about 20 or so changing mysql servers using Mysql Workbench. I want to keep the connections, and other configuration info synchronized ...
1
vote
1answer
77 views

Which section of the MySQL configuration can a variable be placed under?

I would like to find out under which section of the MySQL configuration file variables can be used. For instance I can place bind-address under [mysqld] or [server] which works, but it doesn't work ...
3
votes
4answers
1k views

How to config mysql-server for heavy load

Im in the process of setting up a new database server. I have been running a few mysql database servers before and it has been working okay. But i would like to hear the recommended setup for my ...
0
votes
1answer
718 views

Safe conversion from one InnoDB(ibdata) file to innodb file per table

I have MySQL database with tables on InnoDB engine. But server is configured to use only one file ibdata0 without parameter innodb_file_per_table. I want to change this without making dump and restore ...
0
votes
1answer
305 views

Installing Sphinx on Mac OS with XAMPP

We have: Sphinx 2.0.3 Mac OS 10.6.8 XAMPP 1.7.3 (with MySQL 5.1.44) Here is PATH: user:sphinx-2.0.3-release user$ echo $PATH ...
0
votes
1answer
155 views

Setting up a dedicated mysql server

I got a dedicated VPS and installed mysql on it(I am new at this). Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when ...
0
votes
1answer
52 views

How to retrieve all MySQL settings?

I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application ...
2
votes
1answer
1k views

Changing the MySQL datadir location to a mapped drive under WAMP

I have a WAMP server running on Windows 7 and I want to move the mysql data files to a network share (A NAS device). I stopped the WAMP server, created a drive letter mapping to a share on the NAS, ...
2
votes
1answer
730 views

MySQL : max_allowed_packet Greater than 1 GB is it possible?

In the field of Digital forensic , a packet size of 1GB is very common and I am getting trouble. Using in-house python script , we extract text out from archives , some files are as big as 4 GB and ...
5
votes
1answer
1k views

16 Cores 12 GB RAM Dedicated MySql Configuration

I have a dedicated 16 Cores 12 GB RAM Mysql server which is performing quite badly since I configure it for a 16 GB server and I guess that explains why in the world the site now takes more than 500 ...
4
votes
1answer
274 views

Mysql InnoDB table size performance

I have a table that is closely approaching 2 million records. This table stores a history of transactions. This is on a high traffic website but also the table is not accessed regularly. We ...
1
vote
3answers
611 views

MySQL slave reporting incorrect values for Seconds_Behind_Master

I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which ...
0
votes
2answers
1k views

my.cnf values not applying - Optimizing mysql on centos Lamp

I have checked for other occurences of my.cnf and ive found only one occurence /etc/my.cnf. I then went ahead to fix in my values eg query_cache_size etc. after saving and literally rebooting, the ...
3
votes
1answer
198 views

Document and best practices for configuration of a dedicated server (Centos) to serve just one website

I have just bought a dedicated server and they provide me a IP address, access info as root and machive with Centos 5. I would like to serve my django app in that machine but because I have no ...
1
vote
1answer
4k views

MySQL config and optimization

Here is the info for my server Giga Dedicated 6-Core: Intel Core i7 (6 x 3,20GHz) 24 GB RAM 160 GB SSD + 2000 GB HDD I have CentOS 5.6 (64bit) installed and Plesk Panel 10 Apache version is 2.2.19 ...
0
votes
1answer
36 views

help in configuration of mysql 5.5

i am trying to install mysql 5.5 in my windows 7 32bit i have antivirus quickheal with a firewall my problem is i am not able to configure the mysql properly this all error which i am facing ...
2
votes
4answers
3k views

Is it safe to open port 3306 in Firewall for external MySQL Connection

This may be more of a server question, but it's development related, and since I'm a developer I hope it's appropriate here. I want to connect to a MySQL DB that is hosted with an ISP using something ...
1
vote
3answers
65 views

I am concerned with mysql configuration is not optimized enough for doing a good job, how to tell?

I want to know the basic parameters/configuration for mysql to work great. What are they? How to determine? Using phpmyadmin, the status params marked red color seems needed to alter to optimize, ...
0
votes
2answers
628 views

can't connect to MySQL from localhost on Centos 5

I have a fresh install of Centos 5.5 on a new VPS and MySQL seems unable to resolve the keyword 'localhost' - if I use 127.0.0.1 instead it works fine. I checked the /etc/hosts file which is as ...
2
votes
2answers
7k views

Setting “max_allowed_packet” — commandline vs config?

What is the difference between setting the max_allowed_packet via the MySQL commandline using: set global max_allowed_packet=100000000; And setting it by editing the MySQL my.ini (Win) or my.cnf ...
0
votes
1answer
2k views

How to is MySQL's “net_buffer_length” config: viewed and reset?

Attempt to see the "net_buffer_length" config before resetting it: mysql> show variables like "net_buffer_length"; +-------------------+-------+ | Variable_name | Value | ...
2
votes
1answer
1k views

Attempted to edit MySQL service config and getting “Access Denied”

As a follow-up to this question, I'm attempting to edit the "my.ini" config file for the MySQL service. I've stopped the service, opened the file, made the edit, and attempt to save it -- at which ...
0
votes
1answer
279 views

Simple MySQL query locking up until database restart

I have a very simple query that runs in 216ms on my development machine but was taking more than 45 seconds on my production server, that is, until I restarted MySQL there: UPDATE `forum_categories` ...
0
votes
2answers
221 views

What is the best apache configuration for me?

I started to a new job. And my mission on servers which is not my work :( We have around 200 websites which use php - mysql. netstat -an|grep -c :80 is around 500 24GB ram with 2 E5420 Cpu Load ...
1
vote
1answer
2k views

MySql service stops under 2008 r2 x64

I have installed MySql 5.5 server under windows 2008r2 x64 Apparently I can see that MySql service stops even if is configured to start automatically What can I do to find out why this is happening? ...
2
votes
1answer
8k views

How to set query_cache_size and join_buffer_size in my.cnf file?

I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to ...
1
vote
3answers
4k views

set open_files_limit

When I set open_files_limit = 16k in both: /etc/security/limits.conf and /etc/mysql/my.cnf ulimit -n 16344 but in mysql: show variables like 'open_files_limit'; open_files_limit: 4096 So how ...
2
votes
5answers
359 views

MySQL goes away when traffic volume spikes

I have 2 servers running 1 website. Server #1 is dedicated to Apache, serving the website files to the Internet. Server #2 is dedicated to MySQL, serving the database to the Server #1. Gigabit ...
1
vote
1answer
196 views

Problem in Installing Wordpress

I try to install Wordpress in a Windows Client with WebPI which provided by Microsoft. I had tostop installation process 3 time and installing PHP and mysql Extention manually. but everytime I ...
0
votes
1answer
1k views

VPS 512 MB RAM with WordPressMU comes to consumes lots of memory

I have googled for days and gathered all optimization suggestions and tried. My sites are not getting any high hits. May be like 100 hits per day [all my sites combined]. Here are my specs I have ...
0
votes
2answers
1k views

How to log error queries in mysql?

I know that there is general_log that logs all queries, but I want to find out which query has an error, and get the error message. I have tried running an error query on purpose, but it logs as a ...
0
votes
3answers
213 views

RAID options for a LAMP web server

I'm due to set up a LAMP box with four drives and a RAID controller to act as a web server. The drives are 146Gb SAS, and the machine has two quad core processors and 16Gb RAM. There will be very few ...
1
vote
1answer
314 views

What is the difference betwen mysql and mysql-community?

In Gentoo, what is the difference between mysql, mysql-community, and mysql compiled with --enable-community-features?
1
vote
1answer
1k views

Need help configuring pacemaker

I'm trying to configure a 2-node openais / pacemaker cluster, and finding information / tutorials very difficult to come by. My goal is to set up 2 MySQL servers in a master-slave replication ...
6
votes
1answer
7k views

Choosing a value for wait_timeout & interactive_timeout in MySQL config?

We have a live server that's being hit hard so we're tying to optimise everything we can. We ran the MySQLTuner script on it (http://mysqltuner.com/) which tells us we should set a value less than ...
0
votes
1answer
892 views

Compiling PHP 5.1.6 with PDO MySQL

UPDATE I Asked this over on StackOverflow as I hadn't got any answers on here at the time. Here's the link to the answers for completeness' sake. I'll like that page back over here once I've tried ...
2
votes
2answers
639 views

MySql server connection problem

We've recently begun to have some downtime due to our database server (MySql) stops responding/refuses connections. We get the following (a lot) when we monitor with mytop: 5033 unauthent ...