-1
votes
0answers
9 views

multiple refresh from browser server get slow to respond and it creates huge process for apahce

I have linode and i have hosted my website on that.. ? is my website i am using ispconfig and when i am trying to multiple refresh my site from browser.. it takes time to load.. i have tried ...
0
votes
0answers
66 views

Mysql not starting after upgrading debian squeeze to wheezy

I recently bought a VPS box with Debian Squeeze pre-installed as the OS. I upgraded to Debian Wheezy and most things work fine (e.g. apache). The problem I'm having relates to MySQL - which is just ...
1
vote
1answer
101 views

MySQL - The server quit without updating PID file

I have installed MySQL 5.6.16 on Debain 7.4. But i encountered problems with starting mysql, where every time i start mysql i get this error: The server quit without updating PID file ...
1
vote
1answer
152 views

Can't start mysql server

I'm facing problems installing a software package that depends on MySQL. During the installation it installs a MySQL server, but for some reason starting the services fails and thus the installation ...
1
vote
1answer
77 views

monit mysql server blocked because of too many bad connections

Is there any tweak for monit or another way to monitor whether one server can access mysql on another server? I tried it with monit but as you probably know, after 10 attempts, mysql blocks the ...
0
votes
1answer
182 views

Updating php5-mysql for MySQL 5.6 under Debian 7

After a lot of troubles installing MySQL 5.6 for Debian 7 (with ISPConfig) (FYI, I followed this tutorial : http://xmodulo.com/2013/12/upgrade-mysql-server-debian-ubuntu.html) my PHPMyAdmin shows me ...
0
votes
0answers
18 views

Extremely weird proftpd behavior

I have configured proftpd + mysql and it is working Its working perfectly despite the overcomplicated queries. However when I enable DefaultRoot ~ It stops working and somehow reverts to some ...
0
votes
0answers
21 views

MySQL Service allow local connections through hosts.allow

I have my hosts.deny set up as ALL: ALL but when I do this I can't seem to allow MySQL in hosts.allow. I need it just on the local network. I've tried: mysql: LOCAL mysqld: LOCAL and as a last ...
0
votes
1answer
100 views

Dovecot handshake failure, on Postfix success

I am trying to setup a Dovecot/Postfix structure, relying on a MySQL backend. I came across a problem with SSL configuration, and it's really tearing my hair out... Situation Dovecot listens on port ...
0
votes
0answers
20 views

pureftpd per domain mysql

I am trying to configure PureFTPd with mysql for a multiuser hosting. What i would like to accomplish is that each "client" is an account on the system, but each of those clients can have multiple ...
0
votes
3answers
64 views

Remote access forbidden (HY000) to specific mysql client

A MySQL server is located at central.hwcharts.com; it is the master of a basic master-slave replication which replicates toward host0.hwcharts.com, located on a different physical machine which ...
1
vote
2answers
89 views

MySQL shut down it self periodically

I recently bought 512MB, 2.2GHz, 20GB SSD - VPS Server and installed Debian Wheezy 64-bit and it is used as WEB Server. I have installed Apache2, PHP, MySQL, ClamAV, Anti-DDoS, Spam Assain, Postfix, ...
1
vote
0answers
56 views

LVS-DR and OpenVPN: returning packets not being routed into the vpn

i've set up a load balancer with ldirectord, and an active-passive mysql service managed by it, on two additional real servers. LVS is running in Direct Routing mode, so the client requests are ...
0
votes
0answers
121 views

MySQL from Deb changing configuration after installing perl packages?

This will sound silly, I'm sure. Here goes. I have a new installation of Debian Wheezy (Debian7). Instead of going with the aptitude installation of MySQL that right now holds v5.5.31 I went with the ...
0
votes
2answers
94 views

Apache2 Debian server falls. Out of memory

help me please with my apache problem. I got an droplet at DigitalOcean with 512mb of RAM (Debian). There are 3 sites on MODX CMS (works on php). Today morning as i think system discovered an out of ...
-1
votes
2answers
64 views

How to add support of bcrypt to mysql?

Following this answer mysql does not support bcrypt because system does not support them either. How to add support of bcrypt to Debian to MySQL?
0
votes
1answer
20 views

syscp cron_traffic.php needs 10 minutes to execute

I use syscp on debian and i noticed that this script is taking more than 10 minutes to execute: date ; /usr/bin/php5 -q /var/www/syscp/scripts/cron_traffic.php; date Do 5. Dez 12:09:09 CET 2013 Do ...
0
votes
2answers
55 views

freebsd-like jail with debian for mysql (updating db schema)

I have debian box with big database. I want to do a lot of risky operation with this database. Its about updating the sofware which works with this db. I can stop database for 5 min, but not for ...
0
votes
0answers
33 views

Pinpointing PHP performance problems after upgrade

I have done an upgrade of my server from debian 6 to 7.2, along with moving from PHP 5.4 with APC to PHP 5.5 with OpCache and APCu (both running as php-fpm). MySQL and Apache are still the same ...
0
votes
2answers
90 views

Is there a debian-sys-maint equivalent in centos?

I am using debian-sys-maint as practical way to do database dumps in our debian systems, somenthing like this: mysqldump -u debian-sys-maint -p`cat /etc/mysql/debian.cnf | grep password | tail -n 1 | ...
0
votes
1answer
58 views

Debian mysql-proxy reserved connections

I was looking in too the mysql-proxy configuration, and decied to install it in order to make an access point to my servers whenever they reach high peak, however i want to have 5-10 reserved ...
0
votes
0answers
82 views

postfixadmin doesn't create table but create database

Already i downloaded and installed postfixadmin ,But for version compatibily, i' forced to install from debian repository. I prevent to wonderful thing, It is installed successfully , creates ...
0
votes
2answers
150 views

autossh -> private key without passphrase

I would like to tunnel a mysql database. So I thought I use a private key without a passphrase to make it reboot friendly. The problem is, openssh still asks me for a passphrase and if I leave it ...
0
votes
1answer
132 views

Mysql remote connections very slow - host lookups already disabled

I followed every instruction about this issue and nothing helped. Remote communication with MySQL server takes 4-30 seconds on simple query like select 1 from table_name and connection attempt often ...
-1
votes
1answer
58 views

Python cant connect to local MySQL server through socket [closed]

I have a python script which is designed to add things to a MYSQL database. The error I get is this: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock I've checked the ...
2
votes
2answers
1k views

How to reinstall broken mysql package

Trying to fix a broken mysql installation, this happened after upgrading from debian 6.0 to 7.0. I have the dotdeb.org packages in my /etc/apt/sources.list. root@ginger:/var/log/mysql# apt-get ...
0
votes
2answers
576 views

OpenVZ MySQL InnoDB won't start

I have a OpenVZ Server with 4GB RAM and have tried to install MySQL on several distros (Ubuntu 12.04 64Bit, Ubuntu 12.10 64Bit, Debian 7 64Bit) and I always get the same errors: 130718 6:57:27 ...
0
votes
2answers
461 views

mysqldump isn't able to export a specific database, phpMyAdmin crashes

I'm experiencing problems with a database on my server (Note: All other databases work fine). Once I try to export it with mysqldump I get this error: # mysqldump -u root -pXXXXXXXXX databasename ...
1
vote
5answers
3k views

After installing Mysql 5.6 the server can't start

The mysql server is installed on a clean install of Debian 7 Have tried this serveral times each time on a clean install of Debian installation # apt-get update && apt-get upgrade # ...
2
votes
1answer
6k views

How to install Mysql 5.6 on Debian 7 wheezy

I'm trying to install Mysql 5.6 on Debian 7 Wheezy.. After installing the mysql database/folder /var/lib/mysql/mysql is empty # groupadd mysql # useradd -r -g mysql mysql # apt-get install libaio1 # ...
0
votes
0answers
93 views

Performance drop after hours of runtime - how to detecting bottleneck

I am running a local database server for 1 client machine. My DB server runs redis (version 2.6.13) and mysql (5.5.31-30.3-log Percona Server (GPL), Release 30.3). I have 1 Client machine that runs a ...
-1
votes
2answers
150 views

How to regain access to myql server and dump database?

We retake the management of our server and now we need to make some reverse engineering. We gave to an external company the development of our new Website and they need a dump of database from old ...
-1
votes
3answers
105 views

Reinstall mysql and keep mysql data [closed]

In Debian, /root/bin folder was deleted. The biggest problem is that mysql is missing. When I type: > mysql -bash: mysql: command not found I have all data in /var/lib/mysql. How do I install ...
0
votes
3answers
2k views

Failed mysql upgrade to 5.5 on debian wheezy

When upgrading debian squeeze to wheezy, the upgrade of mysql to mysql-server-5.5 fails: # apt-get dist-upgrade -u ... Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ... [ ok ] Stopping MySQL ...
-1
votes
3answers
1k views

How to install MySQL 5.6 on Debian (wheezy or squeeze) and make it work

How to install MySQL 5.6 on Debian (wheezy or squeeze)? The package is on mysql site but what's next? Thanks for first answers. I actually installed it but it won't work.
0
votes
1answer
142 views

PHP processes keep overwhelming my server, eating up the CPU and making it lock up :(

I have a Debian Squeeze Lighttpd server with PHP and MySQL, and also with XCache and Varnish set up. I am quite new to this, but have tried as hard as I can to resolve this problem with no success. ...
1
vote
2answers
533 views

PHP mysqlnd on Debian 6

I've installed php5-mysqlnd via: apt-get install php5-mysqlnd This is a brand new virgin Debian install with just apache2 and php5 via: apt-get install apache2 echo "deb ...
0
votes
2answers
250 views

Apache and MySQL doesn't start at boot

I am running Debian 6 on a server. On this server I want to have an instance of Apache2 and MySQL started when the system boots. For this purpose I know there are the init.d script and the symbolic ...
-1
votes
1answer
108 views

Can't install anymore MySQL on debian after deletion of various folders [closed]

So here is my story: I've been thinking "Why am I using MySQL 5.1, if there is already 5.6 out?", therefore I wanted to install 5.6 on my debian root server(it is a playground/testserver, not a ...
0
votes
3answers
5k views

MySQL keeps crashing: InnoDB: Unable to lock ./ibdata1, error: 11

I have a simple webserver (Debian 6.0 x86, DirectAdmin with 1 GB of memory and still 10 GB free space, mySQl version 5.5.9), however the mySQL server keeps crashing and I need to kill all mySQL ...
1
vote
3answers
659 views

Error installing mysql, any way to fix it?

I was installing mysql with apt-get install mysql-server (like I always did) before that I had done an apt-get update (I am using Debian 6), and when I installed I found this problem, pretty common as ...
2
votes
1answer
134 views

How can I isolate my Apache and MySQL installations on the same server? [closed]

I have a 8GB RAM Linux server which will be running Apache and mysql. First I was thinking of chrooting mysql (and apache) but then thought of putting mysql in a virtual machine on the same server, ...
4
votes
1answer
263 views

Ran out of disk space, how to tar without creating copy

I am at 98% of an 8GB SSD, and I have a 3 GB mysql data that I need to gzip and or tar and then download it, so then I can delete it. How can I tar or gzip the sql (or the mysql tables) so that that ...
0
votes
1answer
60 views

MySQL table records changes every second

I was using a PHP script running on background to grab data and insert them into the mysql database... i stopped the PHP from logging and checked the table records, i found that its being changed ...
0
votes
2answers
110 views

MySql: how to empty the database

So, until today we were testing our website. Now we want to switch to the next level and we need to empty the db in order to do that. This means that we would like to be at the starting point, with ...
-1
votes
1answer
699 views

MySQL partition “full”? [closed]

I have a server that runs Debian 6.2, with Apache, PHP5, and MySQL. Well, I hadn't done anything with MySQL at all so far, just Apache and PHP; I must have installed it (mysql-server) at some point ...
0
votes
1answer
29 views

mysql client binary size zero

I was using the openpanel-mod-mysql module when I kept getting weird error messages. Then I set out to execute the commands manually and got no response from mysql. I mean, when I typed in mysql, ...
3
votes
1answer
370 views

MySQL master-slave lag replication

Our company is using TokuDB on production and we are having a lot of problems trying to mitigate lag on our slave. Is very strange, because we're talking about very few rows... but with a few data it ...
0
votes
1answer
234 views

MYSQL Permission: Access denied for user 'debian-sys-maint'@'localhost

Got a problem with a mysql server installation on Debian. (Not my server so I have no idea what caused this...) Installing new applications that add a database fail with error: ERROR 1045 (28000): ...
1
vote
2answers
550 views

After adding skip-innodb mysql doesn't start

I am trying to setup these values: #skip-bdb #skip-locking #skip-innodb When I add them to /etc/mysql/my.cnf and even if I turn ON of of, them after I do the service restart mysql fails to start, ...