MySQL is an open-source database owned by Oracle.
-1
votes
0answers
11 views
How to increase the size of rootfs? [migrated]
So I got this error today and decided to investigate:
/etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!
I'm not sure how... but I've filled up my rootfs
...
0
votes
0answers
16 views
Why does change tmp location for mysql increase disk latency, decrease CPU load, & whole lot more
LAMP question. My host company said they moved the location away from the default tmp location to a new location (dedicated server) because they thought that maybe the default was getting full ...
2
votes
1answer
53 views
Percona and MySQL audit
I am trying to audit MySQL commands for users on Percona.
Current version of Percona is 55-5.5.22-rel25.2.237.rhel5.
The following URL gives guidance, however I do not know how to get it working.
...
-2
votes
1answer
29 views
can not find mysql after Homebrew install [closed]
I installed php54 with mysql, but I can not use
mysql -u root
in terminal to access mysql (error: does not recognize command), but
phpinfo()
tells me it is installed
what can I do?
UPDATE
I ...
2
votes
1answer
45 views
PHP CLI: Call to undefined function mysql_connect() even with mysql module enabled
I try to run a PHP script from the command line, but get the following error:
Call to undefined function mysql_connect()
However, the mysql module is loaded:
root /var/www/scripts # php -m | grep ...
-2
votes
2answers
26 views
Mysql on MAMP - enabling binary log [closed]
I'm trying to enable the binary log on MySQL on my MAMP setup. I'm fairly new at getting the setup and intricacies working for MAMP and at using terminal commands on mac, so I'm probably asking ...
2
votes
1answer
25 views
mysql man pages options apearing with question marks
In the man pages of mysql(mysql, mysqladmin) the options appears with '?' instead of '-a, -p, etc', other commands are not affected
Centos 6.4 min install
0
votes
2answers
50 views
extract file on remote server without SSH access
The following works as expected:
# mysqldump -uroot -pPasswd central conc_passenger --no-create-info --compact | mysql -h192.168.50.51 mysql -uroot -pPassWord someDB
This works as well:
# ...
0
votes
0answers
20 views
Multi Engine GUIs [closed]
I have several instances of SQL Server, MySql and Oracle. Soon, I will have to deal with PostGre and Sysbase instances too.
I am wondering if there was a good paid Multi Engine GUI where I could ...
-2
votes
0answers
32 views
Connect to Amazon RDS instance from local machine [closed]
I am trying to connect to a remote RDS Mysql instance but I am having no luck. I have added my IP to the CIDR/IP whitelist. I actually even tried adding 0.0.0.0/0 to the whitelist, but no luck. The ...
0
votes
1answer
44 views
How to properly migrate mysql server?
Currently I am dealing with server migration.
I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases.
All I need is somehow safely and fast ...
0
votes
0answers
32 views
Mysql using high amount of ram
Good morning,
Looking at the mysql server running on the server, under top it's listed as using 40% of memory (server has 2G).
But when I look into the mysql server, it doesn't seem to stack up.
...
0
votes
1answer
42 views
How to arrange a replication in mysql?
Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that, no surprisingly, database is the bottleneck. I have two servers to handle the site: A ...
-1
votes
0answers
26 views
MySQL replication generate huge disk write IO
Noticed that MySQL replication is generating enormous disk write activity
iotop 10-20Mb/s
AWS volume monitor - 700-800 IOPS
And it lasts for hours. Historical graphs show that this repeats every ...
-1
votes
1answer
37 views
Random Web Server Performance Issue [closed]
I've got a web app (apache, php,javascript,ajax,mysql) that suffered horrible performance on my system from 3am to about 10am and I'm trying to figure out what is going on.
Verified with the ...
0
votes
2answers
34 views
Reach a MySQL instance through multiple tunnels
I've a MySQL instance running on a server that I cannot reach directly but only through another server, so I have to reach it like:
[local] --> [server1] --> [server2]
Which command should I ...
0
votes
0answers
16 views
Managing db users for embedded app, usernames/pwds managed by third party
We are developing an API, and I have been tasked with integrating a frontend web application using our API into our developer portal. Our portal is provided by a commercial API management system, so ...
0
votes
0answers
14 views
How to debug a db memory-leak causing mysql to go before it's own limits? [migrated]
We are having a problem with one of the database server of one application, possibly caused by some code that is creating a problem in the way Mysql manage it's memory.
Until the second week of ...
-1
votes
3answers
48 views
Reinstall mysql and keep mysql data [closed]
In Debian, /root/bin folder was deleted.
The biggest problem is that mysql is missing. When I type:
> mysql
-bash: mysql: command not found
I have all data in /var/lib/mysql. How do I install ...
-1
votes
0answers
27 views
Using Mysql LOAD DATA INFILE via pipe in cygwin [closed]
I want load data for mysql erver from pipe file on cygwin
then I build a simple table like below:
$cat person.sql
CREATE TABLE `person` (
`id` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
...
0
votes
0answers
40 views
MySQL replication & logrotate
I'm using MySQL Master-Slave replication for backup purposes (for a few days).
Today after changing to expire_logs_days = 3 on master and slave I got this message (from slave):
...
1
vote
0answers
59 views
MySQL 5.6.11 mysql-bin.000x file corrupt when I stop mysql [closed]
Am running MySQL 5.6.11 in production with bin-log enabled. As a routine check, I check the status of the server. Performed service mysql restart after service mysql status reported ok. MySQL server ...
0
votes
0answers
48 views
Setting mysql slow query to less than 1 second [migrated]
I have a heavily loaded LAMP system serving about 40 requests per second and doing about 300 mysql queries per second. Here is the output of mysqladmin status
Uptime: 5051 Threads: 1 Questions: ...
0
votes
0answers
10 views
postfix setting outbound ip from mysql database
At the moment I am setting the smtp_bind_address using -o in master.cf.
As this complicates the process of adding a new virtual domain (with a specific ip) alot, I would really like a solution how I ...
-1
votes
0answers
24 views
error while loading shared libraries: flateReset [closed]
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
2answers
37 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
21 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
41 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
41 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
24 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
25 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
42 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
32 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
34 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
23 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
32 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
90 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
29 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
89 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
36 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
35 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
53 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
24 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
16 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
23 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
37 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
34 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
33 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 ...
