MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
2answers
2k views

php-cgi shows mysql modules but throws “Call to undefined function mysql_connect()” error

I have compiled PHP 5.3.6 from source on Mac OS X 10.6 using the --with-mysqli=mysqlnd option. The output of both php -m and php-cgi -m show the mysqli and mysqlnd modules. When I run a simple test ...
1
vote
2answers
220 views

Working setup for MySQL HA & LB

I have to setup High Availability and Load balancing for web(apache-tomcat+mod_jk) and MySQL(where all clients info is stored) server which are running on the same machine(ubuntu server). First I am ...
0
votes
1answer
476 views

Random Connections to MySQL refused (Error 111)

A Perl/CGI webapp that has been running fine for almost a year has started to randomly been unable to connect to a remotely hosted MySQL. The Error thrown is : Can't connect to MySQL server on 'xx....
1
vote
3answers
1k views

MySQL is 2 hours behind system time

Have a FreeBSD box with MySQL server on it. The system time is correct - For Denmark (Europe/Copenhagen) currently summertime. # date Fri Jun 17 12:09:56 CEST 2011 The MySQL server has timezone ...
1
vote
3answers
66 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
1answer
159 views

Can I Record Limit on MyISAM Table?

I have a big data in myisam so a table's disk space is got full so Can I Record Limit on MyISAM Table?
1
vote
2answers
13k views

Should I worry about mysql sleep status process in processlist

During website operation, in mysql process list, I see a couple of processes with the "command" column marked as "SLEEP". Should I worry? How to stop this?
2
votes
2answers
2k views

Mysql case insensitive table names

I had two database, one on windows server, and one on linux server, I moved the database to the linux server, but I faced wit a problem, On windows when a made a selection foe example SELECT * FROM ...
0
votes
1answer
252 views

MySQL database import generates unusable database dumps

I'm taking backup of my database and it has text field which contains following content: Original data: "Rock'n Roll" Database backup: "Rock\'n Roll" What it should be in backup: "Rock''n Roll" So ...
0
votes
2answers
173 views

Cannot log into mysql after invoking mysql from shell script

(My first question here, so if I am flouting any conventions, I apologize in advance!) This is my first attempt at creating a shell script. I am trying to create new databases and users and passwords ...
-1
votes
1answer
1k views

Completely locked out of MySQL via WAMP! [closed]

I've somehow managed to completely lock myself out of MySQL on WAMP. It seems all privileges are denied for all users. The only way I can get into MySQL is via the command prompt but without entering ...
2
votes
3answers
421 views

Need some advice for a busy mysql server

I have about 150 cron jobs running that process between 6 and 10 inserts every 3 seconds. There are LOTS of select statements happening every 3 seconds as well. My problem is, things work very well ...
1
vote
3answers
3k views

Problem moving a MySQL data directory to a new drive

I have an EC2 instance and am trying to move the mysql data directory from the default drive to another EBS volume. I moved the mysql directory in /var/lib/mysql to the new destination and then ...
0
votes
2answers
584 views

MySql is not picking up changes to my.cnf file on a custom Ubuntu AMI. How do I fix this?

I created an AMI from my running EC2 Ubuntu instance. I then brought it up, and MySql is not running the same way on this copied instance. 1) Changes to my my.cnf file are not getting picked up. 2)...
0
votes
1answer
64 views

MySQL Column Constraint

I need a table which will allow to insert values into a column with values greater than 10. When I tried in net, they suggested to create table in following way. CREATE TABLE test ( UID int(11) NOT ...
1
vote
2answers
914 views

What are ANY-user and information_schema on MySQL Server?

I have a few servers that still seem to have the default ANY-user and information_schema. I would delete it, but they are production servers. It seems very worrisome to me What is this Any user ...
1
vote
0answers
3k views

phpinfo reports no value for PDO MySQL driver

As per the title I'm having problems with PHP 5.2.10 and getting PDO MySQL to be recognised. My configure command contains '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-...
0
votes
1answer
986 views

MySQL Cluster ndb_mgmd error

I set up MySQL Cluster on Ubuntu. My ndb_mgmd.cnf file looked: [NDBD DEFAULT] NoOfReplicas=2 DataDir= /var/lib/mysql-cluster # Management Node [NDB_MGMD] NodeId=1 HostName=192.168.204.20 DataDir=/...
0
votes
1answer
340 views

A pseudo-Sql server to intercept and see all MySQL queries

I would like to setup a "pseudo-server" to intercept all the SQL queries made by my local application. The reason for that is that I can't administer the Mysql server, and it's difficult for me to ...
3
votes
1answer
199 views

MySQL think 'außer' equals to 'auser'

I tried to migrate some tables from one MySQL database to the other, but I encountered an error: ERROR 1062 (23000) at line 108: Duplicate entry 'außer' for key 'PRIMARY' And I tried to find why, ...
4
votes
2answers
1k views

Are Master-Master database collisions a problem even with auto increment?

I've done quite a lot of reading into this and I'm still I'm not sure where I stand. Am I going to get database collisions (and then corruption) with two Masters both receiving writes ? Now that ...
2
votes
2answers
200 views

More than one MySQL server

I have a growing website which now uses a single and ordinary MySQL server for its tasks. I wonder how and when should I migrate to more powerful servers or in other words when is the best time to use ...
-1
votes
1answer
243 views

Is it correct to say that using MySQL running on SSD disk on a server makes it comparable in performance to NoSQL Db? [closed]

As it is well known performance impact is quite significant when using the new SSD as opposed the old disk drives. If MySQL database including all the data is on SSD, how does that compare to NoSQL ...
2
votes
3answers
217 views

Load balancing - Multiple servers, different locations

I've been scaling out a service very rapidly, and have found a problem in the way I've been balancing the load. My servers do not need a perfectly even distribution, so I was simply using a round ...
0
votes
1answer
125 views

The purpose of mysql_secure_installation

Whenever I used to setup a server, I'd run: mysql -u root # Set the root user password for all local domains SET PASSWORD FOR 'root'@'localhost' = PASSWORD('my_password'); SET PASSWORD FOR 'root'@'...
-1
votes
2answers
74 views

mysql user- MySQL Server permissions

Just installed mysql on latest Ubuntu and i want to access /var/lib/mysql directory It seems there are permissions set for this user :mysql - MySQL Server but i do not have the password for it. What ...
0
votes
1answer
2k views

Enabling remote access to mysql on debian

I need to enable remote access for a specific user on a mysql server, running debian oldstable. Bear in mind I'm no SQL expert nor a real sysadmin. Logging in phpmyadmin and looking at the ...
3
votes
1answer
209 views

When I am root, “mysql” connects without a password, even though I've set one

When I am root, "mysql" connects without a password, even though I've set one: # mysqladmin -u root password 'whatever' # mysql -u root -p Enter password: (typing the 'whatever' above) Welcome to the ...
1
vote
1answer
76 views

MySQL Query log not getting purged

I had enabled MySQL Query Log for checking which queries are getting executed from our application at certain time interval. I wanted Logs to be refreshed for 3 days once, So I had enabled Expiry Log ...
15
votes
6answers
27k views

What should mysqld.sock contain, why don't I have it?

Does anyone know why my /var/run/mysqld/mysqld.sock socket file would not be on my computer when I install (or reinstall) MySQL 5.1? Right now, when I try to start up a server with mysqld, I get ...
1
vote
1answer
692 views

installing MySqldb on python2.6 Centos 5.5

I am getting this error when I build. running build running build_py copying MySQLdb/release.py -> build/lib.linux-i686-2.6/MySQLdb running build_ext building '_mysql' extension ...
1
vote
2answers
392 views

Error running any Java web project on my notebook

when I try to run any java web project I get this error. BUT this only happens on my notebook. I've tried on other desktop and other notebook on the same order and everything works well there but to ...
2
votes
1answer
1k views

Install MySQL on SSD, best mount options?

I want to install the mysql-server on my SSD, what are the best mount options for this? (/etc/fstab) What else I can do to increase the SSD Speed? My current configuration: /dev/sdc /ssd ext4 ...
1
vote
3answers
4k views

phpMyAdmin File Could Not Be Read

Whenever I try to upload a file to import into phpMyAdmin I get the following error: File could not be read phpMyAdmin is the only php script I am running on my server, and as such my php ...
6
votes
2answers
3k views

best practice for fixing mysql slow query log error 13

CentOS 5.5 MySQL 5.5 installed via a yum repository [ERROR] Could not use /var/log/mysqld.slow.log for logging (error 13). Turning logging off for the whole duration of the MySQL server process. ...
1
vote
4answers
883 views

Looking for the best way to backup Mysql

What's the most appropriate way to backup Mysql databases? I would like to have the backups in at least 1 hour intervals. I though mysqldump was the only option but It turns out there are other ...
3
votes
1answer
233 views

setting table_cache in line with opened_tables

My MySQL server is VERY busy. It has 750k opened tables. I have been reading that I should increase table_cache in line with opened_tables but I have no idea how I am meant to scale it? If I set ...
6
votes
6answers
4k views

MySQL, is there a way to tell when was database last changed/modified?

I'm creating MySQL dump of 5 databases every hour. 3 of those databases very rarely change, so creating a MySQL dump for those 3 dbs is pretty much a waste of time and resources. Is there a way I can ...
3
votes
1answer
167 views

MySQL Logging - Is it worth it?

If I were to enable MySQL logging by doing the following, what are the advantages and disadvantages? What do you do personally? general_log_file = /var/log/mysql/mysql.log general_log ...
2
votes
3answers
1k views

Mysql - which CPU is better?

I'm trying to speed up my mysql server. From what I read, mysql can only use 1 single core, at least when it's on the same connection and table. Right now I have 2 * Intel E5420 I'm wondering if it ...
4
votes
2answers
324 views

Is MySQL Cluster appropriate for a small, low-volume multi-homed system?

I'd like to multi-home a proprietary web-based application for a relatively small user base with modest dataset size. Scalability is not as much of a concern as extremely high availability. The ...
0
votes
4answers
17k views

MySQL Daemon failed to start

I've tried finding the solution to my error on multiple website, as well as other questions on serverfault. None have fixed this error for me. MySQL was working just fine up until I added the ...
4
votes
2answers
593 views

Rackspace cloudserver backup options

I recently signed up with Rackspace to host some database servers. I've got two MySQL servers set up, and have a method to create backups (using the Percona Xtrabackup and innobackupex tools). I've ...
0
votes
2answers
513 views

MySQL Continuosuly crahsing

I am continuously receiving below error in event viewer... from which it stop mysql service... This is the following error, Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module ...
1
vote
3answers
447 views

Mysql ibdata1 file

What happens if I delete the ibdata1 file and restart the server, my database is MyISAM, I used InnoDB before but now all tables are MyISAM. Will be a big problem if I delete this file. As far as I ...
0
votes
1answer
130 views

Revert all changes make to Mac OS X web sharing [closed]

I've been messing about with apache2 php and mysql today and I've taken a few wrong turns. I'd rather install XAMPP than try to figure out all the problems. I did a time machine backup a few days ago ...
1
vote
2answers
468 views

Merge data from two mysql server

I have two old mysql servers and now I bought a new server and I want to migrate the files to this server, my question is if I copy all those files to the new server will the mysql recognize this ...
0
votes
1answer
131 views

rubystack with existing MySQL

I want to install redmine, so i found convenient to try installing first bitnami RubyStack locally, however i do not want it to use its default mysql server, but i want it to use my already installed ...
0
votes
1answer
147 views

MySQL Optimization in Many Inserts Few Selects Environment

I am working with a MySQL database that is mainly used to do inserts and almost never selects. Unfortunately, the system is already deployed and working, 24x7 roughly 14k inserts/day, and I cannot ...
0
votes
1answer
259 views

Mysql Logging all deadlocks

I have a MySql DB that is encountering some deadlocks. I want the log all deadlocks, any thoughts of how to do this?