Questions tagged [mysql5]
137 questions
0
votes
1 answer
MySQL 5.0 not logging aborted connections in general log
I know there is a bug in MySQL 5.0 which prevents aborted connections from being logged in the error log (http://bugs.mysql.com/bug.php?id=24761).
However, aborted connections should still be logged in the general query log. When I tried configuring…
blizz
- 1,134
- 1
- 26
- 47
0
votes
1 answer
Increase the speed of mysqldump
Are there any flags or tricks to speed up mysqldump for backups? Here is what we are currently using:
mysqldump --skip-opt --flush-logs --routines --triggers --allow-keywords --create-options --add-locks --quick --single-transaction…
Justin
- 5,328
- 19
- 64
- 84
0
votes
1 answer
Do global logging settings in MySQL5 stick after service restart?
Want to execute this on MySQL 5.0:
set global log_warnings = 2;
Will the setting stick after a mysqld service restart?
blizz
- 1,134
- 1
- 26
- 47
0
votes
1 answer
Installed Windows 8.1, MySQL service disappeared and all MySQL data/settings gone
This weekend, I updated a Windows 8 workstation to Windows 8.1. This was a development workstation that had a locally hosted MySQL 5.6 instance used for web development work.
After the update finished running, I discovered that the MySQL service…
Josh
- 287
- 1
- 3
- 8
0
votes
2 answers
MySQL consuming all system memory on INSERT ... SELECT
The mysql daemon is getting killed because Linux is reaching out of memory:
Oct 24 07:41:23 kernel: [82297.673701] Out of memory: kill process 13816 (mysqld) score 1839626 or a child
There is a link with some workaround on this.
That…
siete
- 23
- 5
0
votes
1 answer
Unable to adjust php.ini max upload size directive on Centos 6.3
Currently i'm setting up Centos 6.3 (64 bit) on vm and installing Wordpress:
Already adjust /etc/php.ini but seems like overwritten by other settings.
Suspect this is due to selinux feature. My goal is setting up all Wordpress with all feature…
Ivan Slaughter
- 113
- 4
0
votes
2 answers
Queries going to mysql server even when no one is connected to it
I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to have an abnormal amount of queries being run in…
coderkane
- 101
- 1
0
votes
1 answer
PHP connection for Mysql is very slow in another server
Few days ago, we moved our mysql database to another host because of some limitations with our current host. Everything is fine (Seem same performance and speed on our PHP framework based website) except one script that executes a mass update…
codelogn
- 103
- 4
0
votes
1 answer
What can I do with corrupted DB in InnoDB format in this case?
guys,
I have a big problem. There is one server with CRM database. I corrupted it probably and don't know what to do.
ls /var/lib/mysql/sugarcrm/
accounts_audit.frm address_book.ibd contacts_audit.frm emails_email_addr_rel.ibd …
Evgenii Iablokov
- 660
- 2
- 9
- 15
0
votes
2 answers
Mysql 5.5 is not installed in CentOS 5.7
I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum --enablerepo=remi,remi-test list mysql…
Bathakarai
- 121
- 3
0
votes
2 answers
How to proceed setting up a secondary mysql linux slave?
I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the database.
I am thinking of below options:
Shutdown…
Boolean
- 533
- 1
- 4
- 10
0
votes
3 answers
MySQL Upgrade RPM
I have a centos5.5 system and have MySQL 5.0.27 install. Now I want to upgrade this to MySQL 5.5.28(Latest). I have two questions,
What is the difference between RPM(Redhat) which is recommended and Generic binary tarball. Do they have performance…
Manish Mudgal
- 109
- 5
0
votes
2 answers
MySQL is converting MyISAM tables to INNODB automatically
I recently upgraded MySQL server on CentOS 5 with MySQL 5.0.96
After upgrade when i am trying to import old database dump which has got both MyISAM and INNODB tables in a single database, MySQL is converting all MyISAM table to INNODB.
Am not sure…
0
votes
2 answers
Mysql - Find out which Database a particular table is present
How would I find out which Database a particular table is present in MySql ?
Mysql version is
+----------------------+
| version() |
+----------------------+
| 5.1.35-community-log |
+----------------------+
As I am having around 25 DB…
Ahn
- 181
- 3
- 5
- 13
0
votes
1 answer
why does mysql have so many more open and fragmented tables than tables in the DB?
I've been working making our database run a little smoother and had good results over the past week. But there are still some things I dont understand.
For one thing, the database has 25 tables. But mysql status shows 512 are open:
mysqladmin…
karmet
- 209
- 1
- 2
- 14