MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
324 views

Why my 64 bit server is slow when running PHP application

I have 64 bit server with 6GB RAM and proc xeon E5620 installed with centos server 64. But when I access my localhost php application, is a little bit slow than run on my localhost old laptop. Did I ...
0
votes
1answer
529 views

Setting up MySQL Linux slave with a Windows master

I'm running a MySQL 5.0 database server on Windows Server 2008. The total size of the database is about 1Gb. I make daily backups, but I'd like to step up to having a slave server for extra ...
1
vote
2answers
5k views

Error importing large MySQL dump file which includes binary BLOBs in Windows

I'm trying to import a MySQL dump file, which I got from my hosting company, into my Windows dev machine, and i'm running into problems. I'm importing this from the command line, and i'm getting a ...
1
vote
1answer
2k views

MySql service stops under 2008 r2 x64

I have installed MySql 5.5 server under windows 2008r2 x64 Apparently I can see that MySql service stops even if is configured to start automatically What can I do to find out why this is happening? ...
1
vote
2answers
73 views

MySQL server service uninstallation

I uninstalled the MySQL server by removing the entire folder manually in my Win2k3 machine (since it was in a zip installation format), but the NT Service references are still dangling. How should I ...
2
votes
1answer
151 views

MySQL Master-Master replication generating thousands of log files

Today, I checked the /var/lib/mysql/ directory of a server in a master-master replication setup and noticed there were about 3,600 slave-relay.00xxxx files in there (where "xxxx" is an incrementing ...
0
votes
2answers
718 views

mysql with DRBD on rackspace

I am trying to set up a failover secondary MySQL server that is a mirror of my primary MySQL server using DRBD. The problem is that I am on a rackspace cloud server and I need a second partition on ...
0
votes
1answer
554 views

How to recover MySQL database from .mysql file?

We had some problems with our MySQL server and somehow all I've got is a database.mysql file for the database I want to restore. I've done a bit of googleing but I didn't find anything about how ...
0
votes
1answer
377 views

MySQL root user can't access database

We have a MySQL database ('myhours') on a production database server that is accessible to one user ('edsf') only, but not to the root user. The command 'SHOW DATABASES' as the root user does not list ...
2
votes
1answer
767 views

INSERT DELAYED on locked tables blocks PHP processes to continue

Our webservers write some tracking information into a MySQL database (using INSERT DELAYED into MyISAM table). When a huge SELECT query is executed on this table or when it is locked for another ...
0
votes
1answer
162 views

Not able to installl mysql-server ubuntu

I'm not able to install mysql-server on ubuntu 10.04 I had installed mysql but it was giving this error ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
209 views

Mac OS 10.6 and MySQL 5.5.8 Shutdown

I was just wondering, if MySQL is running when you shutdown does the OS shut it down cleanly or does it just kill the process? I Installed via the .DMG image from the MySQL site. Also started it with ...
1
vote
1answer
2k views

Reducing MySQL RAM usage on CentOS

I have a vps with CentOS 5 (32bit) and it has 256mb of ram, although not much it is enough for me. On idle with 2 ssh connections active and httpd running it uses about 40mb of ram, but as soon as I ...
1
vote
1answer
3k views

How to turn off the binary log for mysqld_multi instances?

MySQL supports running multiple mysqld on the same server. One of the ways is to use mysqld_multi. If the default MySQL server instance (as configured in the [mysqld] section in my.cnf) uses log-bin, ...
1
vote
1answer
1k views

How to change password schema for Dovecot user authentication for an already existing mail server

I have an email server setup on Debian Lenny with Postfix, Dovecot, SASL and MySQL. Currently, the password scheme in my dovecot-sql.conf file is set to: CRYPT default_pass_scheme = CRYPT I would ...
0
votes
1answer
95 views

Estimate server load for an API

I want to know how many resources (MySQL time, CPU usage, bandwidth, etc.) will use my system with a certain number of API calls per second. One API call gets the parameters in PHP, do from 1 to 5 ...
4
votes
1answer
560 views

Mysql ndb cluster - node restart

I just setup a mysql cluster on a fairly decent baby (IBM x3650 M3) with 24GB memory, xeon 6core, SAS 6Gbps HDD. Running Debian Lenny 5. 64bits. Ndb version is 7.1.9a. Our database size on MyISAM is ...
3
votes
5answers
508 views

I'm trying to set up a LAMP server so it's totally anonymous, any suggestions?

I'm going to set up a web service which will use the LAMP stack. One of the most important features of the site is that it should be anonymous. We thought that a cool thing will be if the server ...
0
votes
2answers
140 views

Logging in with a different password than the database password, PHPMyAdmin

I am trying to install PHPMyAdmin on my server to manage my MySQL databases. Right now I have only one I want to add, but I would like to be able to manage multiple databases from the same account on ...
2
votes
2answers
1k views

Chroot for Mysql running on Ubuntu 10.10?

Prompted from a question about MySQL server security best practices, I've been running through this list (with a few minor alterations) to properly secure my server database server: ...
0
votes
1answer
208 views

Server getting overloaded

I have 2 setups tomcat5.5.20 on Redhat and mysql 4.1.22 on another Redhat server. Recently my webserver started getting overloaded up to 80-90%. After checking i found repeating errors(each ...
4
votes
9answers
3k views

How can I test the security of my server?

How can I test the security of my server ? Please I know it is too general question. But I was wondering if there is a tester software or web service checking all ports of your server, or possibly ...
-1
votes
1answer
212 views

Problem with e-mail server

I follow this tutorial step by step and in the end http://wiki.mediatemple.net/w/DV:Install_Postfix_on_Ubuntu#Configuring_TLS_and_SASL_authentication and i can make mi server work correctly the ...
1
vote
2answers
600 views

how to restore a mysql dump FOLDER

After having a vps crash, I asked my hosting to give me the dumped file of my drupal database. It is a folder filled with of *.frm *.MYD files of the database tables. I used to restore mydb.sql files ...
2
votes
4answers
757 views

Best practice for ONLY allowing MySQL access to a server?

Here's the use case: I have a SaaS system that was built (dev environment) on a single box. I've moved everything to a cloud environment running Ubuntu 10.10. One server runs the application, the ...
1
vote
2answers
350 views

MySQL cluster question

I am thinking about using MySQL cluster, but I am curious if it supports big databases - around 50-60GB or what is the limit (mainly Radius telco accounting are stored). What would be architecture ...
4
votes
3answers
378 views

How to Architect a system on AWS for scaling (with a MySQL back-end)

I'm trying to understand how to architect an Amazon Web Services application. As I understand it, the whole point of using something like AWS is to make the eventual scaling easier, so I'm trying to ...
2
votes
1answer
452 views

Accessing mySQL from two ports: Problems with iptables

I'm trying to make my mySQL-server (running on Ubuntu) listen on port 3306 and 110, because I would like to access it from a network with very few open ports. So far I've found this answer telling ...
3
votes
4answers
794 views

master-slave-slave replication: master will become bottleneck for writes

the mysql database has arround 2TB of data. i have a master-slave-slave replication running. the application that uses the database does read (SELECT) queries just on one of the 2 slaves and write ...
0
votes
1answer
469 views

Problem in configuring MySql 5.5 instance

I have problem in configuring the MySQL 5.5 instance. I have successfully installed the server and now trying to install the instance through configuration wizard. I am getting the following error:
5
votes
2answers
3k views

mysql is not using multiple cpus

Our MySQL server has been using a lot of CPU lately (it's reached 100% several times and stays there for a while) and I noticed that it the CPU load is all on one core of one cpu. I was hoping to ...
2
votes
1answer
1k views

mysql INNODB inserts very slow

The database's schema is as follows. CREATE TABLE `items` ( `id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT , `name` varchar( 45 ) NOT NULL , `main_type` tinyint( 4 ) NOT NULL ...
1
vote
2answers
207 views

Changing the character encoding of a MySQL database

Our whole application is now able to handle UTF-8 and it will be our choice in terms of encoding all across our architecture. The last step is to change the encoding of our MySQL databases. Of ...
0
votes
2answers
143 views

MySQL: Log only drop/create commands

Is there a way to log only certain MySQL operations? I need to enable it's log in a production server but only for drop/create commands. Unfortunately logging everything is slow and I only need these ...
-1
votes
2answers
957 views

What can I delete after moving MySQL database files location

I'm trying to move the location of database files from /var/lib/mysql to /home/lib/mysql I only changing database files. Socket is still /var/lib/mysql/mysql.sock (only changing datadir in my.cnf) ...
0
votes
2answers
985 views

Is it ever safe to set innodb_flush_log_at_trx_commit=0?

I have a server (Dell PE2950) with a battery-backed write cache on the raid controller. Is it safe for me to set innodb_flush_log_at_trx_commit=0 on a mysql server with data files stored on a raid0 ...
1
vote
1answer
77 views

What are some general tips to make InnoDB for MySQL perform at its highest?

I've been using MyISAM exclusively for several years now and know the ins-and-outs pretty well of how to optimize it, but I've just recently started using InnoDB for some of my tables and don't know ...
1
vote
2answers
1k views

Disk full, how to move mysql database files?

my database files located in /var/lib/mysql which located in partition /dev/sda5 this partition is full (refer here for details) so I'm going to move the location of database files from ...
0
votes
2answers
45 views

Mysql not working

I have installed XAMPP installed in my linux machine and phpmyadmin is working fine. But when I tried to start mysql using console using mysql command, I am getting the following error. ERROR 2002 ...
2
votes
2answers
206 views

Mysql cluster Vs basic Mysql db setup(not cluster)

Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)? What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?
1
vote
2answers
1k views

MySQL InnoDB table shows a negative number of rows in phpMyAdmin

I just converted a MyISAM table to InnoDB with around 1.4 million rows. When I converted it to InnoDB, it now shows -1.4 million rows. The table still works as expected, but why does it shows ...
2
votes
1answer
706 views

Running Queries in Parallel

I have a list of queries that I use to warmup my InnoDB database tables. Currently, I run these queries sequentially and they take some time to run. I was wondering if there was a way I could run ...
5
votes
2answers
4k views

mysql wont stop, mysqld_safe appeared in top

my server (CentOS) contains lots of website, which collect data from lots of sources with cron. the mysql config is the default recently, PHP failed to communicate with mysql. Firstly I just restart ...
0
votes
1answer
779 views

MySQL per user monitoring

Is there a tool for monitoring per user MySQL usage? Like number of queries for example. I have been looking on Munin which I currently use, but did not find anything. A similar tool is the per user ...
2
votes
0answers
175 views

mysqldump trigger crashed tables

We had a database crash this morning starting at 1 minute past midnight (when the database backup runs). The exception emails I was getting said "Table './core/content' is marked as crashed and ...
0
votes
1answer
251 views

I need some MySQL lookup table advice

I have a MySQL database with about 200 tables. 50 of these are small 2-field 'id-data' lookup tables. Several of these DB's are hosted on a shared server. I have been informed that I need to reduce ...
8
votes
7answers
61k views

“Error 1067: The process terminated unexpectedly” when trying to install MySQL on Win7 x64

I've run into a brick wall trying to install MySQL v5.5 on my machine. My PC is Windows 7 x64, Enterprise edition. MySQL installs fine, but when I run the "MySQL Instance Configuration Wizard", it ...
1
vote
1answer
96 views

Multiple databases on Mysql crashes the mysql server often

We are running Mysql on CentOS 5.5. And are using the database sharding approach. As it is an erp app, there are about 300 tables for each new Application/company. At the moment we have around 600 ...
0
votes
2answers
637 views

How to write output from mytop to file

Our application is using a very busy MySQL database with lots of reads, sometimes I don't want to look at the MySQL log files, I just want the output from mytop for the last 5 minutes. How do I write ...
1
vote
1answer
90 views

Mysql Capacity with some Server specifications

I wonder how many capacity of Mysql. Please tell me with details of some Server Specifications(OS,CPU,RAM...). Thanks in advanced, Rithy