Questions tagged [mysql5]
137 questions
0
votes
1 answer
Problem with high mysql cpu load on Ubuntu server
I am running MySQL 5 on a production Ubuntu 8.04 server. Two separate php based sites are served, both of which involve intensive mysql queries.
What I noticed is that when I request a page on the first site, which causes a 100% cpu load by mysql…
Stathis
- 1
0
votes
2 answers
I can't enable binlog in MySQL
I am trying to enable binary log in order to create master slave for my DB.
MySQL version is 5.1.41-3ubuntu12.10-log
I have added this to my.cnf
log_bin = /var/log/mysql/mysql-bin.log
expire_logs_days = 1
max_binlog_size = 100M
and…
Alaa Alomari
- 638
- 6
- 19
- 37
0
votes
1 answer
How get mail alert from mysql server
How to get mail from mysql, if directly root or someone editing or updating to particular database it should trigger a mail and log the edit.
I have tried Triggers but its not working,
Server specifications:
OS : ubuntu 10.04 64bit
mysql :…
sush
- 113
- 4
0
votes
2 answers
mysql performance tuning, windows server 2008 R2
is there a script/program that I can run for mysql server 5.5 running on windows server 2008 to help optimize the server performance?
the system specs:
2 es5620 @ 2.40 ghz processers (4 cores each)
24 g/b ram x64
server 2008 R2
15k hdd x4 configured…
Jeff
- 1,089
- 5
- 26
- 46
0
votes
3 answers
what is the default Password Policy in mysql 5.0?
what is the default Password Policy in mysql 5.0 ?
user79483
- 411
- 1
- 7
- 9
0
votes
1 answer
Why is MySQL dropping my foreign key actions?
Cross posted from Stack Overflow, since this is probably more of a server admin type of issue:
Running MySQL v'5.1.12-beta-community-nt' on Windows 2k server.
I have a group of 5 tables (a,b,c,d,e) where 'b' has a foreign key to 'a' with the action…
invertedSpear
- 153
- 1
- 6
0
votes
3 answers
Extreme fine tuning MySQL performance wise on a Linux server
I would like to know all of the key points where MySQL can be fine tuned performance wise
on a Linux server through my.cnf or through other methods, libraries and tools. Tips and tricks and shady stuff welcome too.
Since a target server architecture…
Shinnok
- 339
- 2
- 9
0
votes
1 answer
mysql 5.1 skip skip-networking param
I don't know why my MySQL doesn't read the my.cnf file.
I wrote a commented line # skip-networking on my.cnf, restarted mysqld and when exec
#ps aux | grep mysql
returns:
root 7737 0.0 0.0 7184 812 pts/4 S+ 12:20 0:00 grep…
alvaro.canepa
- 101
- 2
0
votes
3 answers
install mysql on freebsd
How to install Mysql on freebsd , i have tried a lot but after i am getting lot many error so i have removed it , but now i want to reinstall it so , can anyone suggest me the link / commands to install it ?
rawman
- 13
- 3
0
votes
1 answer
Is there any problems in mysql5.1 server with mysql5.0 client?
We are going to replace DB servers with mysql5.1.
Our dba team recommend that using mysql5.0 client
because, they have enough skill and know-how with mysql5.0 client.
Is there any problems in mysql5.1 server with mysql5.0 client?
freddiefujiwra
- 1,667
- 5
- 25
- 34
0
votes
1 answer
MySQL 5.0 broken on snow leopard. How to get data into new 5.1 version?
I've seen some similar questions but I am still a bit unsure on what I need to do. I had Mediawiki installed on Leopard. I then Upgraded to snow leopard which broke MySQL.
Everything seems to indicate that I need to backup the db then import it.…
Jason Tholstrup
- 103
- 2
0
votes
1 answer
MySQL slow/down under heavy load
MySQL server is keep crashing on a dedicated server running also apache/php. I am not a MySQL PRO so I need some experts suggestions.
Innodb and MyISAM engines both are used in the website but Innodb is heavily used.
From WHM phpmyadmin I found…
user55751
0
votes
0 answers
Disable auto reconnect for remote client connections in mysql
I use below version of MYSQL in my DB server.
root@XXXXXX-test-server:~# mysql -V
mysql Ver 14.14 Distrib 5.6.16, for debian-linux-gnu (x86_64) using EditLine wrapper
root@XXXXX-test-server:~#
When I close remote connections from server side…
0
votes
1 answer
why mysql bin logs are not expiring even though expiry was set
I am using 5.7.37-log MySQL Community Server.
my mysqld.cnf looks below:
server_id = 11
log_bin = bin.log
log-bin-index = bin-log.index
binlog_format = row
max_binlog_size = 100M
socket = mysql.sock
expire_logs_days = 1
when i check my logs they…
santhosh
- 103
- 4
0
votes
0 answers
mysql_upgrade / mysql_check fails with unknown database; where are database names stored (capitalization inconsistency)?
Just upgraded my server machine from freebsd 11.4 to freebsd 12.4.
Then ungraded the installed packages, in particular mysql57-server.
The server is started from a particular user account.
When I try to run mysql_upgrade, I get this:
Checking if…
Gary Aitken
- 123
- 6