MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"), but is often pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named for original developer Michael Widenius's ...
0
votes
1answer
44 views
Sudden load average increase with same number of users and having changed nothing
I'm very novice in termos of administrating a server.
Website was running fine till yesterday, load averages under 1.
Suddenly, yesterday it stopped working fine, I was getting load averages to up ...
0
votes
0answers
15 views
PHP MySQL script - sometimes it works well, sometimes the connection resets
I have a PHP script that queries a MySQL table and exports to .csv. Pretty basic stuff. About 1000 row table.
The problem I'm having is that sometimes it will work instantly (download the .csv), ...
0
votes
3answers
194 views
What database server will benefit from 4 CPUs
I use MySQL server on Debian GNU/Linux machine with 4 CPUs (Linode 4096) and there are performace issue on havy load (in the middle of the day) but machine is not overload only queries are slow.
What ...
0
votes
1answer
15 views
What causes “InnoDB: Corruption of an index tree” error
Today I experienced this error a second time in two weeks and I wonder why that is?
Is it more a hardware- or software-related thing? (e.g. what should I check?)
That DB server didn't have any ...
4
votes
1answer
37 views
How to move from MySQL 5.0 to 5.5?
I'm currently on Windows 2003 using MySQL 5.0.54a and I'm moving to Linux which has MySQL 5.5.24.
Is this a simple exercise of using mysqldump to export the data from 5.0.54a and then import it into ...
-2
votes
0answers
28 views
Can't locate Bugzilla/Search/Recent.pm in @INC
Software error:
Can't locate Bugzilla/Search/Recent.pm in @INC (@INC contains: . lib C:/Bugzilla/perl/perl/lib C:/Bugzilla/perl/perl/site/lib) at CGI.pm line 30.
BEGIN failed--compilation aborted at ...
3
votes
3answers
87 views
Can disk space be the reason for a server crash?
After looking into the MySQL error file, I found an error regarding disk space. Now I think its the reason for MySQL crashing:
[root@xxxx ~]# cat /var/lib/mysql/xxxx.com.err
120528 17:45:05 [Note] ...
2
votes
2answers
33 views
Mysqld InnoDB crash
my MySQL server just crashed and I cannot restart/recover it. I've tried:
/etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . ...
1
vote
1answer
17 views
Reduce Tomcat6 memory footprint
This is my setenv.bat (windows installation).
It's the MySQL enterprise monitor service manager.
set JAVA_HOME=D:\MYSQL_~2\SERVIC~1\java
set JAVA_OPTS= ++JvmOptions="-XX:+UseParallelOldGC" ...
-1
votes
1answer
25 views
How to Plan for scale on my rackspace cloud server
I currently have a couple of cloud servers on Rackspace
For application NGINX+PHP+Memcached+APC 2GB instance
For Mysql Database 1GB instance
Our site at the moment is not very heavy in terms of ...
-2
votes
0answers
27 views
Nodejs server for production
I want to use nodejs as a standalone production server (e.g not behind nginx), using expressjs, with websockets (nowjs) and mysql for the db. Pages are sent over https. Users will be able to login and ...
2
votes
4answers
66 views
MySQL Error: Too many connections
I get too connection error on my site from today...
PDOException: SQLSTATE[08004] [1040] Too many connections in lock_may_be_available() (line 167 of ...
2
votes
1answer
17 views
Do I need to use apply-log with innobackupex
I'm using innobackupex to backup my databases like this:
usr/local/bin/innobackupex --user=bkpuser --password='example' --rsync \
--no-timestamp /pathtobackup 2> /pathtobackup/innobackupex.log
...
1
vote
2answers
52 views
Distributed mysql synching
I'm running a server which is connected to an SQL host. I have an another server and I decided to run it as an SQL backup. So, I have 3 of them. Srv A is the SQL host, srv B is the backup.
I know ...
0
votes
0answers
11 views
Unable to connect to mysql through JDBC Connector externally
I did silent installation of mysql by using following commands:
msiexec /i "mysql-5.5.8-win32.msi" /qn INSTALLDIR="C:\Program Files\MySQL" /L* "w"
echo MySQL mysql-essential-5.0.88-win32 installed ...
-3
votes
0answers
21 views
WAMPstack (BITNAMI) Mysql not working anymore [migrated]
Ok, I'm in big trouble. On my computer I have bitnami WAMPstack installed. And today my MySQL just isn't working anymore. I changed NOTHING. The service just stops by itself. If I restart the service ...
-4
votes
0answers
24 views
What specs should I seek in a medium-load web server? [closed]
I'm currently in the market for my first server, which I'll be using as a test & backup server as well as handling backend processing for a variety of web services getting 20,000-30,000 hits a ...
-2
votes
0answers
24 views
Mysql doesn't start at Mac OS Lion startup [closed]
I installed Mysql server on Mac OS Lion and in my systems options I checked the option that mysql automatically starts whenever I start Mac OS. But it doesn't. I always have to start it on my own! Can ...
0
votes
1answer
23 views
MySQL Should each Database be managed by a different user?
Should I have a different MySQL user for each database so that if someone gets access to a mysql user they cannot effect the others?
If so how would i go about doing this?
3
votes
1answer
26 views
What privileges does a MySQL User need for Wordpress?
I need to create a new MySQL user to manage my wordpress site. What privellages are needed for wordpress?
I assume INSERT is also needed and maybe DROP?
Example
GRANT SELECT ON database.* TO ...
0
votes
2answers
30 views
Slow mysql performance between 2 servers
I have 2 servers, both running Ubuntu server 11.10.
The first server runs Apache and PHP and it connects to a Mysql database on the second server.
The problem is slow mysql response on the second ...
0
votes
1answer
69 views
MySQL, php-fpm, APC, Varnish and Nginx optimization for WordPress/W3 Total Cache?
I'm setting up my first VPS and it seems to be working well. Installed Nginx, php-fpm (as a unix socket), APC, Varnish and MySQL on Ubuntu 12.04 server with OnApp, and everything works and is damm ...
2
votes
4answers
54 views
How can I rebuilt MySQL replication without dumping the master?
Our MySQL database has grown fairly large, and I am running with master replication. Replication is broken. I am trying to rebuild the second master without freezing up the first master in doing a ...
-1
votes
1answer
26 views
How much ASP.NET and SQL Server will cost me more?
I want to develop a web application using ASP.NET and SQL Server. However, my friend told me that using MySQL will cost me far less. I just want to know how much SQL Server cost me more than MySQL? Is ...
1
vote
2answers
33 views
MySQL stopped working on debian squeez
Suddenly and without any reason mysql stopped working.
netstat -tap
does not list the mysql process. I tried
/etc/init.d/mysql restart|start
But his produces an error message:
...
0
votes
0answers
22 views
Create image (EBS AMI) takes forever - possibly caused MySQL Server to break?
I'm trying to create an EBS AMI from my running EC2 instance to reuse my LAMP fully configured (for my needs). I got my website up and running yesterday on this EC2 instance my MySQL was working fine ...
2
votes
1answer
51 views
Is MySQL VSS “Safe” Yet?
From what I'm reading, there's plenty of statements that MySQL is at least partially VSS (Volume Snapshot Service) aware, with caveats etc. but all of the things I can find online regarding this are ...
0
votes
1answer
40 views
Proper mysql max_connection
I'm getting ready to launch a new site and we are expecting traffic to be fairly decent. What should I set Mysql max_connections to to avoid any problems.
Currently the server is set at 4GB ram, ...
1
vote
2answers
45 views
MySQL replication automation?
I was wondering if there are any MySQL replication automators or managers that can take over the tasks of deploying MySQL slaves from a master.
I come from an old school server management background, ...
1
vote
1answer
26 views
How to restrict mysqlimport usage?
I have a need in my PHP application (using Zend Framework for what it matters), to import a CSV file into a MySQL database.
I currently do this by using shell_exec() to run a myysqlimport command ...
1
vote
2answers
32 views
Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?
We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
0
votes
1answer
28 views
All memory consumed by MySQL [closed]
Possible Duplicate:
linux eats all memory, seems like it is not for specific application
TOP shows that almost all the memory is consued on a dedicated MySQL box.
I stopped mysql and ...
-1
votes
1answer
27 views
Mysql server setup configuration
We have a new centos 6.2 setup. Below is the configuration file. The machine is going to be fully innodb and it has 8Gb ram. What else must I include in the .cnf? I know one major thing is the ...
3
votes
1answer
20 views
Mysql dump crashed table for repair
I have a large table which has crashed however when I try to run a repair on the server I have problems with not enough disk space. I would like to dump this table to my local machine for a repair but ...
1
vote
1answer
19 views
mysql command line show statements a sql script executes?
I'm a long time postgres user, but am now looking after maintenance for mysql databases. One thing that I'm used to from postgres, is when you run a sql script it will output on the command line what ...
3
votes
3answers
37 views
Use LDAP for MySQL authentication?
We run a couple dozen different MySQL servers for our users. Managing the Account Passwords on these servers is painful.
Are there any plugins which would allow us to use LDAP to help manage the ...
0
votes
0answers
15 views
Schedule replication of MSSQL Views to MySQL Remote database
I have a Microsoft SQL Server 2005 Database inhouse i've to publish some information on the internet and i can't (for security policy) query this database from the web server.
So i come up with the ...
1
vote
1answer
29 views
Can I use an old MySQL database 4.1 data in a 5.0 server?
I'm not an advanced database user, so now I would move an old site to a new hosting where I have all new material, can I use an old MySQL database 4.1 data in a 5.0.51a server?
0
votes
1answer
9 views
MySQL reinstallation
I want to reinstall MySQL Server. I cleared register before reinstallation, but when it is configuring it says
error 1045 Access denied for 'root@localhost'(using password NO)
How I can reinstall ...
0
votes
1answer
17 views
Can't access Kloxo after restarting MySQL 5.0?
I've made some changes to My.cnf to configure Mysql server as below:
innodb_buffer_pool_size = 50M
innodb_log_file_size = 15M
bulk_insert_buffer_size=25M
log-slow-queries = mysql-inja-slow.log
...
-4
votes
1answer
26 views
Multiple sites with same DB good idea? [closed]
I am planning to setup a different websites with same DB server(mysql). What i want to know is, Is it a good idea to do that?
0
votes
0answers
22 views
Can't get MAMP Pro 2.0.5 to work
I've been using MAMP for years. Rarely had any issues. I'm currently running OSX 10.7.4. I just upgraded MAMP to v2.0.5 and bought/installed MAMP PRO... but I can't get it to work. I can still you ...
0
votes
1answer
23 views
Installing PHP 5.4 with pdo_mysql
I'm try to install PHP 5.4 and I want to use PDO with the MySQL driver.
However, it seems the php54 package does not configure with the --with-pdo-mysql flag. How can I install this?
2
votes
3answers
58 views
MySQL permits passwordless logins, wont let me run anything
I was attempting to allow remote logins to MySQL, so i changed /etc/mysql/my.cnf to bind to 0.0.0.0 instead of 127.0.0.1 (I was gonna put it right back, I promise!), but it didn't work so I attempted ...
0
votes
1answer
24 views
Can't remove partially-installed extension
I'm on an Ubuntu 11.10 server with PHP 5.4 installed from a PPA. I had the MySQL library installed (php5-mysql) but wanted to try out the native driver (php5-mysqlnd), so I ran sudo apt-get install ...
0
votes
1answer
20 views
Resolving unmet dependancy in ubuntu 10.04
I am geeting the folowing error when i tried installing beanstalkd (sudo apt-get install beanstalkd) and I even tried -f option but none helped what can id do
Reading package lists... Done
Building ...
1
vote
2answers
37 views
IPTABLES issue - trying to DROP any connections to 3306 except from 127.0.0.1 and VPN
I have a VPS where I have successfully set up VPN. I connect with OpenVPN client. The VPN server interface is 10.8.0.1 and the client receives 10.8.0.? IP. And I am able to ping 10.8.0.1. I also seem ...
1
vote
1answer
21 views
XAMPP MySQL batch file
I am using XAMPP to run Apache, PHP and MySQL on a bunch of remote laptops for our clients. It is just the XAMPP directory with all the files (thumbdrive version, no registry values are added or ...
2
votes
1answer
33 views
mysql won't autostart
I'm running ubuntu 10.04, since I upgraded to mysql 5.5 it stopped starting at bootime.
I tried sysv-rc-conf mysql on because it was actually set to "off" but still won't boot.
I have to manually run ...
1
vote
1answer
29 views
Howto restart a MySQL MMM cluster
little theoretical question. I'm done setting up a bunch of 2-node MySQL 5.1 clusters user the control of several MMM instances.
We started some testing, joyously kill -9 the writer nodes and all ...
