MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
2answers
908 views

MySQL 2,500+ opened tables

I'm running 16 GB of RAM with dual 3.0 Ghz processors with Ubuntu Server My PHPMyAdmin is showing: Opened_tables 2,573 - The number of tables that have been opened. If opened tables is big, your ...
0
votes
2answers
700 views

MySQL Fixed-Length and Variable-Length Columns?

I'm trying to generate a little more performance from a particular table full of hundreds of thousands of rows. There are a few VARCHAR fields that I'm converting to CHAR. I'm aware that I won't get ...
0
votes
2answers
4k views

Installing MySQL on CentOS 5.5

I have to install the latest version of MySQL server community edition 5.1.51 (i think is the latest). I haven't installed any MySQL on this centos machine yet, but when I do a locate mysql - it shows ...
0
votes
2answers
132 views

Does more MySQL user will require more CPU & memory usage?

Usually I will make 1 MySQL user for every database, instead 1 MySQL user for all database. but I just wonder.. does more MySQL user will require more CPU & memory usage?
0
votes
2answers
573 views

Mysql Errcode: 17 Can't create/write to file '/tmp/…'

Can't create/write to file '/tmp/#sql_77a8_0.MYD' (Errcode: 17) I'm getting this for all softs of select queries. This problem is quite intermittent. Deleting the file fixes the problem but in an ...
0
votes
3answers
160 views

automated mysql maintaince

Is there a script doing mysql maintenance ? or how can i make it manually, using cron tab ? and what steps should a good mysql maintenance run ? (MyISAM)
1
vote
2answers
6k views

Updated MySQL: MySQL Daemon has failed to start

Just updated my MySQL on CentOS when I did yum update. My website threw some MySQL errors and I found out that MySQL wasn't running: # /etc/init.d/mysqld start MySQL Daemon failed to start. Starting ...
0
votes
1answer
185 views

Radius sqlcounter key

The short version of my question is how do I limit individual user sessions to 24 hours, even if each session has the same UserName. I have a radius server setup with CoovaChilli to authenticate ...
0
votes
2answers
185 views

MySQL Monitoring - Cloud Instances - No System Access

Are there any MySQL monitoring suites/tools built to use on systems such as Amazon RDS where you do not have system access? Looking for something beyond custom tools (nagios, zenoss, ganglia, ...
0
votes
1answer
625 views

max_connections for 8GB RAM and shared server

I just wanted to ask what would be a good number in my.cnf in MySQL for max_connections? I have a shared server which has about 10 websites and 8GB RAM and a quad-core processor.
1
vote
2answers
283 views

Recommend a good guide for MySQL optimization

I just upgraded my RAM on my server from 4 GB to 16 GB and I'm told that I can utilize this memory to a huge advantage with certain MySQL settings if I get then just right. Do you know of any guides ...
0
votes
2answers
310 views

Periodic Mysql Data loss

Almost once in 2 weeks,i am facing mysql data loss in a table. almost 600 rows are being deleted. I cant trace that issue. What may cause this or how can i trace who/what makes it ? Thanks
0
votes
1answer
512 views

MySQL doesn't save my 90KB text in a LONGTEXT field

When saving my 90KB text in a LONGTEXT field (using phpmyadmin), nothing happens. Anything above around 64KB doesn't seem to get saved. I tried to reproduce the same behavior on another server but ...
2
votes
2answers
2k views

MySQL “wait_timeout” option won't save

MySQL is currently set to a wait_timeout of 28800 on our server which I understand to be the default. I've been attempting to change this to 60 as recommended by a consultant, but the changes don't ...
1
vote
1answer
285 views

What happens when you kill a process that has database tables locked?

Trying to kill a process that running a MySQL database backup, and has the tables locked. What will happen if I kill the process?
0
votes
1answer
260 views

MySQL Driver for PHP PDO

Are PDO drivers available for download for Win64? I'm looking for a MySQL driver, but all my Googling seems to suggest that my PHP binary should have been compiled with this support. Is that the ...
9
votes
3answers
639 views

Anyone used MySQL Forks in Production

Now that MySQL is owned by Oracle many are starting to consider using some of the popular forks such as MariaDB and Drizzle. Has anyone used these in production for any extended periods of time? If ...
4
votes
2answers
2k views

What is the difference between MySQL Community Edition and Classic Edition?

With the news of Oracle pulling the InnoDB engine from MySQL Classic Edition, you now need to use MySQL Community Edition to get InnoDB for free. Oracle doesn't really make it clear what is different ...
0
votes
1answer
391 views

Sphinx cannot be found on your system (OSX)

I recently installed sphinx, mysql etc. and everything works fine as well. However, I always get the message: Sphinx cannot be found on your system. You may need to configure the following ...
0
votes
2answers
126 views

What steps to take to find the problem

A remote linux web/db server stopped responding, and the hosting company just rebooted it. What steps should I take to find out what went wrong?
0
votes
1answer
1k views

How to install Percona Server on Ubuntu 9.10 Karmic?

I followed the instructions on this page: ~$ gpg --keyserver hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A gpg: requesting key CD2EFD2A from hkp server keys.gnupg.net gpg: key CD2EFD2A: public ...
0
votes
1answer
443 views

MySQL ibdata1 permissions error on cloned EC2 instance

I am trying to get a Rails app running on a cloned EC2 instance and am running into some permissions issues with my ibdata1 file. On the original instance, everything behaves as expected. However, ...
2
votes
2answers
2k views

MySQLadmin drop database - bash script

I have a bash script which downloads a sql.gz file, extracts it and then import it, however before importing, I drop the existing DB, then import the new DB onto the server. All is well and the ...
3
votes
2answers
77 views

Login blackout for MySQL

Between 9pm and 6am I run automated jobs to update our databases, and I want to disable a specific list of users from logging into MySQL.
1
vote
2answers
390 views

Anyone burned by MySQL 5.5RC on production server?

I've been thinking to upgrade to MySQL 5.5 on our Ubuntu production server. As it's a RC already and we don't stress our server too much, I don't expect any problems. However, it would be good to ...
0
votes
2answers
92 views

MySQL: Strange behavior after importing DB and FLUSH PRIVILEGES

I've imported my old database (via phpMyAdmin) and everything seemed to be fine - except for the user/password combinations. I tried to do a "FLUSH PRIVILEGES" and afterwards, I couldn't login anymore ...
1
vote
1answer
430 views

mysql server using too much memory

i noticed that my server acting slow, and also found that mysql is using a lot of memory - 423.1 MB free of 3.9 GB... after i restarted mysql it was 3.8 GB free of 3.9 GB. few minutes after, it was ...
0
votes
2answers
55 views

mysql redundancy with mixed storage types

Looking at building redundancy into our system, as we are currently, um, exposed should anything blow up. We have a large-ish DB (150G), consisting of a mix of innoDB and myISAM table types. We want ...
0
votes
1answer
100 views

Repair all mysql tables on localhost

I have a whole bunch of mysql databases which seem to have corrupted tables which is a bit of a worry. Repairing them on one site fixed all the issues for that site, but is there a way of repairing ...
2
votes
2answers
174 views

tunnel ssh for a mysql connection

I need to do an ssh tunnel to connect to a mysql server. if i do : me@local> mysql -h host -u user -p pwd I get a 100 error I have an ssh account on a distant server and this command works : ...
0
votes
3answers
267 views

accidentally deleted mysql folder

I am in a problem. I have accidentally deleted etc/mysql by writing sudo rm -r /etc/mysql .How can i restore it or if not then what to do next .when I am typing mysql command its saying : Can't ...
0
votes
4answers
2k views

Cannot start MySQL

I used this command from shell to repair all Databases mysqlcheck -u root -p --auto-repair --check --optimize --all-databases and after that I restarted the server when it came back alive again I ...
2
votes
2answers
203 views

How can I know if there are innodb tables in a mysql server?

I have a mysql server and I want to disable innodb support for it. It's said that I can cut-off my memory usage up to 100MB. I'm pretty sure but not 100% sure, that there is no innodb tables in the ...
1
vote
1answer
901 views

How big would a MySQL database be if I save all webpages' title and URL in it? [closed]

For learning purposes, I want to make a simple web indexer which crawls the web and saves all found pages in a MySQL database with their titles and URLs, with this table (the page's content is not ...
2
votes
4answers
885 views

Mysql replications: slave is not readonly

After setting up mysql replications with master/slave db scheme, I noticed that the slave db server is not read-only. Of cause, after that I configured it manually in /etc/my.cnf file. I just can't ...
1
vote
3answers
326 views

Duplicate primary keys in MySQL table due to DoS attack

We have a MySQL database with duplicate primary key index entries as a result of a DoS attack. The duplicates cannot be found by selects on the ID (it will only show one row, not two), but if you ...
0
votes
1answer
232 views

Cannot select from new view in MySQL (can select from everything else)

I am a newbie to MySQL, being more accustomed to MSSQL. However, we have recently purchased the LabTech management software, which uses a MySQL back end. While writing a custom report to keep track ...
1
vote
1answer
248 views

What is the easiest way to get XtraDB for MySQL running on CentOS 5

I'm having a lot of issues with a dedicated MySQL server and it seems like upgrading to the XtraDB version of InnoDB will probably have a positive effect, but I'm hesitant to get involved with it ...
1
vote
3answers
182 views

How to automatically move specific MySQL tables from one machine to another?

I have a MySQL database with tables in the form of "shard_0", "shard_1", "shard_2", etc. I want to add another DB server and move the even-numbered shards ("shard_0", "shard_2", "shard_4", ...) to ...
4
votes
2answers
133 views

What are the warning signs that a MySQL table might be corrupted

For some reason, it's not the first thing I think of when diagnosing very strange table errors. I had an issue when doing an order by I'd wind up with only one record. Explain said I should have 28 ...
1
vote
1answer
808 views

mysqld not responding

Has anyone seen this before? [host@user init.d]$ mysqld stop mysqld: Too many arguments (first extra is 'stop'). Use --help to get a list of available options [host@user init.d]$ mysqld restart ...
0
votes
2answers
403 views

is it possible to make .htaccess to connect to DB

is it possible to read the username/password of .htaccess from a database (to allow multiple users) i need to manage it using apache and database only without having any PHP/perl code level any idea ...
3
votes
3answers
699 views

Mysql replication using drbd and heartbeat

I am setting up a backup server for an already existing Ubuntu server setup. I'm running DRBD (protocol C) together with heartbeat, which is configured so that in case of an error the MySQL5 Server ...
0
votes
2answers
408 views

MySQL: Weird log message in the slow queries log

I found in the slow queries log there are a bunch of these logs, what exactly does it mean? It looks like mysql is keep restarting itself? I'm using mysql 5.0.77. Any idea what might be causing this? ...
1
vote
2answers
4k views

Where can I get php_mysql.dll for Windows?

I just installed Apache 2.2.17, PHP 5.2.14, and MySQL 5.1.51 on Windows XP. Apache is working and is loading PHP properly, but when I try to connect to MySQL, I get "Fatal error: Call to undefined ...
5
votes
6answers
20k views

How to rename a MySQL database?

How to rename a MySQL database? The MySQL online manual says about the RENAME DATABASE command: This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL ...
2
votes
3answers
160 views

Does the order of creating a columns for a table impact performance?

For purely asthetic reasons I've always had the first column(s) of a table as the primary key column(s). After that I've not taken any care to the order columns are added to the table. Is this wrong? ...
0
votes
1answer
286 views

Possible to programmatically ALTER multiple MySQL tables?

I have multiple MySQL tables with names of the form "Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database. Say I want to add a ...
1
vote
1answer
399 views

Optimum settings for apache/php webserver with separate mysql database server

I'm having a mysql connection speed issue with my home development setup. I have two VM's (VirtualBox running on a Ubuntu host). One is my WEBSERV with apache2/php and one is by DBSERV with mysql ...
0
votes
2answers
72 views

Starting Production Database at boot time --

In previous places I've consulted or worked at we've never started a production database at boot time --- for many reasons --- hardware issues during boot time causing corruption, unstable net ...