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
43 views
How much load can a VPS server with these specs handle? [closed]
Processor Info:
Memory:
OS: Cent OS
I have a third party API I will be using, that will be feeding millions of possible queries every 30 seconds - 1 minute to my VPS. The datasets to be sent will ...
1
vote
0answers
18 views
MySQL user's grant are not working - hidden permission in mysql.db
I have a mysql user connecting from Server2 to Server1 over SSL (mysql 5.0.77).
Here is the grants for this user on Server1, (server2 has an ip in the range xx.xx.xx.%)
mysql> show grants for ...
0
votes
0answers
14 views
Two MySQL query results are different, but shouldn't be [migrated]
To the best of my knowledge, these results (especially the data in the 'destination' field) should be the same, but I can't find out why they're different:
mysql> select * from cc_did_destination ...
1
vote
0answers
14 views
Setting MySQL INNODB Compression KEY_BLOCK_SIZE
I recently started using the Barracuda InnoDB/MySQL table format which allows compression.
I compressed one of my tables by running:
alter table pricing row_format=compressed, key_block_size=8;
...
1
vote
3answers
61 views
mysql performance tuning, write, get db into ram
I am trying to improve the performance of a website by optimizing the Mysql server. In addition to general optimization I have a feeling that some write operations take an unacceptably long time.
The ...
0
votes
0answers
6 views
ODBC connection getting error
website hosted on cPanel, owner of site requires information from a remote MS access database which user has username/password and hostname/ip address for.
I assume I have to install some modules ...
2
votes
1answer
20 views
Running phpmyadmin on one cloud server and trying to access mysql on another cloud server
Just curious, if you have mysql on one server, and phpmyadmin on another server, mysql doesn't have to be running for PMA to get data from the remote mysql database right? (don't hate me if this is a ...
1
vote
0answers
16 views
MySQL and IIS latency While Running Stored Procedures
We have a stack running a custom application within a web page. There are two web servers running IIS behind a load balancer that communicate with a single database server running MySQL. All servers ...
0
votes
0answers
17 views
Trying to connect phpMyAdmin to remote mySQL server ( 2002: can't connect )
Trying to get phpMyAdmin to talk to a remote mySQL server. The config is below and there is already a user set up in mySQL DB to be able to log in from the specified host that PMA sits on. Hosting is ...
0
votes
0answers
22 views
MySQL socket with PHP and Python (MySQLdb)
Background info
I'm currently running CentOS (or Red Hat?).
uname -a gives (I edited out my domain name)
Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
1
vote
1answer
43 views
Trace MySQL processes
I am running a typical LAMP stack with Fedora: how do I find out which PHP script launched the queries which are shown when I run SHOW PROCESSLIST in MySQL?
I've read this article, but unfortunately ...
2
votes
1answer
26 views
How to store text inputs of unknown & varying size?
I am trying to create a table (or several) to receive user inputs (UGC). This content could vary in size from a single character up to a few hundred words. The input will be coded in utf8_unicode_ci ...
-1
votes
1answer
26 views
Redundant / partially duplicated data in a DB - how to structure?
I'm building a website for which a large amount of user generated data will be stored in a back end db and will be discoverable by all users.
By its nature, a portion of the user entries will be ...
2
votes
3answers
85 views
Need help for a Unix startup script
I am very weak on unix shell scripting. Is there a way to create Unix shell script which will start on server boot time only, and will execute the following commands in order:
# cd /mysql
# ...
2
votes
2answers
24 views
Does MySQL InnoDB engine use tablecache?
Does MySQL InnoDB engine use tablecache? I migrated from MyIsam to Innodb as the table engine and the monitors for "table-cache" hitrate are super low. Does Innodb use table-cache?
0
votes
1answer
37 views
MySQL: Load_file - list files
Is it possible to list files with MySQL's Load_file()? Is there any meta file that would contain the file names or so? Thanks
-2
votes
1answer
52 views
Is there a PHP cloud host that supports multiple databases for one app? [closed]
Our app connects to multiple mysql databases. We are looking into cloud hosting solutions as an option versus a dedicated server. We've looked into PHP Fog, but they do not support multiple databases ...
0
votes
1answer
29 views
installing mysql innodb engine on redhat box
I'm using SL6.1 on an X86-64 server box.
For whatever reasons, it looks like the stock RHEL-anything is not going to be including the mysql innodb engine anytime in the foreseeable future:
...
1
vote
1answer
31 views
MySQL crashing when trying to restore from dump
So I had a very large corrupt innodb table.
mysqld would crash whenever I did a check table on it.
I did a innodb-force-recovery=1 and did a dump of the table.
No errors showed up.
I dropped the ...
2
votes
3answers
46 views
MySQL Master-Master Replication Lag
I have configured two MySQL servers (MySQL-1, MySQL-2) in master-master replication in the same datacenter using a local backend connection with the following options:
...
0
votes
1answer
28 views
How to store all outgoing mails from postfix in DB (MYSQL)
I have a postfix setup for my web server and I want to store every outgoing email from the server to a database. Does any one know how I can achieve this. FYI I just use this server to send emails and ...
1
vote
0answers
17 views
Writing to Net and Cleaning up in Show Full Processlist in mysql, what does it mean?
Sometimes when i run show full processlist, it come with these in status, ie:
with this query:
select count(*) as ...
could it be some problem?
0
votes
1answer
16 views
php script to restart remote mysql
I have 2 webservers and 5 mysql servers.
Our website has a lot of traffic and one of the mysql servers goes down or gets flooded and i need to restart it (/etc/init.d/mysql restart).
Can i do it via ...
0
votes
0answers
10 views
MySQL tables/databases into different disks [migrated]
I am aware that there is a possibility to have a single database server with many tables/databases, and you can separate some of those tables/databases into separate disks.
Lets say you have 5 ...
1
vote
2answers
27 views
mysql not to print selects output to terminal
Quick question:
I have created come commands that will warm-up my DB.
The thing is that those selects are large.
When I do such a select I get all the "jiba-jaba" into my terminal window.
How can you ...
0
votes
2answers
50 views
Amazon RDS to EC2 replication [closed]
Possible Duplicate:
Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?
My read-intensive application needs to scale horizontally. It will be deployed by ...
3
votes
1answer
151 views
+50
Pacemaker Active/Active haproxy load balancing
I am using Haproxy to load balance replicated mysql master servers. I am also using Heartbeat and Pacemaker for Active/Active ip failover with two virtual ips on the two load balancers for web server ...
1
vote
1answer
32 views
How to enable mysqli extension on redhat?
My php.ini says:
Additional .ini files parsed
/etc/php53/php.d/curl.ini,
/etc/php53/php.d/fileinfo.ini, /etc/php53/php.d/json.ini, /etc/php53/php.d/mysqli.ini,
/etc/php53/php.d/mysql.ini, ...
2
votes
2answers
31 views
Installing/Configuring PHP to work with tomcat5 and mysql on CentOS
I need to install php on a CentOS machine and configure it to work with tomcat5 and mysql
Anyone know how i can do this?
the home folder for tomcat and mysql is
/usr/share/tomcat5
/usr/share/mysql
...
0
votes
0answers
23 views
Mysql is not converting strings to integers?
I just reinstalled mysql on debian and now the following is not working
SELECT * FROM table WHERE id='1';
It is returning an empty set. This was working before. Normally doesn't it convert the ...
0
votes
1answer
20 views
How to modify a table so that CHECK TABLE fails in mysql 5.1?
I want to simulate an error for a table so that CHECK TABLE will fail.
Is there a way to simulate it so that CHECK TABLE on the table will fail ?
1
vote
1answer
25 views
MySQL file limit. Error Out of resources
I was benchmarking my database the other day using mysqlslap, and I ran into a "Out of resources when opening file '/tmp/somefile' (Errcode: 24)" error.
I with a few click on google, I found a ...
0
votes
1answer
18 views
Apache config, why it's always says The Requested operation has failed, I can not run apache?
I'm already tired, I can not start apache, I'm reinstalled it a few times, but it doesn't work, was a different situations, such as firewall or whatever, but now I can not run apache ordinary cause it ...
0
votes
0answers
10 views
InnoDB not enabled [migrated]
I have a mysql database that when I run SHOW ENGINES; innodb does not show up as an engine.
This seems strange as I have an identical server setup where innodb is enabled and in use.
I have checked ...
0
votes
0answers
18 views
Good strategy to replicate MySQL data [migrated]
I'm working on MySQL database, well i have a master instance and slaves, and i need to add a new slave to Master. I adopt a simple strategy to do so: Stop slave, import data to new slave, and finally ...
2
votes
2answers
87 views
How to sync two MySQL tables (on demand or via cron)
I have seen Cron sync mysql tables . But I cannot use replication. I used to use percona-toolkit and it worked perfectly. I could run the sync command on demand or just run it via cron. It would ...
0
votes
0answers
15 views
Populate MySQL system time zone tables
I have some queries that make use of CONVERT_TZ(), for which the time_zone* tables in MySQL's system database should be populated. Usually I would just run mysql_tzinfo_to_sql /usr/share/zoneinfo | ...
1
vote
0answers
8 views
How can I set the original PHP mysql api driver to auto-reconnect by default in MySQL version > 5.0.13?
MySQL server turned off auto-reconnect by default in version 5.0.13: http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html
In MySQL 5.0, auto-reconnect was enabled by default until MySQL 5.0.3, ...
1
vote
1answer
21 views
MySQL lowering wait_timeout value to lower number of open connections
I run a rather busy site, and during peek hours I see over 10.000 open connections to my database server on my webserver when a run a netstat command. 99% of the connections are in the TIME_WAIT ...
0
votes
2answers
86 views
Adding Drupal to my server means it now has performance problems
I have a vb 3.8.4 forum and a drupal pressflow 6.22 site on together on my hosting server
When i added the drupal site to the server
I had a lot of performance problems in the server
And sometimes ...
0
votes
2answers
73 views
Mysql Query in Background?
How to insert the data into MYSQL DB in background mode ?
The data contains huge volume about 20 million rows
0
votes
1answer
29 views
Setting up a dedicated mysql server
I got a dedicated VPS and installed mysql on it(I am new at this).
Now from my web server(on a different server), when I make queries it takes 10x longer than it used to take to make the queries when ...
1
vote
5answers
76 views
Slow Mysql import
I import a database, and when i run mytop i see only one thread running an insert.
On a big database of 80G that will take really big time, is there any tools or may be an option to increase number of ...
0
votes
0answers
19 views
Best practice for the max_connect_errors setting of mySQL
What would you consider the best practice for the max_connect_errors setting of mySQL?
We had a case where a host failed 10 consecutive times to connect to the db and entered the "black list". This ...
0
votes
0answers
11 views
Incoming Connections on Satellite-Connected Server Failing
I am running a Master-Master replication setup, with one server being on a satellite internet connection. I have used this setup before to successfully offer more responsive applications on laggy ...
3
votes
1answer
119 views
HA Setup for MySQL/mostly MyISAM Tables
I am currently using Master-Slave Replication, seperating reads from writes at the application level.
The only kind of failover currently implemented is application level detection of master failure, ...
0
votes
1answer
15 views
Error in Fedora 9 while installing MySQL 5.5.20 using “YUM” Command
I am trying to install the latest version of MySQL server on a Fedora 9 machine. When I run the command yum --enablerepo=remi list mysql mysql-server, I get the error:
Loaded plugins: ...
1
vote
2answers
58 views
MySQL query caching - what happens if Server runs out of RAM?
so I have enabled query caching on my server but now from the 8 GB RAM there is almost non left! CPU is around 3% !
Now what happens when there is no more RAM left?
Will this just increase CPU load?
...
0
votes
0answers
10 views
Not enough space for MySQL optimize; do new rows overwrite existing data? [migrated]
My table consumed most of my disk space. I deleted a significant portion of the table, but the optimize command (to clean out the deleted data) does not have sufficient space.
Is there any path ...
0
votes
3answers
80 views
Best my.cnf configuration for a 8GB MySQL server with MyISAM use only
I am preparing a large Drupal 6.x based installation and have setup a dedicated MySQL server with 8GB of RAM. Drupal 6.x uses only MyISAM engine and there will be around 500 concurrent users using the ...
