MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
2answers
40 views

What Charset to use for Languages

SO I'm in the process of creating a database for a website that will store info in multiple languages. I understand that there are "Charsets" in MySql that determine which types of characters can be ...
0
votes
2answers
691 views

How do I correct replicaiton on the primary master after reconfiguring replication in a MySQL-MMM cluster?

I have a MySQL-MMM cluster with three database servers (two masters and one slave). Recently replication was broken by someone directly inserting to the slave database servers. After I discovered this ...
0
votes
1answer
335 views

Rackspace: optimizing LAMP environment (using memcached)

i recently moved a web app to Rackspace (CentOS). It runs pretty well with 512mb RAM but im sure i will have to upgrade it to 1024mb RAM pretty soon. The bad news, is that the service runs on mobile ...
0
votes
1answer
132 views

MYSQL count only users who have answered the most questions in the last 30 days

Currently I have: SELECT user.userid, Username, count(answerid) as Answers FROM user left outer join answer on user.userid=answer.userid group by user.userid order by Answers desc limit 0,5 This ...
3
votes
1answer
140 views

what is a mysql 'packet', anyway

Mysql 5.1: if we want to use very large blobs, apparently we need very large packets, configured identically on both ends. How large can we go before something explodes? See this.
0
votes
1answer
126 views

Which is faster, key_cache or OS cache?

In a tb with 1 mil. rows if I do (after I restart the computer - so nothing it's cached): 1. SELECT price,city,state FROM tb1 WHERE zipId=13458; the result is 23rows in 0.270s after I run 'LOAD ...
2
votes
3answers
6k views

How do I change a password directly in the PhpBB3 SQL database?

I have inherited a PhpBB3 installation from an uncontactable previous admin who didn't leave me the password, or any mechanism to retrieve it. It runs on a MySQL database, which I have logged into ...
1
vote
1answer
1k views

How to use most of memory available on MySQL

I've got a MySQL server which has both InnoDB and MyISAM tables. InnoDB tablespace is quite small under 4 GB. MyISAM is big ~250 GB in total of which 50 GB is for indexes. Our server has 32 GB of RAM ...
0
votes
2answers
488 views

Difference between key_buffers and recommendation

I'm looking to add a bit of memory to MySQL on a Linode VPS server on which I've got a small facebook (canvas app) PHP app using MySQL running. I'm not super familiar with MySQL optimization so I'm ...
1
vote
5answers
759 views

What is the best option to set up a quick and easy-to-manage database for my small office?

First, please be aware I am definitely a beginner when it comes to server maintenance or network administration. That being said, if I am asking this question in the wrong forum, please feel free to ...
0
votes
3answers
304 views

Problem with load Apache + MySQL

I have tried configuring both Apache and MySQL but I still get very high peaks in load: http://d.pr/aD9L I'm pretty sure these peaks are not caused by increase in traffic, because no peaks can be ...
1
vote
2answers
1k views

Change password of PhpMyAdmin on localhost

I have upgraded Ubuntu 9.10 to Ubuntu 10.10 but I cannot access PhpMyAdmin. How can I change the username and password for PhpMyAdmin? I urgently need to access PhpMyaAmin because my database is ...
0
votes
1answer
65 views

mysql smart replication

Is it possible to setup some kind of smart replication, so that these columns are automatically updated if they are changed in another database .. Like : rows are automatiically added, some columns ...
1
vote
3answers
528 views

Migrating a large Mysql DB from one server to another (via linux shell)

I have a large Mysql db (over 10gb). I'm moving from one hosting provider to another one (both in CentOS). My idea was to do this: Old server: tar -cvf backup.tar backup.sql New server: wget ...
3
votes
2answers
271 views

What are some reasons why a MySQL index would be 12X the size of the table?

So we have a table that has two indexes one on the primary key and one other index on another column on the table. The index size is currently 12X larger than the table itself. What are some reasons ...
0
votes
1answer
228 views

Errorlog, accesslog, slow query log, execution time log, traffic and req per sec into one tool?

I'm searching for a tool designed for LAMP server that combines server Error log, Access log, slow query log, takes time of execution of PHP scripts,traffic and req per sec statistics (for example ...
0
votes
3answers
78 views

Having trouble trying to SSH

I am trying to SSH to a mysql DB on my web server. First I tried using PuTTY on windows 7. put in my domain and clicked open. A command prompt comes up and asks me for a user. I put in my ftp user ...
1
vote
1answer
475 views

LAMP: slow query via PhpMyAdmin, fast via command line

I have a very strange problem - my server responds quite slowly even though it is basically unused: Apache seems to be less snappy than what I would expect and MySql responds to queries sent via ...
7
votes
3answers
4k views

Postgres vs MySQL: Which one is more difficult to scale out?

From your experience, which database serve is more difficult to scale? MySQL or Postgres? I know MySQL has several out-of-the-box scaling/clustering features, but with Postgres there is none that ...
1
vote
2answers
153 views

MySQL config recommendation script

I want to be able to get an recommendation of what values I should set my my.cnf to. Especially the query_cache_size and join_buffer_size. Is there a script out there that can monitor my server and ...
2
votes
1answer
9k views

How to set query_cache_size and join_buffer_size in my.cnf file?

I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to ...
3
votes
1answer
3k views

MySQL query time-out available?

Is there a way to associate a time out to a query sent to the MySQL server? Expected behavior MySQL server would trigger a time out if the query did not complete after a time T provided by the ...
1
vote
2answers
335 views

Unable to set the password in My SQL

I installed wamp in my windows 7 machine. While setting the root password in mysql , I got following error : C:\wamp\bin\mysql\mysql5.1.36\bin>mysql -u root ERROR 1045 (28000): Access denied for ...
-1
votes
2answers
501 views

access denied after clean install of mysql with macports [closed]

I installed mysql5 and mysql5-server with macports started service fine but when i did mysqladmin5 -u root -p ping i get Enter password: mysqladmin5: connect to server at 'localhost' failed ...
0
votes
2answers
910 views

Can't find my.cnf on my VPS

Hello, I am currently renting a VPS for the purpose of host a magento store. The VPS is running Centos5 with DirectAdmin. I have read a bit about how to optimize magento and one suggestion I have ...
1
vote
1answer
434 views

How can I limit the maximum number of simultaneous MediaWiki to MySQL database connections?

We have a MediaWiki wiki on a MySQL database. However, other applications are also accessing MySQL. Currently we have a maximum of 100 maximum connections to the database, of which MediaWiki is ...
1
vote
1answer
871 views

What is the easiest way to get MySQL's Archive Storage Engine working on CentOS 5.4

The Archive Storage Engine is not enabled by the default build of MySQL in CentOS/RHEL. I would like to enable it on our CentOS 5.4 server. My initial reaction was to modify the SPEC file for the ...
0
votes
1answer
180 views

Backing up mysql databases with launchd - what's wrong?

I'm trying to setup a backup of my databases on my new mac. I've got the script created and as far as creating the launchd plist file. However, the task seems to run over and over, instead of once a ...
0
votes
2answers
178 views

Can I store MySql config file not in /etc folder? How?

I'm new to Linux. just studying php/mysql development. On windows I kept Apache, PHP, Mysql, PgSQL directories in one folder on SEPARATE DRIVE, like this: D:\server \mysql \apache \php ...
0
votes
2answers
132 views

MySQL Server using same data in windows and linux?

I have a dual boot (windows 7/linux) computer. I have an NTFS partition to exchange data between them. I want to install a MySQL Server. However, I don't have another computer and, as I would like to ...
1
vote
2answers
130 views

ftp: transfer parts of a file?

If I'm transferring a 2GB sql file with filezilla, and it timed out after 50%. In my server, I can see that the new transferred file is about 1.1GB. I want to know if there's a way through the same ...
0
votes
2answers
334 views

Installing and configuring MySQL server in a CentOS from the terminal

i recently registered for a rackspace cloud hosting account. Everything is running fine already, but i still have to set up the database system. I've already done this yum install php-mysql mysql ...
0
votes
3answers
42k views

How do I grant full permissions to a user with mysql?

How do I grant full permissions to a mysql user? Im running MySQL 5.1 on Redhat. I tried using cpanel, but when I use jet profiler it says I do not have full permissions. I am not too good with ssh, ...
3
votes
3answers
6k views

How do I enable log_slow_queries on MySQL 5.1?

How do I enable log_slow_queries on MySQL 5.1? Im running redhat.
2
votes
3answers
230 views

Best ways to copy data and schema with mysql

I'm looking for recommendations on the best way to copy data between locate and live deployments. I've just installed MYSQL work bench but can't see how to copy data from local to remote. Also in the ...
1
vote
4answers
274 views

Increase speed of small office MySQL server

I work in a small development team - PHP/MySQL app. Each in-house developer has Apache/PHP installed and is accessing a Windows 7 box with MySQL 5.1 installed. Box is 32bit, Pentium D, 4GB ram, ...
1
vote
4answers
2k views

Adjusting MySQL settings to handle big load of users

I have developed a php game that is obviously depending on mysql queries. Im running it on a monster server: Intel Xeon 7550 with 32GB RAM (Redhat x86_64 ES 5.0) with cPanel installed. I released the ...
1
vote
2answers
1k views

MySQL create user and database privileges

I am trying to write a simple shell script to create new mysql user and database for this user. Since I don't want to do use mysql root account, I've created a new user (let's call him 'creator'). I ...
0
votes
1answer
173 views

mysql replication - disabling any other DB changes on slave

I have configured mysql to replicate itself to another DB server. Through my testing of this setup, it appears that the slave can have values changed manually in the replicated databases. Is there ...
1
vote
2answers
4k views

phpmyadmin error #2002 cannot connect to mysql server

I am getting the error in the title when trying to connect to my MySQL server. I have reinstalled MySQL and PHP several times and tried a slew of command line work based on information I searched out. ...
4
votes
2answers
6k views

How find and fix fragmented MySQL tables

I used MySQLTuner which pointed out some tables were fragmented. I used mysqlcheck --optimize -A to optimize all tables. It fixed some tables but MySQLTuner still finds 19 tables fragmented. how ...
0
votes
2answers
822 views

Upgraded Ubuntu, can't connect to MySQL server

When I try to connect to MySQL, I get the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) It seems like this is a common ...
4
votes
4answers
3k views

Who is using the swap memory and why?

My database server is using 191MB of swap space - but also shows 182MB of free RAM The box is a dedicated MySQL server, running Debian Lenny. How can I determine who and why is filling the swap ...
0
votes
1answer
334 views

Pacemaker monitoring mysql

I have Pacemaker+Corosync set up to manage a shared IP address between two Mysql boxes in Master-Master/Active-Passive setup (using interleaved primary keys). I have Pacemaker set up to manage the ...
2
votes
1answer
1k views

MySQL Eating CPU Usage (Urgent)

Recently, I purged the cache files for my website and now MySQL is eating up CPU up to 100%. It slowly grows from 10% to 100% within 5min and so the server crashes. Fortunately, I turned stopped the ...
0
votes
1answer
163 views

Does phpmyadmin create use its own database?

I just ran a quick check of all installed databases on my system (something I'd never done before) and I recognized all of them except for one. The database name is phpmyadmin_[random string]. I'm ...
0
votes
5answers
265 views

Is blocking all traffic to MySql port, EXCEPT from own server IP, a good security measure?

As the title says, would this help? Imagine a classifieds website, where users simply login, logout, post classifieds, delete classifieds etc... All with PHP and mysql. I have my own server, with ...
0
votes
1answer
458 views

Possible to connect securely to remote MySQL using SSIS?

I've downloaded an ADO.NET and ODBC connector from the MySQL website. I'd like to access a remote MySQL server from within BIDS with the goal of importing the remote data and populating a local SQL ...
0
votes
2answers
119 views

My Sql update gone wrong

Upgrade from version 4 to version 5 and now the databases are missing and I have no idea where to find them. They are some *.frm files but how to fix it?
0
votes
1answer
182 views

mySQL process overloading server - Need Help

I ran into an issue the last few days, I have a database server 2 Quad Core Processors and 24 gb of ram, recently we have come across a big issue the server is running normally at about 130% cpu then ...