VPS Incredibly Slow, Huge Numbers Of Slow MySQL Queries For Plesk/Watchdog

Nov 11, 2008

I've got 25 domains on a Virtuozzo/Plesk8.6/CentOS5 VPS. Each domain has one up-to-date install of WordPress, most have very little traffic (average 200mb per month), maybe 2 domains get 5-7gb traffic per month.

I monitor port 80 connections and rarely see more than 10 at a time.
That should in my opinion be no problem at all for a VPS with 768mb guaranteed ram and 2.4ghz cpu. I've got 30gb hard drive spare too.

But.... about 8 or 10 times a day it grinds to a complete halt: server load at 500-1000%, sites timing out, plesk takes 3mins to load, often I can't even connect with SSH, and the plesk web server, apache

INSERT INTO module_watchdog_sys_stat (time, type, value, service_id) VALUES(FROM_UNIXTIME(1226404705), 'MAINMEM_USAGE', 17472, 11);

80 seconds sounds like a huge amount of time for a MySQL insert to me! Does anyone know if this is likely to be the cause of my trouble? Some problem with Plesk and the database? Or could it be something else?

View 3 Replies


Mysql Slow Queries

Feb 25, 2007

I added the following to my.cnf and restarted mysql

I saw at leat 53 slow queries, however, there is no such file in that folder.

View 9 Replies View Related

Optimizing These Particular MySQL Slow Queries In WordPress

Jun 14, 2008

What I did here was create /var/log/mysqld.slow.log for queries that are taking one second or longer. After around 36 hours, here is what I came up with. Since the file size of /var/log/mysqld.slow.log was 219KB, posting it in its entirety it not practical. Therefore, I used a program, the perl script known as mysql_slow_log_parser found on www.retards.org, to parse the mysqld.slow.log to make it easier to interpret and read. The result was that the original filesize of 219KB was converted to the smaller size of 14KB....

View 7 Replies View Related

Plesk 12.x / Windows :: PHP Connecting Over Localhost To MySQL Very Slow

Jan 27, 2015

I have windows server 2012 and Plesk v12.0.18 #30 - I noticed speed problem.

When I try to connect to mySQL with:

$conn = new mysqli('localhost', 'joomla_***', '*****', 'joomla_test');

Connection takes 1 second!!!When I try to connect with '' instead of 'localhost' connection takes 0,009 seconds.

1. I tried solution to add line ' localhost' to c:windowssystem32driversetshosts - but no luck.

2. I tried to edit C:Program Files (x86)ParallelsPleskMySQLDatamy.ini - adding lines
then restarted mySql but 1 second lag time on connection was still there.

3. I even tried to disable IPv6 but still no luck

I guess all users windows windows server 2012 has the same problem??!?!...

View 3 Replies View Related

Mysql Loading Very Slow

Dec 28, 2008

I'm running a forum system on my server. Loading pages that don't connect to the forum database load normal. Whenever I browse any page that connects to the forum database on my forum, the page either takes ages to load or times out loading. I never exceed using 14% of one of my two cores, I'm using a quarter of my 1.5GB ram. It's only been loading slow like this since I've switched from running Windows to Ubuntu Server 8.10. I enabled logging slow queries on SQL, but nothing's been recorded. I've installed the server packages through Webmin,

when I access the server through its local IP address it's still very slow.

View 13 Replies View Related

Mysql Server Busy And Slow

Sep 23, 2008

Mysql server always busy and slow (in my VPS).

How I can know which website/account uses mysql very heavely?

or just any monitoring Idea?

I want to know which user is responsible of that overuse?

View 7 Replies View Related

Modernbill Is Really Slow / Mysql Optimizations

Dec 29, 2007

Modernbill v5 is extremely slow. It takes about 2-3 seconds to get to the next page or refresh. It took 5 seconds after clicking 'reports' tab.

In order process, it takes 3-5 seconds just to show the add-ons or update them after hitting "save add-ons". This is unbelievable. I'm using Firefox.

I'm on a cable connection

Server specs:
Dual Xeon 3.4GHz HT
4GB Memory
MySql 5
PHP 5.2.5
Apache 2.2

I applied these optimizations as suggested by an MB tech


At the ModernBill level, We have the following custom configurations in our /lib-modernbill/include/config/config.php file:

$CONF["dbType"] = "mysqli";
$CONF["forceCLICurl"] = 0;
$CONF["enableSharedMemoryLocaleCache"] = true;
$CONF["enableSharedMemoryAdminCache"] = true;
$CONF["adminCacheSeconds"] = 300;
$CONF["enableSharedMemoryMBPathCache"] = true;
$CONF["smarty"]["enableCaching"] = true;
$CONF["smarty"]["cacheLifetime"] = 0;
$CONF["smarty"]["enableCompileChecking"] = false;

At the PHP level, we have the following in our php.ini (some of these were recommended in our documentation to start with):

max_execution_time = 300
memory_limit = 128M
error_reporting = 2039
display_errors = Off
register_globals = Off


query_cache_size=32M ## 32MB for every 1GB of RAM
key_buffer=512M ## 128MB for every 1GB of RAM
sort_buffer_size=4M ## 1MB for every 1GB of RAM
read_buffer_size=4M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM
thread_concurrency=8 ## Number of CPUs x 2








View 1 Replies View Related

Very Slow Query Time After Upgrade To Mysql 5

Apr 8, 2009

We have a dedicated server and we host 4 news portals based on e107 and joomla.

My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.

We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !

Does anybody know if this is makes sense ?

Below is the server Status from WHM :

cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %

Below is the Server Information from WHM :
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB

Memory Information

Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)

System Information

Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux

Physical Disks

hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported

Current Memory Usage

total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924

Current Disk Usage

Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp

Below is the CPU/Memmory/Mysql Usage from WHM :
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
Top Process%CPU 0.2[kjournald]
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]

View 8 Replies View Related

Some Websites Load Slow + Mysql Timeout

Feb 5, 2007

I'm hosting about 6 private websites on my server, and some have problems.

My biggest website is a vb forum with 30.000 members and 1.5 million posts.

When i browse with firefox i see that vb forum loads fast, but phpads which is integrated on the top and footer loads very slow. When i browse with IE, it takes like 10 seconds before the whole site is loaded and sometimes IE even crashes.

When i try to login on another website / admin panel (oscommerce), i get a mysql gone away error, that means timeout. But why does it show that? I ran mysqlreport and can't find anything why it should display mysql gone away.
# ./mysqlreport
MySQL 5.0.15-standard uptime 3 19:36:47 Mon Feb 5 11:08:10 2007

__ Key _________________________________________________________________
Buffer usage 78.94M of 96.00M %Used: 82.23
Write ratio 0.60
Read ratio 0.00

__ Questions ___________________________________________________________
Total 19.61M 59.47/s
Slow 9 0.00/s %Total: 0.00 %DMS: 0.00
DMS 7.17M 21.74/s 36.56

__ Table Locks _________________________________________________________
Waited 7.57k 0.02/s %Total: 0.05
Immediate 16.50M 50.03/s

__ Tables ______________________________________________________________
Open 1.27k of 1800 %Cache: 70.56
Opened 1.82k 0.01/s

__ Connections _________________________________________________________
Max used 47 of 500 %Max: 9.40
Total 2.62M 7.95/s

__ Created Temp ________________________________________________________
Disk table 6.77k 0.02/s
Table 635.25k 1.93/s
File 50.37k 0.15/s

I can't find any problems on the server which may lead to this strange problem.

The server load is normal, around 1 to 1.5. No weird errors in the apache error log or system log.

This strange behaviour started 2 weeks ago, and appears 2 to 3 time a week.

The system is running:
centos 4.3 64-bit
kernel #1 SMP
directadmin 1.29.0
mysql 5.0.15
php 5.2
apache 2

Zend optimizer 3.2.0
Eaccelerator 1.95

One thing i noticed is that every night when the directadmin cron finished, the server acts normal again.

The directadmin cronjobs are:
* * * * * root /usr/local/directadmin/dataskq
2 0-23/6 * * * root echo 'action=vacation&value=all' >> /usr/local/directadmin/data/task.queue;
#5 5 * * 0 root /sbin/quotaoff -a; /sbin/quotacheck -augm; /sbin/quotaon -a;
20 4 1 * * root echo 'action=reset&value=all' >> /usr/local/directadmin/data/task.queue
0 4 * * * root echo 'action=check&value=license' >> /usr/local/directadmin/data/task.queue
10 0 * * * root /usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats_updateall.pl now -awstatsprog=/usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats.pl && echo 'action=tally&value=all' >> /usr/local/directadmin/data/task.queue

View 1 Replies View Related

How To Enable Slow-query Logging In MySQL

Apr 23, 2007

how to enable slow-query logging in MySQL ? Im using mysql version 4.1.20

well i just added following line in my.cnf can you please tell me is it correct way or not?

log-update = /var/lib/mysql/updates.log

View 6 Replies View Related

Hostnexus Plesk.. Is It Really Normal To Be Slow

Jul 30, 2008

I just signed up with hostnexus.. so far the support is responsive.. but the control panel delays is incredibly annoying.

I just surfed around and found out a lot of people on the net complain about the same thing. Is this normal on a plesk control panel?

I always get timed out, or I have to wait for over a 10 minutes just to get an account created, provided I dont hang.

Is this normal for plesk? why didnt they tried to fix it? I mean they are already on version 8..

View 6 Replies View Related

Plesk 11.x / Linux :: Backup Very Slow?

Jul 17, 2014

We have a problem with a Plesk backup. We have about 300 domains, the scheduled task starts 23.30 and takes about 16 hours and thats not normal. Before it took about 9-10 hours for 'All configuration and content' and that was too long, so we set up for 'All configuration and content except mail'. It worked for a few days and then it started to take 14 - 16 hours for a server backup. We use Plesk 11.5 on CentOS 6 64bit.

View 4 Replies View Related

Plesk 12.x / Linux :: FTP Connection Slow And Fails

Jul 1, 2014

OS CentOS 6.5 (Final)
Plesk version 12.0.18 Update #6, last updated at July 2, 2014 11:13 AM

The system is up-to-date; last checked at June 27, 2014 04:43 AM

All current websites on the server seem to work fine any new subscriptions we cannot get working at all.

We can connect via FTP to new sites SOMETIMES - just cant get directory listing. When we can connect and get into a directory it slows down.

In Active mode:
Response:425 Unable to build data connection: Connection refused
Error:Failed to retrieve directory listing​
Install Wordpress via the Parallels panel it loads and says it is all there, just can't log or display any pages. The default Parallels page is displayed.

Upload a html page via the File Manager in Parallels and it displays the default Parallels page.

Unpack the Wordpress tar file via File Manager and it displays the default Parallels page.

The Wordpress feature in Parallels says it is working fine, can't display any page, can't log in as it returns a 404 page or the default Parallels page.

Create a site in Presence builder and Parallels says there is a site. The default Parallels page is displayed when opening the site.

Go to DOMAINS and there is 0mb in space used and there are files listed in the File Manager - none of which can be displayed.

View 3 Replies View Related

Plesk 12.x / Linux :: FTP Very Slow (with Firewall / Mod Security Enabled)

Jun 26, 2014

After upgrading to Plesk 12 the FTP connection has become very slow. Mode Security, Fail2Ban and Plesk Firewall have been enabled, the security is set to force sFTP and maximum security and in /etc/proftpd.d/ a conf file has been added to set the passive ports that have been opened in the Plesk Firewall (60000 to 62000)

Turning off the Mod Security does not solve the slow connection.

What can we do to detect the cause of the problem?

View 3 Replies View Related

Plesk 12.x / Linux :: Control Panel Is Very Slow To Load?

Apr 17, 2015

I've been having a few issues with the control panel navigation is running slow even though I have heaps of resources available and free. The server is located locally and have no problems surfing websites attached to the same server.

When I login as admin, it can take 25 seconds to load into the first screen.

CPU GenuineIntel, Intel(R) Xeon(R)CPU E5649 @ 2.53GHz
Version Parallels Plesk v12.0.18_build1200140606.15 os_CentOS 6
OS CentOS 6.6 (Final)
Memory Available 6GB used 2.5-3GB
HDD: 300GB/ approx 130GB Free

I have tried issuing a /etc/init.d/psa restart command and has made no difference.

View 1 Replies View Related

Plesk 11.x / Linux :: Slow SMTP Response From Qmail

Jun 16, 2015

We are seeing intermittent slow responses from SMTP on a RHEL6 server running Qmail on Plesk 11.5. The response is being measured from a remote Zabbix server.

The response time seems to be slow (>10s) for a period of 2-3 minutes and then returns to normal (<1s). All other services continue to be ok during the period of slowness.

The server_args line in /etc/xinetd.d/smtp_psa already contains "-Rt0" and all the DNS servers in /etc/resolv.conf are resolving properly.

From looking at the maillog file the server was receiving about 35 SMTP connections a minute at the time of the slowdown. We have the server configured to use 2 x RBL's.

I wonder if we are hitting a limit on the maximum amount of SMTP connections. The file /var/qmail/control/concurrencyincoming does not exist so, according to the Qmail manual, there shouldn't be a limit on the number of incoming SMTP connections.

View 9 Replies View Related

Plesk 12.x / Linux :: API Requests Suddenly Extremely Slow

May 4, 2015

In the last few days the responses from Plesk's XML API have been extremely slow. It's now taking an average of 45 seconds to handle an XML API request where it used to be more around 5 seconds. What would cause that? What service handles these requests on the server so I can try rebooting it?

View 2 Replies View Related

Plesk 12.x / Linux :: Control Panel And Websites Are So Slow

Mar 26, 2015

My Plesk installation and websites are slow

8G ram
100 G Harddisk

View 6 Replies View Related

Plesk 12.x / Linux :: Server Become Very Slow After Some Hours Uptime

Nov 23, 2014

where to search. It appear thaht my free memory decrease each minute after reboot.When i restart it's ok but i see minute after minute the free memory is decreasing...

The command top don't show special process which explain my problem. I don't understand how a process can kill my memory but not immediatly but from reboot to after 4 or 5 hours uptime.

View 2 Replies View Related

Plesk 12.x / Linux :: Ubuntu 12.04 Very Slow Especially With Android Studio

Aug 24, 2014

I have an old laptop with the following specification: Memory: 485 MiB, Processor: Genuine intel CPU T2300 @ 1.66 GHz ×2, OS Type: 32 bit, Disk: 78.1 GB,

I installed on it Ubuntu 12.04 LTS and I noticed that the overall system is very slow in responding. I tried to search about that in the internet and I found some articles talking about how to make Ubuntu 12.04 LTS run fast I applied all what they said including download LXDE desktop environment and then nothing different in the system response time.

Then I need to develop some android applications so, I download Android Studio (Beta) 0.8.6. The problem became worse than before whenever I tried to open the Android Studio the screen is frozen for some minutes then it took time to download the projects and initialize the work space also, when I tried to move the cursor he is move very slowly. When I tried to run my first application on the AVD it took three hours and still not run yet.

I delete the Android Studio and install it again several times, I was trying to solve the problem but still nothing change.

View 1 Replies View Related

Plesk 12.x / Linux :: Hosting Wordpress - Navigation Between Pages Slow

Jan 11, 2015

I`ve got a problem with plesk when hosting Wordpress, when using Wordpress navigating between the pages (front-end and back-end) server time seems to be 15 sec.I`ve checked CPU usage and that stays under 5%.

When I install Drupal or Concrete5 or any other application that uses PHP with MYSQL it runs very fast.I`ve already fine-tuned PHP / Apache2 / Nginx & Mysql to get the max possible performance out of it.

What i`m using for hardware:
i7 920 2.6Ghz
24GB Ram
LSI Raid controller 9260-8i
RAID 10, 6 WD Black disks (internal speed goes about 450mb/sec)
RAID 1, 2 x Samsung SSD Evo 840

ESXI 5.5, optimised for maximum performance. (no standard config)
PLESK VM has 8 cores, 16GB Ram and I/O access priority set to max.

If I move the PLESK VM to the SSD datastore it makes no difference.Again, the problem only happens when i`m installing Wordpress..I Also did a manual install of Wordpress, same issue..I`m going to try the older version of Wordpress (3.9) so see i`m having the same problems..Using the latest plesk 12 on Ubuntu 14 with trail license at the moment.

View 6 Replies View Related

Plesk 12.x / Linux :: Php-cgi High Cpu Load Website Running Slow

Dec 10, 2014

Today, without any change on the server side my single running website on my server started running low. After checking the running processes I realised I have these 8 processes running with high cpu load something that didn't had before.

4245 user 20 0 283m 103m 10m R 85.1 0.3 6:44.88 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4243 user 20 0 241m 68m 8736 R 83.8 0.2 6:33.45 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4259 user 20 0 254m 82m 8720 R 83.5 0.3 6:11.00 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4244 user 20 0 282m 103m 10m R 82.1 0.3 6:46.49 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4247 user 20 0 248m 76m 8712 R 78.8 0.2 6:50.31 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini
4264 user 20 0 258m 85m 8712 R 72.9 0.3 6:49.83 /usr/bin/php-cgi -c /var/www/vhosts/system/domain/etc/php.ini

apache error log doesn't show any warnings, errors.

View 4 Replies View Related

Plesk 11.x / Linux :: Drupal Website - Pages Load Too Slow

May 1, 2014

VPS hosting, stats in my sig below. Have poor performance with a drupal and civicrm(drupal based) website and looking to troubleshoot.

Main issue is pages take too long to load, sometimes over 5 seconds and more! Below is my.cnf and MYSQLtuner results.

So my.cnf



[Code] .....

View 2 Replies View Related

Plesk 12.x / Windows :: Slow Website Performance With Perl And Python Installed On IIS

Jan 3, 2015

I noticed that all my client websites were as slow as a snail snot before uninstalling perl and Python.

Is it normal that perl and python components slowing down IIS?

I search online, it is a common scenerio for those two to slow down IIS.

After I uninstalled perl and python as well as awstat, the site are working as fast as before.

View 2 Replies View Related

Plesk 11.x / Windows :: Slow Domain Creation On Same Web Space And Doc Root - Authentication Error

Jun 26, 2014

We have more than 10 domains on the same webspace, sharing the same document root. When we try to add a new domain on the same web space (sharing the same document root) Plesk takes a long time to create it (about 10 minutes). While domain creation, all the other domains sharing the same document root and web space get an authentication error. When Plesk finishes, all domains work again.

View 1 Replies View Related

Upto 150 MySQL Queries A Second

Apr 7, 2008

I'm currently hosting all of my stuff with my own Wild West Reselling Account, i.e., InnoDomains.com.

Problem is I'm running multiple Wordpress Installations and a few websites that have some pretty intense MySQL work going on in the background, and I use about 250GB per month in bandwidth.

My Account gets the 503 downtime errors because according to Customer Service I cannot run more than 50 MySQL queries in one second. Well, that's not much of a challenge because a lengthy wordpress page runs about 90 queries and loads in 2-3 seconds. Time this by three including the other websites and a couple of shopping stores, and I'm easily doing more than 100-150 queries a second more than several times a day, thereby seeing that nasty, irritating error.

My other option is to split up all the websites over basic $ 3.95 per month accounts. I don't want to switch to a dedicated server yet because I'm not really making a whole lot of money (about $ 30 per month). Another thing I could do is move my MySQL testing to a local machine, and that may actually reduce the load on the damn server.

Are there any hosts out there that will allow me to do more than 100 MySQL queries per second? If so, are there any that are any good?

View 13 Replies View Related

Limiting MySQL Queries

Jun 30, 2007

Is there any way to set max MySQL queries per hour to all MySQL users at once?

(lets say 20000 queries for each user?)

(cPanel/SuSE 10.0/MySQL 5.0.X).

View 2 Replies View Related

[MySQL] Too Many Connections: Locked Queries

Dec 17, 2008

This has happened twice now. I have my wait_timeout variable set to 60 seconds, but occasionally my database gets overloaded with "locked" queries. Here's an example of my processlist:

| 14773848 | db_name | localhost | db_name | Query | 35483 | statistics | SELECT COUNT... |
| 14776290 | db_name | localhost | db_name | Query | 35144 | statistics | SELECT COUNT... |
| 14778877 | db_name | localhost | db_name | Query | 34841 | statistics | SELECT COUNT... |
| 14790744 | db_name | localhost | db_name | Query | 33056 | Locked | UPDATE... |
| 14791275 | db_name | localhost | db_name | Query | 32977 | Locked | SELECT... |
| 14791395 | db_name | localhost | db_name | Query | 32960 | Locked | SELECT... |
| 14791556 | db_name | localhost | db_name | Query | 32929 | Locked | SELECT... |
| 14791603 | db_name | localhost | db_name | Query | 32924 | Locked | SELECT... |
| 14791757 | db_name | localhost | db_name | Query | 32900 | Locked | SELECT... |
| 14792209 | db_name | localhost | db_name | Query | 32815 | Locked | SELECT... |
| 14792355 | db_name | localhost | db_name | Query | 32786 | Locked | SELECT... |

This continues on with locked queries all the way up to my limit of 450 connections, then the whole server goes down. Note the time spent processing these queries, 35483 seconds and counting! Surely the wait_timeout is supposed to prevent this from happening?!

Also, this appears to start with queries in the State "statistics". Then the State for the following queries becomes "locked". Does anyone know what these mean? Can I get them to timeout normally? Queries which never timeout are guaranteed to bring your server down eventually, surely this is not the desired behaviour.

View 4 Replies View Related

No Clue: Automatic MySQL Queries

Apr 9, 2008

I've been pondering something for a long time here, but never really knew the right question to ask, or how to word it... so I never even know what to search for. So I honestly have no idea what I'm asking or if this is even under the right topic. What I'm looking for is answers, links, tutorials, or just some words I can search for to help me do the following:

I have a MySQL database filled with accounts. People have to pay to get these accounts. All the accounts are set to expire on different days. I need to send an e-mail out to accounts, for example, to let them know they're expiring, say, a month before this will occur. Right now the only way I know to do this is to have MySQL queries on a PHP page that, every time the page is loaded, runs through all the accounts, checks their expirations, and sends emails to those that need it. I know there has to be a way to have this happen automatically without having to load a PHP page every day, for example.

View 2 Replies View Related

MySQL Anyway To Log Queries Of Specific User

Jun 5, 2007

I know about the general log but want to just log queries of a specific user. Our database does 400 queries/s on a slow day, so I think it would be a pain to grep though a huge log like that. And, im not sure if it would cause any preformance issues.

View 0 Replies View Related

Copyrights 2005-15 www.BigResource.com, All rights reserved