MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

2
votes
2answers
3k views

How do I install MySQL with –with-federated-storage-engine on Ubuntu

Well honestly the title says it all. I am new to server install and stuff and basically want this for testing purposes for a web app I am building. I have ubuntu up and running but want to get mysql ...
3
votes
2answers
169 views

How can I verify from the command line that all of the tables in my DB are InnoDB?

How can I quickly verify from the command line that all of the tables in my DB are InnoDB?
0
votes
2answers
4k views

Restore MySQL database dump on Windows machine using command line

I have mysql installed on my machine, and I have an empty database my_database. I'd like to restore a database dump, originally from my shared server, into this empty database. The database dump is ...
1
vote
1answer
462 views

how to restore access to MySQL after deleting all privileges?

Ok, I know I'm stupid. I deleted all privileges to MySQL, I have access to root account on host. Is there any way to add account to mysql?
1
vote
1answer
586 views

Is it normal for mysqld to have 32k handles?

I am running Wampserver 2.0i on Windows 7 64-bit. I'm not experiencing any problems with any of the processes, but I noticed that mysqld is maintaining over 32,000 open handles. Is this normal ...
0
votes
1answer
308 views

Simple MySQL query locking up until database restart

I have a very simple query that runs in 216ms on my development machine but was taking more than 45 seconds on my production server, that is, until I restarted MySQL there: UPDATE `forum_categories` ...
0
votes
1answer
253 views

A Most Puzzling MySQL Problem: Queries Sporadically Slow

This is the most puzzling MySQL problem that I've encountered in my career as an administrator. Can anyone with MySQL mastery help me a bit on this?: Right now, I run an application that queries my ...
2
votes
5answers
6k views

Restart mysql keeping the data [closed]

I'm quite new using mysql, so let me know if I'm missing something. I took some holidays, and when I got back to work and I tried to log in phpmyadmin I got a ERROR 2002 (HY000): Can't connect to ...
3
votes
2answers
3k views

MySQL log shows 3 root users, 2 without passwords? Why?

Our MySQL log displayed a warning on restart about 2 root users not having passwords. I went into MySQL and checked all users: mysql> select * from mysql.user; and see: Host | User ...
4
votes
1answer
6k views

How can I get MySQL 5.5 to log warnings to one of the log files?

I have found various things that say that you can log warnings to the MySQL error log, but I have not been able to actually make it happen. I do have the error log working, and MySQL prints stuff to ...
0
votes
3answers
364 views

mysql spitting lots of “table marked as crashed” errors

I have a mysql server(version: 5.5.3-m3-log Source distribution ) and it keeps showing lots of 110214 3:01:48 [ERROR] /usr/local/mysql/libexec/mysqld: Table './mydb/tablename' is marked as crashed ...
0
votes
1answer
1k views

jboss 5.1 mysql connection pooling

I am using JBOSS 5.1.0.GA, MySQL 5.5 and Hibernate 3.3.1 GA (included with JBOSS) + Spring. My question is do I need to add c3p0 as a data source in my spring/hibernate configuration for connection ...
3
votes
1answer
4k views

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server ...
0
votes
1answer
6k views

How to set password for phpMyAdmin with default install of WAMP2?

I just installed it fresh, previously there would be no password at all and I'd be prompted to set one for security purposes, this time I'm just hit with an error: "Cannot connect: invalid ...
2
votes
2answers
262 views

Centos/MySQL server high load [closed]

I currently run a website we get about 15,000-20,000 hits a day. We currently run a very active forum, that is hosted using Vbulletin software. We have 4.5 Million Posts, 80,000 Threads, with about ...
0
votes
2answers
47 views

Closing the MySQL server to gain performance?

I plan on making a (servlet) application that stores its data in a MySQL server, but only reads them at startup time and write them every 4h. I wish to let this application have as much RAM & CPU ...
7
votes
1answer
3k views

How to disable keys in MySQL InnoDB tables?

Is it possible to disable keys in InnoDB tables? If yes, how? If not, why?
0
votes
1answer
509 views

How should I setup an Ubuntu server on EC2 (MySQL, code location, etc..)?

I've started to fiddle around EC2, and I can't seem to understand the "AWS way" of setting up a server. I'm using Ubuntu server 10.10 64 bit, from an official AMI by Canonical. There is an EBD drive ...
3
votes
1answer
936 views

MySQL Stored Procedure Parameters are NULL

I am stumped, and was hoping someone here would have a quick and easy answer. I did a fresh install of MySQL 5.5 and am trying to pass parameters into a stored procedure. The parameter values aren't ...
5
votes
1answer
1k views

I accidently dropped the mysql db

Today, i was absent minded and instead of droping the databases i wanted I wrote drop database mysql; What do i do now!?! i didnt do anything else since and i havent closed my session. Luckily ...
1
vote
5answers
81 views

MySQL performance: one DB or 5 DBs?

According to you, it's better to have a single DB with 1.000.000 rows or 5 DBs with 200.000 rows, in read/write?
1
vote
1answer
2k views

Will apt-get remove mysql-server-5.1 delete /var/lib/mysql?

I installed mysql 5.5 in /usr/local/mysql . If I apt-get remove the old package, it won't delete the data directory in /var/lib/mysql will it? UPDATE: Yes it's an official standard generic Ubuntu ...
3
votes
1answer
4k views

mysql checking permission takes a long time

I have a table(innodb) with about 50 million rows, tries to drop it, then it hangs, I checked process list: checking permission what is checking permissions state and why does drop table needs it?
1
vote
2answers
304 views

LAMP vs Windows Server 2008 scenario

I see there is a lot of things online about this, but wanted an answer specific to this scenario. I can think of a few issues with this, but wanted to ask everyone to get the whole picture. Can ...
1
vote
1answer
284 views

java mysql innodb disable transaction

how do I disable transaction temporarily if I'm using innodb from java jdbc? I'm doing a mass insert and wonder if it will speed up things. or should I just set autocommit to true?
0
votes
2answers
63 views

mysql and unix users control

Let's say I have two users on my UNIX machine - user1 and user2. I also have two MySQL databases - db1(mysql_user1) and db2(mysql_user2). I want to prevent user1 from connecting to db2 even if it ...
0
votes
2answers
527 views

Mysql: less than half of memory used. High load

I have an Ubuntu 8.04 LTS, with 8Gb memory, with dual E3110@3.00GHz, software raid on sata II. For a couple of monts now I try to tune the server and it seems that I'm still far from being done. ...
1
vote
2answers
407 views

Scaling MySQL Database

What are the methods or tools used to scale mysql database. We have mysql database that is increasing in size daily. We just allotted a fix hard drive size on it so my concern is that we will need to ...
1
vote
1answer
2k views

unable to kill and exit a large insert query properly

I have a large insert into statement that takes a long time to complete, so I killed it, but then it just sitting on processlist with status killed, and then I'm unable to restart mysql properly. I ...
1
vote
3answers
730 views

mysql stop slave forever

I used replication to migrate all data to a new server, and then I commented out master_host,master_port etc(basically all lines related to master) in my.cnf, I issued stop slave. However I after ...
1
vote
1answer
5k views

MySQL open files limit

This question is similar to set open_files_limit, but there was no good answer. I need to increase my table_open_cache, but first I need to increase the open_files_limit. I set the option in ...
0
votes
2answers
259 views

MySQL dies during hard work

I have a MySQL database installed on a OpenSuse 11.1 server (it is a Bitnami image). The database works fine, it can stay many days without any error, but when MySQL receives a huge amount of ...
0
votes
1answer
175 views

debian-sys-maint user in mysql?

i just installed mysql on debian 6. With phpmyadmin i noticed there are already 4 mysql user: debian-sys-maint (localhost) root (127.0.0.1) root (localhost) root ...
1
vote
2answers
469 views

difference between mysql and mysqldump

I am going to importi a database.. (db.sql) I will use something like: mysql -u root -p db < db.sql Can you tell me what the difference is between this and mysqldump? Thanks
2
votes
2answers
3k views

Installing isolated instance of MySQL on Windows using silent install with .msi

I'm trying to write an installer for an internal application we wrote. After it installs our application it then installs MySQL using the .msi installer in silent mode. I specify the install dir and ...
0
votes
3answers
946 views

Remi Repo Mysql Server Not Starting

Executing the command to start the mysql service fails to start the mysql server. [root@localhost]# service mysqld restart Stopping mysqld: [ OK ] MySQL ...
0
votes
1answer
206 views

mysql version with apt-get too old?

i just installed mysql with apt-get: apt-get install apache2-mpm-prefork libapache2-mod-php5 mysql-server php5-mysql But phpMyadmin says: Version MySQL: 5.1.49-3 isn't that a bit too old ...
1
vote
3answers
2k views

Problem with MySQL and UTF-8

I'm having problems when configuring a server with UTF8. Well, I'm not configuring it exactly. I client from where I work does and I think that he's not an expert configuring web servers. My ...
0
votes
3answers
613 views

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 ...
1
vote
4answers
549 views

Web server is extremely slow

My web server is running on PHP 5 and MySQL 5.0. When I copied an application developed in CAKE PHP, the server is extremely slow. The organization who provides the files are running the same ...
0
votes
4answers
687 views

PCI-DSS Compliance

We're developing a new piece of software (really just a single php script) that collects cardholder information and stores it in a MySQL database. Obviously we're taking every precaution with security ...
0
votes
1answer
486 views

DRBD Replication failure

A couple of weeks ago I setup a 2 nodes CRM system with one of the resources managed being MySQL over DRBD. Today for maintenance reasons I restarted both nodes but now they can't connect to each ...
1
vote
2answers
181 views

backing up my linux server to my windows machine

I have a linux server. several days ago one of HDDs attached to the server crashed and i was very lucky not to loose anything important cause that was my backup HDD. Now i'm looking for a solution to ...
2
votes
4answers
2k views

MySQL and PostgreSQL on the same hardware

We recently bought some new hardware for a database server which we were intending to dedicate to the operation of PostgreSQL. However now we have the requirement to also run MySQL as some software we ...
2
votes
2answers
2k views

Restoring a slave MySQL database from raw backups of master gives InnoDB tablespace errors

I have a master/slave replication setup where I use InnoDB and MyISAM tables in over 7000 databases that I want to copy from my master to the slave to restore replication. Both servers were running ...
0
votes
2answers
790 views

MySQL rotating backup script - plesk

I have a MySQL backup script I picked up somewhere (can't recall where). It works when I run it manually, but run on cron as root it doesn't run for some reason. There may be a cron log I can check ...
0
votes
1answer
656 views

mysql 5.1 skip skip-networking param

I don't know why my mysql doesn't read the my.cnf file. I write a commented line # skip-networking on my.cnf, restart mysqld and when exec #ps aux | grep mysql returns: root 7737 0.0 0.0 ...
0
votes
2answers
484 views

Selinux/MySQL permissions issue in a new iSCSI disk: not allowed default_t context

I've a server with MySQL installed and running, and an iSCSI disk (with multipath) connected and running OK. The iSCSI disk uses /emc as mountpoint. My problem is when I move MySQL datadir to a new ...
0
votes
3answers
175 views

Recommended way to Investigating server performance issues

I have a linux server box that runs the following stack: apache 2.2.9 passenger 2.2.8 rails 2.3.8 MySQL 5.1 Recently we've encountered some machine performance issues, where the entire server ...
1
vote
1answer
1k views

High MySQL CPU usage but no heavy query

When I run "top" command on my Linux it shows that MySQL is taking 400%-500% CPU usage. But when I run "watch mysqladmin pr" command to see a list of queries being run by MySQL then it shows just 2, 3 ...