MySQL is an open-source database owned by Oracle.
0
votes
0answers
13 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
20 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
26 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
25 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
19 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
25 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
48 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
21 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
17 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
37 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
12 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
16 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
35 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
18 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
22 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
35 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
35 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
24 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
32 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
25 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
38 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
34 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
17 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
41 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
40 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
25 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 ...
1
vote
1answer
22 views
Django - cant connect to local MySQL Server through socket
I’m using Django Bitnami Stack on Amazon EC2. I’m attempting to sync the database for the initial setup but I am having problems.
When running the following command I receive an error message:
...
0
votes
0answers
18 views
Mysql Auto-Sharding [duplicate]
MySQL ndb cluster is supposed to auto shard the table data between nodes, however after setting up MySQL ndb I have added about 2000 records to the table. after looking at each data node i see that ...
-3
votes
1answer
45 views
Mysql Cluster Sharding/partitioning [closed]
Ok so i have mysql cluster setup but what i need is say table assets to be split among the nodes, not replicated. as the purpose of me setting up the cluster was due to lack of hard drive space so how ...
1
vote
1answer
32 views
MySQL Binary Logging Format - Disk Filling Up
I have a MySQL server instance configured with binary logging enabled. I don't do any replication, but the binary logs are part of our recovery plan - to be able to replay all the transactions since ...
0
votes
2answers
56 views
mysql 5.5 myisam db tunning
I'm using mysql 5.5 with myisam db.
Currently, sometimes the cpu usage of mysql will reach 200% CPU resource. And there are lots of queries 'waiting for table locking' in mysql. And at this time, the ...
0
votes
0answers
29 views
Best config for MySQL performance with medium to small queries with lots of power [duplicate]
I want to make our web-server perform the fastest possible and one of the main bottlenecks I see is MySQL. The software we're using is not developed by us and therefore we do not have control over the ...
1
vote
1answer
29 views
Dynamic column enumeration for preventing SQL injection
I have an application which is completely for internal use but I'm trying to make sure I have my bases covered on SQL injection. Unless someone else has some information to point me otherwise there ...
-1
votes
0answers
33 views
MySQL 3rd instance not working
i have installed 3rd mysql instance on my testing server.
2 instances already running without any issues.
when i installed 3rd instance by mysql-5.5.30 zip source, it installed successfully but when i ...
