MySQL is an open-source database owned by Oracle.
0
votes
0answers
12 views
error while loading shared libraries: flateReset
I just wanted to updated my debian 7 system running on a raspberrypi.
After using the "apt-get upgrade" command which updated my mysql-server, the mysql server doesn't come up anymore, showing:
...
0
votes
1answer
14 views
Looking into AWS services. What services do I need to transfer my servers over (MySQL & PHP running on Windows 2008)?
I have two servers that I am thinking of moving to AWS (or is Azure a better option?) if it saves me money and helps reliability and scalability:
Windows Server 2008 running IIS web server with PHP. ...
0
votes
0answers
11 views
OpenSuse MySQL server not releasing file handles; receiving too many open files error
I'm running into an issue where a MySQL server has too many open files. Unfortunately I'm not a sys admin or dba, but I have responsibility to keep this server running. I'm looking for suggestions as ...
-1
votes
1answer
31 views
Mounting ssd. Expectations vs reality about server load
I'v installed SSD on my server and moved tmp folder, mysql data folder and 2 most loaded websites(php) on it.
I'v expected that server load will fall a little bit, but it seems that it is on the same ...
0
votes
1answer
26 views
MySQL high memory consumption with poor performance for queries, which settings to tweak?
I have a scenario with a rather large database. It is about 3GB and I'm hitting some walls with system resources. For example, here is an example of htop output:
You can observe that there are a ...
-1
votes
1answer
18 views
mysqldbcopy command not found
I'm getting -bash: mysqldbcopy: command not found error even after sudo su-.
My MySQL version is mysql Ver 14.14 Distrib 5.5.25, for Linux (x86_64) using readline 5.1
Do I need to install MySQL ...
0
votes
0answers
13 views
Where condition execution sequence in MySQL [migrated]
I am using MySQL 5.0.88. I have a query like
select DISTINCT party.id FROM party LEFT join party_identifier AS pi ON pi.party_id = party.id WHERE (pi.source_note=? AND first_name LIKE ? OR ...
-1
votes
0answers
24 views
MySQL server with InnoDB is a memory hog
We have a high transactional volume MySQL server on an Amazon EC2 large server. In the past, it would run for maybe seven to ten days before eating up all the available RAM and crashing the server. ...
0
votes
0answers
21 views
Tomcat on Linux - won't close socket
When I keep sending http requests to my webserver, it stops responding and I'm stuck in a white screen saying, 'waiting for xxx'. It goes unresponsive.
This only happens on Linux.
Also I don't see ...
-3
votes
1answer
21 views
phpmyadmin keeps redirecting to login page without error [closed]
Suddenly, my phpmyadmin page can't enter the main page and keep redirecting to the same login page without error messages, although I can login to mysql through shell. I don't updates or changes any ...
0
votes
0answers
31 views
Strange CPU cycles and slow queries
My database (XAMPP) runs at almost 350 questions a second is 99% in the SELECT category. The website I'm running is heave on timed ajax calls that refresh data every 10 seconds. During this, there are ...
-3
votes
0answers
19 views
MySQL status, Threads_created is 116700, how it that possible? [closed]
I ran "SHOW STATUS" and got Threads_created value equals to 116700. How is that possible, can I trust this value and what should I do about this? (Wanted to tune thread_cache_size first, but not sure ...
0
votes
1answer
26 views
Is there a log to see when a user is trying to access file/directory that he doesn't have permission?
My database is failing to replicate and the only clue in the error log is Operation Not Permitted, which I am guessing is file access permission failure either on donar or joiner. Is there any file ...
0
votes
1answer
28 views
Failed mysql upgrade to 5.5 on debian wheezy
When upgrading debian squeeze to wheezy, the upgrade of mysql to mysql-server-5.5 fails:
# apt-get dist-upgrade -u
...
Setting up mysql-server-5.5 (5.5.31+dfsg-0+wheezy1) ...
[ ok ] Stopping MySQL ...
0
votes
2answers
27 views
Export import sql database without downloading
Recently i need to change my server to another webhosting providers server. To do that just discovered that my MySQL database size is too much to download & upload with the access that I have.
...
1
vote
1answer
67 views
Error with MySQL server: Can't create a new thread (errno 11)
I am currently stress testing my PHP, MySQL application hosted on AWS EC2 using Amazon Linux. After reaching certain number of users DB starts to give error: Can't create a new thread (errno 11); if ...
2
votes
2answers
25 views
Innodb one file per tablespace
I'm walking into an environment that uses MySQL and Innodb as the storage engine. I'd like to enable innodb_file_per_table to increase performance. Considering all of the databases/tables are ...
-1
votes
0answers
16 views
What server to choose for an enterprise web application [duplicate]
I am the IT administrator in a university that has newly proposed for a complete web-based MIS database written in PHP (Codeigniter framework) which will be installed on a windows server. In this ...
0
votes
0answers
19 views
downgrading from Mysql-5.6 to regular mysql 5.5 default in Ubuntu
I installed mysql 5.6 with dpkg to play with it and since my CREATE USER command kept disconnecting the mysql daemon and could not find a reason on Google why it is doing it.
I wanted to switch back ...
1
vote
1answer
39 views
Mysql crashing due to InnoDB not able to allocate memory
MySQL crashes every now and then due to, I believe, a large request hitting it above the innodb-buffer-pool-size set in my.cnf (currently at 210M), which I needed to set for mysql to start in the ...
0
votes
1answer
20 views
MySQL Process Big
Ok, so I don't know if this is a repeat question so I'm sorry if it is (I couldn't find anything like it after searching =/)
My server seems to be running what seems to me a larger than normal mysql ...
0
votes
1answer
13 views
Connect to Database on Same Network But Different Machine From Mysql Workbench
I've got a web server/database server running on my local network. I've set the static ip to 192.168.1.210. I've installed mysql on the server, set the my.cnf bind-address to the static ip.
I am ...
0
votes
0answers
18 views
Mysql Server Performance Hit from Triggers
I have 50 databases on a reasonably spec'd Debian MySQL Server v5.1.63 The size of these database vary from about 3MB -> 7GB each.
Each database has a history database and most( but not all) tables ...
0
votes
1answer
36 views
DB Server location in relation to main Web Server
Ive recently taken the plunge and started renting a VPS for my web projects. As the demands on the system get higher so do the costs. MY VPS is US based due to costs, but Im based in Germany.
...
0
votes
1answer
33 views
Mysql working remotely but not localy
I have a cloud based application in PHP with one master server and multiple slaves. All servers are using master's database (mysql).
I already done this steps
CREATE USER 'mysql'@'%' IDENTIFIED BY ...
-1
votes
1answer
28 views
Reloading MySQL my.cnf changes
Do you have to restart MySQL to edit changes? Or can you edit them on the fly and restart MySQL or make the changes inside MySQL?
This server runs 100s of website that are active and I don't really ...
-1
votes
0answers
28 views
Mysql query for adding and replacing data [closed]
Hi i am having problems with these queries. maby you guys could help me how to do them.
I have 2 tables. with these colums:
table1
Mac, Signal, latitude, longitude
table2
Mac, signal, latitude, ...
-1
votes
1answer
28 views
InnoDB Failure of some kind [closed]
I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked.
InnoDB is listed under SHOW ENGINES;
Any idea ...
0
votes
0answers
18 views
Softirq has raisen without reason
Monitoring munin stats I found that on CPU's graph there was softirq value increased.
What might be the reason? Currently I am experiencing problems with mysql cpu consumption. But how those things ...
-1
votes
0answers
19 views
An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full - wamp server [closed]
I am creating a browser-based game using PHP,Javascript and HTML5 and I am testing it on a local wamp server. However sometimes I get the following error:
Warning: mysqli::mysqli(): (HY000/2002): An ...
0
votes
1answer
23 views
Getting mysql slow query report from 20 GB file
I am trying to get slow query report from mysql generated slow query log. I tried myprofi but unfortunately my windows server keep crashing when I run myprofi php script.
I also tried perl script ...
0
votes
0answers
36 views
MySQL - Adding another master to an already configured cluster
We currently have a MySQL 5.1 Cluster of two master servers.
Eventually we would like to move to 5.6, while also adding 2 more servers.
What is the best way to achieve this? This is what i had in ...
0
votes
1answer
39 views
How to block an IP, if it is making many http/apache/mysql requests in a second?
If some one tried force burst attack on my website, how can i block their IP address?
I mean, I want to block an IP if I am getting many http/Apache/SQL requests per second from it. How can i prevent ...
0
votes
0answers
27 views
Mysql won't start after replacing data in datadir.
so I have a little problem. I had errors with our old system and was unable to backup the old databases properly so I went ahead and backed up the datadir which had all of the databases folders inside ...
-5
votes
1answer
33 views
Process still running from a deleted chroot? [closed]
so I come to you with a somewhat interesting problem.
I had a chroot running that had an entire lamp server installed and running on it. I tried to purge and remove the lamp server but messed up ...
-1
votes
1answer
26 views
mysqld 5.6 service error 1067
Upon running this service
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56
I get this error
windows could not start ...
0
votes
2answers
40 views
How to migrate old redmine server to new one with version upgrade and database change
I am planning to migrate my redmine(1.0.5) to a new machine.
With this migration, I would like to upgrade redmine to latest version and change my database from MySQL to Postgresql.
My plan A is:
...
0
votes
1answer
39 views
Install Navicat for MySQL on Linux Ubuntu 12.04
How do I install Navicat on Ubuntu Desktop 12.04?
I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
1answer
18 views
Ubuntu 12.04 VPS doesn't boot with mysql in nsswitch.conf
1and1 VPS ("dynamic cloud server") does not boot any more as soon as mysql lookup is enabled in nsswitch.conf - any suggestions appreciated.
Minimal setup to reproduce the problem:
install Ubuntu ...
-1
votes
1answer
37 views
Rebuild rpm under centos [closed]
i need to install MySQL 4.1 under a Centos web server(My centos release is 6.4, x86_64),
can anyone please help me with rebuilding so many dependencies?
I use rpmrebuild command and gcc, gcc-c++ are ...
0
votes
0answers
16 views
How do I change MySql datadir on windows? [duplicate]
I'm trying to set MySql data directory to a place on another drive.
Here's what I did:
Created the directory on the drive
Created C:\Program Files\MySQL\MySQL Server 5.6\my.ini with following ...
0
votes
1answer
17 views
Heroku : Support of InnoDB
Does Heroku supports MySQL (esp. InnoDB database engine) ?
I see there is ClearDB add-on, but it didn't state it supports InnoDB or not.
0
votes
1answer
31 views
Abnormal server behaviour MySql time-out
I have a development server that I use to host a mysql database for an Asp MVC web app I'm developing.
When I work from my home, everything works fine.
I sometimes work from my parent's house, and ...
0
votes
0answers
54 views
can't insall mysql-server after upgrade to debian wheezy
I upgraded debian to wheezy and got errors with mysql-server so I removed it. Now I can't reinstall it. I get:
$ sudo apt-get install mysql-server
...
Unpacking mysql-server (from ...
0
votes
1answer
41 views
How to Handle 100 Million Users - MySQL or NoSQL [duplicate]
I need a solution for social networking webapp, the DB structure is
users - login credentials.
user_order - user orders.
user_friends - user friends.
We expect a solution to handle 100 ...
0
votes
1answer
26 views
Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log'
I changed the value of mysql's general_log_file variable to something else, and now I'm trying to change it back to what it was originally, /var/lib/mysql/ubuntu.log. But when I do:
SET GLOBAL ...
-1
votes
0answers
14 views
Upgrade to mysqlnd on ubuntu 12.04
Ubuntu 12.04 comes with the old mysql driver.
I tried replacing it with the new driver via
apt-get install php5-mysqlnd
but afterwards none of the PHP apps (wordpress, phpmyadmin) could connect to ...
0
votes
1answer
24 views
Add causing php-script to mysql-slow.log
If you enable the line
log_slow_queries = /var/log/mysql/mysql-slow.log
in
/etc/my.cnf or /etc/mysql/my.cnf
then that will log all queries, that take longer than the setting in long_query_time.
...
0
votes
1answer
29 views
Give non-root user access to log into phpMyAdmin [closed]
I'm attempting to give a non-root mysql user access to log into phpMyAdmin and only see the DB they have access to.
I've already looked at the following articles and tried their advice:
Configuring ...
-1
votes
1answer
22 views
mysql not allowing to connect from remote ip [closed]
I have added the remote ip in white listed IP's of the cpanel of my website
and in my.cnf file there is no bind-address= altogether and I don't have skip-networking enabled in your my.cnf.
Not sure ...
