0
votes
2answers
46 views

Server problems, running out of RAM, really high load average

I desperately need help in figuring out how to troubleshoot this problem I'm having. I run a fairly mission critical web server (Debian 7.5, 512MB RAM, 512MB swap, Apache, MySQL). It runs a couple ...
0
votes
1answer
34 views

TOP processes by system time

I have a system running 2 processes - MySQL and Java I'm seeing 20-30% of the time spent in %system. I've looked around to try and find a way to identify which what the balance of the system time is ...
0
votes
2answers
74 views

MySQL performance problems on particular vhosts

I have a dedicated server setup (8 cores, 16 GB of RAM), running Ubuntu 12.04 LTS with latest updates, and I am experiencing some performance problems related to MySQL. I have multiple vhosts active. ...
0
votes
1answer
61 views

how to disable all caches types in mysql server in order to do performance testing for my queries

I'm using Mysql Server 5.6.15 and i have a huge database with many complex queries. it seems that when I run the query the first time it takes X amount of time. when I execute it again it takes ...
3
votes
1answer
299 views

How to identify which MySQL queries take a lot of time?

My MySQL server is consuming a lot of memory. Memory footprint 1. Memory consumption in descending order (top 4) MySQL's memory consumption in particular - Why is there so many number of mysqld ...
5
votes
2answers
125 views

ZFS Equivalent of lvdisplay snap_percent

I've been using LVM snapshots for backing up MySQL databases. FLUSH TABLES WITH READ LOCK is issued and then lvcreate --snapshot --size 4G etc. Because the database is live while the snapshot is ...
-1
votes
1answer
125 views

MySQL settings for MAXIMUM performance / can be specific to particular DB or user? [closed]

We have a dedicated server, a very powerful one, and I don't believe we are getting the most out of MySQL. Even when running ultra-heavy processes that take a very long time to complete, I'm showing ...
-1
votes
1answer
158 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 ...
0
votes
0answers
492 views

Ubuntu 12.04 64bit - What would cause high System CPU %sys during high MySQL loads?

128GB RAM, 32cores Xeon RAID 10 SSD. Mysql version is the latest 5.5 for Ubuntu 12.04 . We have a lot of queries - about 1800+ per second. During high MySQL load - 2700+% load on a 32 CPU system - ...
0
votes
1answer
95 views

MySQL Threads or what is this

http://i.stack.imgur.com/dZFqI.png How can I reduce that number? I have a quad core machine. Do I need to edit thread_pool_size and by reducing them do I get better performance? Should a lot of ...
-1
votes
1answer
514 views

MySQL runs at >=100% CPU, heavy disk I/O?

Recently my Debian Linux server has been experiencing slow web server response times. I've investigated and it seems that MySQL is the culprit, yet there are no slow queries indicated by the slow ...
0
votes
2answers
97 views

Server configurations for hosting MySQL database

I have a web application which uses a MySQL database hosted on a virtual server. I've been using this server when I started the application and when the database was really small. Now it has grown and ...
3
votes
2answers
361 views

Tuning MySQL and Linux to reduce maximum response time specifically

We have a MySQL-based application that is very response time sensitive. A MySQL stored procedure needs to respond on average in less than 10 milliseconds and the maximum acceptable response time is 50 ...
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 ...
0
votes
2answers
827 views

MySQL Memory usage

Our MySQL server seems to be using a lot of memory. I've tried looking for slow queries and queries with no index and have halved the peak CPU usage and Apache memory usage but the MySQL memory stays ...
3
votes
2answers
1k views

How to adjust MySQL performance

I'm facing a real problem with MySQL instance for a service online. We use hibernate and c3p0 pool with these settings: c3p0.max_size=200 c3p0.min_size=5 c3p0.timeout=60000 c3p0.max_statements=20 ...
2
votes
1answer
1k views

InnoDB options crashing mysql start AND mysql tuning

I have an innodb on a Ubuntu 10.10 server running on an ESXi platform. I have dedicated 8 CPUs, 32 Gigs of ram, and files stored in a Raid 5 HP SAN of SAS 10k rpm disks. I'm expecting FAST queries! ...
0
votes
1answer
708 views

MySQL hosting: What are the recommended specs and w

I have two specific cases of MySQL hosting. 1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to ...
1
vote
3answers
339 views

Config MySQL to maximum speed and memory

I have a server, 8 cores, 12 GB RAM. This server is only used to run MySQL. So, help me config /etc/my.cnf to maximum speed, memory for MySQL.
0
votes
3answers
571 views

Extreme fine tuning MySQL performance wise on a Linux server

I would like to know all of the key points where MySQL can be fine tuned performance wise on a Linux server through my.cnf or through other methods, libraries and tools. Tips and tricks and shady ...
1
vote
3answers
3k views

How-to manage a MySQL table with over 2 million records

I have an InnoDB table running on MySQL 5.0.45 in CentOS. To make matters worse it is all running in a virtual machine. There are multiple tables that have the probability of exceeding 2 million ...
1
vote
1answer
929 views

MySQL's innodb_file_per_table and “too many tables”

I'm running MySQL (5.0 but I don't think it matters for anything after 4.1) and I've seen advice about using the innodb_file_per_table configuration option for InnoDB tables. This is usually done so ...
0
votes
2answers
228 views

How do I increas MySQL Performance by throwing Memory at it?

I have a machine with 1 GB of RAM and have set apache to use STARTSERVER OF 150, and MAXCLIENTS of 150, only half is used so I still have about 500 MB more of spare RAM. I want MySQL to use this up as ...
1
vote
1answer
449 views

Specific apache + mysql settings for a light-weight site

I have a small website with a Joomla and a Moodle set up. It seems that both of these are very slow. The server (CentOS release 5.5 (Final)) is a virtual dedicated server with about 2GB of ram. I ...
1
vote
1answer
476 views

Why is MySQL table_cache full but never used

I have been using the tuning-primer.sh script to tune my my.cnf settings. I have most things working well but the part about TABLE CACHE makes no sense: TABLE CACHE Current table_cache value = 900 ...
0
votes
1answer
145 views

Need help tuning Mysql and linux server

We have multi-user application (like MailChimp,Constant Contact) . Each of our customers has it's own contact's list (from 5 to 100.000 contacts). Everything is stored in one BIG database (currently ...
1
vote
2answers
176 views

mysql settings - using the available resources

I've got a lot of processing work I need to run on a mysql server. I've installed mysql 5.1.45-community on a Win 2008 64bit. Its running on a Xeon, 3ghz 6 processors with 8 gig ram. It doesn't ...
1
vote
4answers
557 views

Optimizing MySQL server

I need help in optimizing my my.cnf configuration file. I have two servers connected directly through LAN network (1 GBit/s). The first server is an Apache web server and the second one is a MySQL ...
1
vote
4answers
2k views

Lower Maximum Possible Memory Usage

I've been using MySQLTuner to optimize my database, and the only problem I am having is: [!!] Maximum possible memory usage: 14.8G (126% of installed RAM) I'm not sure what I should be ...
9
votes
2answers
36k views

Tuning (and understanding) table_cache in mySQL

I ran the excellent MySQL performance tuning script and started to work through the suggestions. One I ran into was TABLE CACHE Current table_cache value = 4096 tables You have a total of 1073 ...
3
votes
6answers
1k views

MySQL performance tuning

I'm looking for a succinct list of common pitfalls and optimizations for tuning a MySQL server as used for mid-size websites. In general, the type of advice I'm looking for here is information that ...
2
votes
6answers
2k views

Looking for comparisons of disk i/o for a dedicated MySQL server

We hired a consultant to help us increase the capacity of our MySQL cluster, and the first thing (almost only thing) he did was to measure the disk i/o speed of our servers. I am interested in a ...
3
votes
3answers
877 views

What should I set the initial MySQL Values in My.cnf to for Performance?

I am just setting up my new Linux Ubuntu 8.04 LTS server now, and getting ready for launch. My application is a PHP built application using the Zend Framework, and there is a MySQL heavy site (as are ...