Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql5]

137 questions
1
vote
2 answers

Measuring MySQL Replication Delay

How to measure MySQL replication delay between 2 MySQL servers ( 1 Master 1 Slave ) ? Given that two Xeon E5620 grade 1U servers are separate machine in same network segment, using MySQL Community Server 5.1 running in Ubuntu Linux Server 11.04.
Raptor
  • 1,001
  • 4
  • 19
  • 38
1
vote
1 answer

Maximum Concurrent Connection of MySQL server?

For the following hardware specification, how can I estimate the maximum concurrent connection of MySQL server? Intel Xeon E5620 2.4GHz 12MB L3 Cache 1066MHz 4GB x 3 1333MHz DDR3 ECC RAM 300GB SAS HDD (10K rpm) MySQL Server 5.1 Community…
Raptor
  • 1,001
  • 4
  • 19
  • 38
1
vote
1 answer

mysql cluster with PHP

I have a very common LAMP stack with about 6-7 machines with PHP and Apache and a few machines with MySQL server (master+slave, sharding) I am exploring options of moving to MySQL Cluster. I couldnt find a lot of information about it and reviews and…
Sparsh Gupta
  • 1,127
  • 7
  • 21
  • 31
1
vote
2 answers

Weird MySQL Errors After Distrib Upgrade (SQL 5.0 > 5.1)

Just updated Debian from Lenny to Squeeze on one of my servers. It hosts a MySQL server. Upgrade went fine, but afterwords, when MySQL starts up, it checks the databases to make sure they are okay. I am getting errors though for tables that are in…
ThaKidd KG5ORD
  • 329
  • 1
  • 7
  • 17
1
vote
2 answers

Nginx + php-fpm - recv() error

I get the follow error in the nginx log [error] 17734#0: *6643 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: [cut], server: [cut], request: "GET /venues HTTP/1.1", upstream: …
Ilya Biryukov
  • 153
  • 3
  • 6
1
vote
2 answers

What is the best way to take backup of live mysql database for MyIsam tables

I don't want to convert the tables to InnoDB what is the best way to take safe backup of my live site? I've gone thru many posts in this site. I think there isn't unless we down the site in case of MyIsam. For InnoDB we can use…
AgA
  • 181
  • 1
  • 10
1
vote
1 answer

Create a DB via SSH that will appear in CPanel

I have a linux VPS. I want to be able to create a database via SSH and still have access to it via CPanel. I tried creating a database using create database myDB and it did create it and I can see it when I use show databases; but I cannot see it…
webnoob
  • 465
  • 2
  • 16
  • 35
1
vote
1 answer

key efficiency 99.97% mysql

using the mysql workbench administrator - my key efficiency is at 99.97% i have read about adding 'key_cache_size=100M' to my.cnf and increasing it as needed is this the correct fix for the problem? im runing server 5.5.11 on server 2008 r2 , 24gb…
Jeff
  • 1,089
  • 5
  • 26
  • 46
1
vote
2 answers

MySQL Replication Server Error

My replication server showing the following error,Please go through the query and tell me your comments.The insert query is working in live DB server Properly , but showing error in replication DB server. Last_Error: Error 'Subquery returns more…
Jayakrishnan T
  • 298
  • 2
  • 8
  • 22
1
vote
1 answer

Limiting space for a MySQL user

I maintain a MySQL server. There is one user whose database size has very quickly grown enormously. Since he is using InnoDB, the /data/mysql/ibdata1 file has grown out of porpotions. I could mount a small partition and put his database there but…
Henno
  • 1,056
  • 5
  • 19
  • 33
1
vote
2 answers

Backing up MySQL DB wtih mixture of innodb and myisam tables

I have a large database (almost 1GB) and it has a mixture of innodb and myisam tables. Does anyone have any general tips when backing it up or more specifically the commands i should send to mysqldump. I see that i should lock myisam tables, and…
madphp
  • 379
  • 3
  • 12
1
vote
4 answers

"trying to connect via tcp://localhost:3306" problem with php mysql setup

I have installed the WAMp server on my windows XP machine. When I am trying to connect to DB it give the following error. Warning: mysql_connect() [function.mysql-connect]: [2002] No connection could be made because the target machine actively…
Avinash
  • 181
  • 1
  • 2
  • 9
1
vote
3 answers

MySQL won't start or won't installed

I'm trying to get a local LAMP setup on my Ubuntu desktop. I'm successfully got PHP install but I'm having trouble with MySQL If PHP tries to connet to MySQL I get this error: Warning: mysql_connect() [function.mysql-connect]: Can't connect to local…
Owen
  • 111
  • 6
1
vote
2 answers

There is the warning when I run database backup bash script

My database is 8GB When I run the database backup bash script, there is the warning/failure. They have appeared since 1 month ago Here are my warning/failure mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table…
Bach Do
  • 11
  • 1
1
vote
1 answer

Is it possible to install MySQL5.7 on Debian 10/buster?

I have tried two times and it always fails. According to this little guy debian stopped packaging mysql-client as of buster. I tried to cope with it by installing MariaDB but I struggle to find a useful tutorial. Then I tried with this tutorial but…
Revolucion for Monica
  • 111
  • 3
1 2 3
…
9 10