0
votes
2answers
70 views

MySql table optimization causing more problems than it solves

I have a heavily accessed table corresponding to user's private messages, with over 10 M rows. When I run the user deletion process, obsolete messages are deleted from the table, typically more than ...
1
vote
2answers
180 views

mysql configurations for best performance

I have a huge magazine on dedicated server(1 website only on the server), all time the server have big load, "top" tool show me that the user "mysql" make this load: PID USER PR NI VIRT ...
1
vote
1answer
96 views

MySQL occasional non-responsive only on one database

I have an issue that occasionally (once or twice a week, not necessarily during peak hours) that queries on a certain db (the db of the largest of my sites) suddenly stop responding for about an hour. ...
-1
votes
1answer
92 views

What will be the best mysql settings for 3gb server? [duplicate]

I have a 3GB server with the below settings. The issue I am facing is when I pull some records through the admin panel of my site, sometimes it works well, but most of the times it process very slow. ...
3
votes
2answers
190 views

What's the optimal server configuration for fastest inserting in a MySql database in this scenario? [closed]

I have a MyISAM table partitioned by range with 90 partitions representing the last 90 days. I expect this table to receive somewhere between 500 million to 1 billion records before i start rotating ...
-1
votes
1answer
154 views

Server optimization for long running script [duplicate]

I have a system running on a remote VPS whose main feature is a long running script (it could run for about 10 hours, depending on the user input). The following are some of its features: Database ...
1
vote
1answer
531 views

MySQL MyISAM multi-core optimization

I've noticed that our app does not respond to requests when a demanding request is in execution. Running top seems to identify the source of the problem: top - 13:54:25 up 1 day, 13:43, 2 users, ...
1
vote
2answers
62 views

Can my mysql server be fully tweaked? [closed]

I'm on a quadcore CENTOS 5.9 i686 standard running WHM 11.36.0. It's a dedicated LAMP server with lots of websites, most of which are using databases. I'm monitoring the server using Munin and notice ...
1
vote
1answer
987 views

Tuning MySQL of 1.3 G DB, 8GB Ram, High IO Wait

I am having MySQL database of size 1.3 GB on 8 core virtual machine, 8 GB of memory and I am having troubles optimizing the configuration. There is a lot of small rows and lot of joins going on. I've ...
0
votes
1answer
333 views

mysql database config optimization

Have a heavily trafficed database running mostly innodb and would like to better optimize the mysql config. Server has 32Gb ram and the biggest tables are ~18Gb innodb. I think I have done all the ...
1
vote
1answer
635 views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
5
votes
3answers
1k views

Optimizing VPS Server Memory

WHAT I'M TRYING TO DO The server resource limits sometimes run tight; to help prevent memory exhaustion, I've had to limit server processes. I'm needing a little expert help to know if I'm on the ...
-1
votes
1answer
725 views

How to speed up a MySQL Import [closed]

I posted a related question on askubuntu.com, but this may be a better place and way to ask it. I'm working on a way to speed up a db import. Currently the import is taking a week, give or take a few ...
0
votes
1answer
826 views

MysqlTunner and query_cache_size dilemma

On a busy mysql server MySQLTuner 1.2.0 always recommends to add query_cache_size no matter how I increase the value (I tried up to 512MB). On the other hand it warns that : Increasing the ...
1
vote
0answers
344 views

Extremely slow response when connecting to remote MySQL database (LAMP Server)

I installed a LAMP server and enabled MySQL remote connections but I'm experiencing really bad response times when connecting to the database remotely from a WordPress install. I've been looking ...
1
vote
2answers
604 views

How can I lower MySQL single-page reads?

My innodb buffer pool size is 8GB and my database is 6GB in size but I see this: Innodb_buffer_pool_reads 263.5k - The number of logical reads that InnoDB could not satisfy from buffer pool and had ...
0
votes
1answer
70 views

Mysql proxy in comparison with two database connection

We have a situation in which we have master salve databases, we write in master and read from slave. in application we defined two connections one for write and other for read. I came to know know ...
0
votes
1answer
78 views

In cloud environment is it better to get two separate instance for mysql and php-app or get one large instance

We are using cloud environment for our web-apps, i need an expert opinion on hosting our applications. our application built on php & mysql, i want to know which is the most efficient and/or cost ...
0
votes
3answers
9k views

Optimal MySQL my.cnf setting for large Magento site on a dedicated server

Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size. The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory. ...
4
votes
2answers
864 views

Disk I/O utilization up to 100% after tuning InnoDB-related MySQL configuration

I have added following lines to "my.conf": query_cache_size=128M innodb_buffer_pool_size=512M innodb_flush_method=O_DIRECT After that Disk utilization started raising, reached 100% and holds ...
0
votes
2answers
614 views

MySQL InnoDB database 'hangs'

I have a problem with a MySql server causing it to freeze all the time. In phpMyAdmin when this happens I can see in "Show Processlist" are lots of processes for User "unauthenticated user" with ...
4
votes
2answers
306 views

Cron job for database repair and optimization

I would like to repair + optimize my MySQL database once a week! How could I do this?
0
votes
1answer
117 views

Maxing out shmpages

We've got a Media Temple dv install (running dv 3.5) that keeps hitting its hard limit. Currently, it's using 68,124 of 68950 hard limit. They've been less than helpful in helping us diagnosing this, ...
13
votes
3answers
2k views

Building a 1,000M row MySQL table

This question is reposted from Stack Overflow based on a suggestion in the comments, apologies for the duplication. Questions Question 1: as the size of the database table gets larger how can I tune ...
1
vote
1answer
236 views

MySQL: view read/write proportion, per specific table

I'm optimizing the configuration of a MySQL server, running only Bromine. This is non specific to application, and was just noted for completeness. I am trying to determine if switching from MyISAM to ...
1
vote
3answers
3k views

How to troubleshoot a big memory issue with Apache and mySQL

I've read a lot of this website to optimize my server but nothing has really helped me :( Im having a memory trouble I think , I have just one website (Drupal) with 860K page views month but when the ...
1
vote
2answers
8k views

Mysql Optimization - table_open_cache, query_cache

I have already optimize many times my Mysql server but now I want to have your advices. mysqltuner: -------- General Statistics -------------------------------------------------- [--] Skipped ...
1
vote
3answers
984 views

How to enable /dev/shm RAM disk for MySQL?

How to enable /dev/shm RAM disk for MySQL? (temp dir in /dev/shm) $ vi /etc/fstab tmpfs /dev/shm tmpfs defaults,size=512m 0 0 $ mount -o remount /dev/shm Is this correct? Now what? ...... ...... ...
-1
votes
4answers
3k views

Improve server performance by configuring MySQL [closed]

I have a server with 8GB of memory, running CentOS 5.4, php 5.2.9, mysql 5.0.77. I have a very large databse of about 20GB (InnoDB and MyIsam tables) and website using it. Website has about 20000 ...
1
vote
1answer
4k views

MySQL config and optimization

Here is the info for my server Giga Dedicated 6-Core: Intel Core i7 (6 x 3,20GHz) 24 GB RAM 160 GB SSD + 2000 GB HDD I have CentOS 5.6 (64bit) installed and Plesk Panel 10 Apache version is 2.2.19 ...
0
votes
1answer
144 views

MySQL Optimization in Many Inserts Few Selects Environment

I am working with a MySQL database that is mainly used to do inserts and almost never selects. Unfortunately, the system is already deployed and working, 24x7 roughly 14k inserts/day, and I cannot ...
0
votes
1answer
2k views

MySQL temp tables being created on Disk

I recently started noticing that a large sum of my tmp tables of my MySQL is being created on my Disk rather then in the memory. TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size ...
1
vote
1answer
5k views

key efficiency 99.97% mysql

using the mysql workbench administrator - my key efficiency is at 99.97% i have read about adding 'key_cache_size=100M' to my.cnf and increasing it as needed is this the correct fix for the problem? ...
0
votes
1answer
135 views

MySQL's Query Optimizer's take on disk access time

I don't have a ton of background with MySQL, and I was wondering of anyone can give me some insight into MySQL's query optimizer and the impact on the cost of disk accesses in determining a query plan ...
1
vote
3answers
418 views

Any open source software for measuring & monitoring MySQL performance?

I'm working on improving the performance of a MySQL server. I'm looking for something to measure & monitor the performance of MySQL (as query per second) over time so that I can measure any ...
4
votes
2answers
2k views

Optimizing MySQL for small VPS

I'm trying to optimize my MySQL config for a verrry small VPS. The VPS is also running NGINX/PHP-FPM and Magento; all with a limit of 250MB of RAM. This is an output of MySQL Tuner... -------- ...
0
votes
2answers
654 views

changing innodb_buffer_pool_size makes error

i want to increase my innodb_buffer_pool_size value to get some more performance and when i try, my select queries arises error such as "Incorrect information file in .." i'm just adding ...
0
votes
1answer
287 views

Optimal my.cnf settings for MacBook Pro 15" i7 (localhost)

What is the most recommended optimal my.cnf settings for the newest MacBook Pro 15" i7 with 4GB of RAM. http://www.apple.com/macbookpro/specs.html Only for local processing only. I want it to be ...
0
votes
1answer
332 views

Rackspace: optimizing LAMP environment (using memcached)

i recently moved a web app to Rackspace (CentOS). It runs pretty well with 512mb RAM but im sure i will have to upgrade it to 1024mb RAM pretty soon. The bad news, is that the service runs on mobile ...
2
votes
1answer
9k views

How to set query_cache_size and join_buffer_size in my.cnf file?

I have been monitoring my server the past two days and realised that 60% of my temp tables are stored on the hhd instead of memory. Also I ran MySQL Performance Tuning Primer script that adviced me to ...
1
vote
4answers
1k views

Adjusting MySQL settings to handle big load of users

I have developed a php game that is obviously depending on mysql queries. Im running it on a monster server: Intel Xeon 7550 with 32GB RAM (Redhat x86_64 ES 5.0) with cPanel installed. I released the ...
2
votes
1answer
245 views

The cost of MySQL filesort and what's the solution?

I'm new to optimizing MySQL (cheers for having a high traffic site!) and I'm a little confused by filesort. I stumbled onto this article: ...
2
votes
1answer
202 views

MySQL logging slow queries

I've told MySQL to log queries that take longer than a second (1 in the config)... however I'm seeing queries like this that take much less than a second.... # Time: 101108 6:39:32 # User@Host: ...
0
votes
2answers
946 views

MySQL 2,500+ opened tables

I'm running 16 GB of RAM with dual 3.0 Ghz processors with Ubuntu Server My PHPMyAdmin is showing: Opened_tables 2,573 - The number of tables that have been opened. If opened tables is big, your ...
1
vote
2answers
285 views

Recommend a good guide for MySQL optimization

I just upgraded my RAM on my server from 4 GB to 16 GB and I'm told that I can utilize this memory to a huge advantage with certain MySQL settings if I get then just right. Do you know of any guides ...
2
votes
5answers
295 views

mysql - is there a good way of storing it in ram

I'm trying to think of ways to make mysql faster. Is there a proven way of storing it in ram to allow it to work faster?
2
votes
1answer
611 views

mysql my.cnf for a 50GB of RAM server

I am having load problems on my database server (dual quad core 50 GB RAM) load average: 4.26, 6.78, 11.25 here is the current my.cnf, can i optimize it? [client] port = 3306 socket ...
1
vote
1answer
108 views

Mysql- How can I find the memory usage of indexes

mysqltuner tells me to increase key_buffer_size dramatically. I dont have free memory to do it therefore I prefer to remove unnecessary indexes if any. How can I find the memory usage of indexes? ...
0
votes
4answers
722 views

Do i need to allocate more resources to mysql server?

I have feeling that mine mysql server is slower than normal while processing queries from the PHP website. Is there anything like i can allocate more resources to Mysql server to make it speedy? I ...
2
votes
3answers
2k views

MySQL too many connections

On my server I have 7 databases. Our server has 512 MB of RAM which I'm getting upgraded this evening to 2GB and has a 2.4 single processor. I've gotten an error about the connection limit exceeded. ...