MySQL Overload Server, Wich User
how check which database / user MySQL overload the server?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Overload- MySQL
My webserver keeps on overloading, causing pages to lag and mysql connections to get clogged. Each time it overloads, it's because of there being too many MySQL connections, and I really just don't know why there are so many. I am not sure whether someone is sabotaging my server or whether there is a hole in my php scripts that causes an abundance of connections, or some very slow query.
View Replies!
View Related
MySQL Replication For User On Shared Server
I never did replication and do not know much about it so I figured I would ask here if anyone knows or has done it before like this. I have a user who wants me to enable replication on my server for his user. I dont like the sounds of it on a shared environment but if there is no risk to other users and its not a big resource hog I will do it. Anyway, from what I gather I have to: 1. execute: GRANT REPLICATION SLAVE ON user_main.* TO 'repl'@'ip-here' IDENTIFIED BY '4T6WjUZa'; [url] 2. Stop mysql server and Add in my.cnf: [mysqld] log-bin=mysql-bin server-id=1 slave-compressed=1 binlog-do-db=user_main start server[url] 3. execute: SHOW MASTER STATUS; we need values of colomns File and Position from output of above command[url] So my questions are: Is there any security risk? Is there significant extra resource usage? Is this even done on shared environments?
View Replies!
View Related
My Server Overload
currently i purchase a reseller. when i click in server status, i found out that the detail is as below: cpsrvd up [green] Server Load 5.41 (1 cpu) [red] Memory Used 46.7 % [green] Swap Used 9.51 % [green] Disk /dev/sda1 (/boot) 13 % [green] Disk /dev/sdb (/mount) 57 % [green] Disk /dev/sda3 (/) 88 % [yellow] i found that the server load is in red color, and the last item Disk/dev/sda3 is in yellow color. may i know what is the problem?
View Replies!
View Related
Vmware Overload Server
Im using Vmware on dedicated server: each 2 Intel(R) Xeon(TM) CPU 3.00GHz 1- in vmware show: 2 CPUs x 2 Cores but i check in SSH we have 7 core ! Code: # cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 6 model name : Intel(R) Xeon(TM) CPU 3.00GHz stepping : 4 cpu MHz : 7680.000 cache size : 2048 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 2 apicid : 0 fpu : yes fpu_exception : yes cpuid level : 6 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est cid cx16 xtpr lahf_lm bogomips : 6012.44 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 6 model name : Intel(R) Xeon(TM) CPU 3.00GHz stepping : 4 cpu MHz : 5120.000 cache size : 2048 KB physical id : 1 siblings : 4 core id : 0 cpu cores : 2 apicid : 4 fpu : yes fpu_exception : yes cpuid level : 6 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx est cid cx16 xtpr lahf_lm bogomips : 5984.27 clflush size : 64 cache_alignment : 128 address sizes : 36 bits physical, 48 bits virtual
View Replies!
View Related
Server Overload Solution
i want to kill apache/http and restart it again automatically. i need this because sometime we are not in front of the server to fix an overload issue immediately, which can affect a server very badly. i believe many of us already face this kind of situation and hope there is some kind of script or way to do this.
View Replies!
View Related
Server Overload :: Don't Ignore This Email ... Cpu Has Been Maxed Out For ...
I have been receiving these a couple time a day lately and not sure what to do or how to go about checking what might be overloading the server. IF this looks familiar to anyone, I'd appreciate some helpful tips. I'm still a novice, but can muddle my way around the server if given enough guidance. Here is the email I've been getting: "IMPORTANT: Do not ignore this email. This is cPanel stats runner on host.myserverhost.com! While processing the log files for user xxxxxxx, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 19:20:10 up 2 days, 7:06, 0 users, load average: 15.17, 13.24, 8.00 You should check the server to see why the load is so high and take steps to lower the load. If you want stats to continue to run even with a high load; Edit /var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run /usr/local/cpanel/startup afterwards to pickup the changes)." I guess my question is, how would I go about determining what is causing the excess load? Seems to happen even when not many folks are on my site.
View Replies!
View Related
Dedicated Server Overload ... Low Page Views
I'm on a low-end dedicated server that I run 2 decent sized blogs on. I'm getting several traffic spikes a day where the load goes through the roof and I think I need my server optimized. My server admin says I need a bigger server and he has never steered me wrong but this is ridiculous: My blogs use Wordpress as its blogging platform....I know they hog server resources and I've recently installed Super cache so that seems to help. I average about 5,000 pageviews a day and I would think even a low-end box should handle this but maybe I am wrong. Here's the server specs: Processor #1 Vendor: GenuineIntel Processor #1 Name: Intel(R) Celeron(R) CPU 2.40GHz Processor #1 speed: 2394.661 MHz Processor #1 cache size: 128 KB Memory: 1033924k/1048016k available (2171k kernel code, 13360k reserved, 723k data, 172k init, 130512k highmem) hda: ST380011A, ATA DISK drive hdc: Lite-On LTN486S 48x Max, ATAPI CD/DVD-ROM drive hda: max request size: 1024KiB hda: 156250000 sectors (80000 MB) w/2048KiB Cache, CHS=16383/255/63, UDMA(100) hda: cache flushes supported hdc: ATAPI 48X CD-ROM drive, 120kB Cache, UDMA(33) Memory: total used free shared buffers cached Mem: 1035148 993356 41792 0 151312 527008 -/+ buffers/cache: 315036 720112 Swap: 2040212 476700 1563512 Total: 3075360 1470056 1605304
View Replies!
View Related
Server Overload - Fixed By Extra RAM Or More Powerful CPU
I have a fairly busy server, and received a High Load warning from my firewall monitoring software. Showing a high 5 minute load average alert of 13.89. I'm presuming extra memory and a more powerful CPU would be required to sort this out? Time: Thu Jul 3 12:22:06 2008 1 Min Load Avg: 42.90 5 Min Load Avg: 13.89 15 Min Load Avg: 5.82 Running/Total Processes: 51/359 Output from ps: USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND ...
View Replies!
View Related
MySQL Forgetting User Permissions
Does anyone know what could be the cause of this issue? I located a few others over at cpanel.net that have this problem, but no solution has been found. [url] I am running a VPS server with the following: WHM 10.8.0 cPanel 10.9.1-S14304 RedHat 9 i686 - WHM X v3.1.0 phpMyAdmin - 2.9.0.2 MySQL client version: 4.1.10 mysql version: 5.0.27-standard I have a database user that needs "Super Privileges" and so this was done. However, when Cpanel is updated the user permission is reset automatically from "ALL PRIVILEGES" to "USAGE". Here's a look at the database permissions from phpMyAdmin. Code: User Host Password Global privileges Grant hello localhost Yes ALL PRIVILEGES Yes hello_ % No ALL PRIVILEGES Yes hello_ localhost No ALL PRIVILEGES Yes The user "hello" loses its "ALL PRIVILEGES" and switches over to "USAGE" if an update is triggered. Updates to cpanel, creating/removing a database/user, and updating the account password will cause the switch.
View Replies!
View Related
Mysql/user Is Marked As Crashed
I am trying to start mysql but i am getting the following error MySQL manager or server PID file could not be found! [FAILED] Starting MySQL................................... [FAILED] I checked my hostname.err file in /var/lib/mysql and this is the error message it shows. 070130 17:59:41 mysqld started 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired 070130 17:59:42 mysqld ended how I would repair that to get mysql to start again?
View Replies!
View Related
What Are Common MySQL User Permissions
I want to use something like PHPBB forums and using one MySQL user and database. Just wondering, what are common user permissions I should set for the user? I want to try to minimize any permissions that can cause big risk to the server security. Here is a full list of permissions I can grant to the user (via Webmin): -Select table data -Insert table data -Update table data -Delete table data -Create tables -Drop tables -Grant privileges -Reference operations -Manage indexes -Alter tables -Create temp tables -Lock tables
View Replies!
View Related
Mysql User Privilege Changed By Cpanel Or What
I am using Cpanel. One Cpanel account is backup. I use it to backup my database. Under mysql, I gave this account ( backup ) many priviledges. But when the backup script ran, error said that backup account can not 'lock table'. I gave "lock table' priviledge again and run the script, it is ok. But after a while, when the script ran autmatically on daily basis, it lost the 'lock table' priviledge again. I wonder if Cpanel is messing me up? What can I do about it? anyone knows?
View Replies!
View Related
MySQL: Access Denied For Root User
When I deleted a database, the user apparently was orphaned because when I tried to recreate it, it returned "user already exists". I've never encountered that problem although from Googling, I see others have and they delete the user to get around it. When I log into mysql using the da_admin@ account and attempt to remove the user with drop user <user_name>; I receive the following error message: ERROR 1227 (42000): Access denied; you need the CREATE USER privilege for this operation It seems I don't have rights even as the root user. How can I get remove the orphaned user?
View Replies!
View Related
Weird MySQL: User/pass Stops Working After A While
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each. Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem. Also on the server we have Fantastico.
View Replies!
View Related
Granting MySQL Command Line Permissions To A User
Is there any safe way to grant command line permissions to a user/specific account? One that only allows them access to databases on their account. The problem is that this user intermittently runs queries that cause their database to hang (including PHPMyAdmin, so they can't view the processlist through there), and I have to manually kill that process, because they can't. Server is 2.4.21 with MySQL 4.0.27, admin is cPanel WHM.
View Replies!
View Related
Overload Of Traffic
I am not sure if my dedicated server is being attacked or if it is legitimate traffic. I need help figuring out the difference and if it is an attack, how to prevent it, and if it is legitimate traffic, how to configure the server to handle the load. My server information is below: HardwareIntel Xeon 3220-Quad Core [2.4GHz 8GB DDR2 SATAII 500GB SoftwareCentOS 5.3-32 Apache2 MySQL 5 PHP 5 When I do ps aux|grep httpd|wc -l I get the count of current connected clients of 259 which is always maxing out my MaxClients of 256. I had increased it to 512, and it maxed out, I had increased it to 1024 and it maxed out, and lastly I had setup to 2048 and it works, but slows the entire server down.
View Replies!
View Related
Apache- And Overload
the server is overloaded some times during a day. There is one process of httpd witch use 80-90% of memory. Load increases to 90 or 200 :/ I installed strace and when the process appeared I run on that process and there is: mmap(NULL, 364544, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2b25e60000 There is a lot of that entries.
View Replies!
View Related
Vps Is OverLoad
i have vps 512 MB ram From HostForWeb working Fine! in 160 websites! Hosted But! in swvps.com with 2 gig ram! Low Working! OverLoad and CPU Usage is Red Alert But HostForWeb VPS with 512 MB Ram good Working I Dont Know Why SWvps.com Is Low with 2 gig ram for me?
View Replies!
View Related
AP7901 Overload.
I am using a AP7901, and at 12AMP I am getting a red led status overload. At 11AMP the led is green status, which is perfect. Is this a problem? Shouldn't I be able to use 16AMP? Is it safe/ok to use more AMP?
View Replies!
View Related
Suspicious Overload And Spammers
I have a small VPS, with few websites each one with very low visitors in average less than100 visits per day CentOS 2.6.9 Plesk PHP 5.1.6 Apache/2.2.3 Few days ago some Forum spammers signed up to one of the forums. One of them: stopforumspam.com/ipcheck/212.178.2.3 Today I was away for few 5 hours after I came back I recived a notice from my script that "SMF could not connect to the database" I checked and I noticed almost all of my sites are not responding. MySql was working. A script on remote server which uses mysql from my server loaded but with dealy ------------------Next step------------------- log to SSH # uptime # 12:XX:XX up XXX days, 5:06, X users, load average: 10.58, 8.86, 5.86 my normal load is less than 0.9 -----------------check open ports --------------------------- netstat -nap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 0.0.0.0:995 0.0.0.0:* LISTEN 1936/couriertcpd tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 32447/mysqld tcp 0 0 0.0.0.0:106 0.0.0.0:* LISTEN 14307/xinetd tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN 9943/smbd tcp 0 0 0.0.0.0:110 0.0.0.0:* LISTEN 1916/couriertcpd tcp 0 0 0.0.0.0:143 0.0.0.0:* LISTEN 1840/couriertcpd tcp 0 0 0.0.0.0:8880 0.0.0.0:* LISTEN 9626/httpsd tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 7645/httpd tcp 0 0 0.0.0.0:465 0.0.0.0:* LISTEN 14307/xinetd tcp 0 0 0.0.0.0:21 0.0.0.0:* LISTEN 14307/xinetd tcp 0 0 [MyServerIP]:53 0.0.0.0:* LISTEN 13619/named tcp 0 0 [MyServerIP]:53 0.0.0.0:* LISTEN 13619/named tcp 0 0 [MyServerIP]:53 0.0.0.0:* LISTEN 13619/named tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 13619/named tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 13820/sshd tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 14307/xinetd tcp 0 0 127.0.0.1:953 0.0.0.0:* LISTEN
View Replies!
View Related
Internet Overload (E-mails)
Can someone who really knows what they are talking about write me up a very quick parag. on the reasons why the internet is becoming overloaded w/ e-mail & why people don't get their e-mails besides spam filters filtering them, for example the grey/black list, detecting viruses in Word when the person's anti virus isn't picking it up, etc.
View Replies!
View Related
Cpu Overload Warning Mail From Cpanel
i am continously getting warning mail form cpanel cpu watch that my cpu got overloaded as like follows, IMPORTANT: Do not ignore this email. This is cPanel cpuwatch on xxx.com! While processing, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 19:05:10 up 143 days, 20:38, 0 users, load average: 1.11, 0.69, 0.63 You should check the server to see why the load is so high and take steps to lower the load. If you want stats to continue to run even with a high load; Edit /var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run /usr/local/cpanel/startup afterwards to pickup the changes). I searched on load average and found that average load for 1 cpu is 2 and default value is 5 to 10.but here i am getting mail for 1.11 itself.I changed the value of threshold of load average in stat and logs of tweak setting to 4.but no improvement.now also i am getting more than 4 mails for average load i.e 1.23 also My questions are: 1)what is the criteria cpanel is checking for sending cpu-watch warning mail? 2)i am getting nothing more than rsync and exim at the time of overload(while using TOP command).So why now only i am getting warning mail? what is the cause of this problem? I was getting idea from internet to create account without stat/ log analyse function .But not sure how will it work and afraid of doing this.......
View Replies!
View Related
Single User Can't Access Any Site On My Server
I have a user who says he cannot get to any site on my server from either home or work. He has been a user for many years, and has never had any problems. He has also checked with his IT at work and they confirmed the site is not available. He is computer savvy, so I trust he is telling the truth. His work and home are only 10 miles apart. Do you guys have any ideas what could be happening? Is there a DNS entry wrong somewhere? He can't access the site even when putting in the IP address. There is one other user reporting something similar but other than that no other complaints. The site works fine for everyone else. site is gm-trucks.com
View Replies!
View Related
Can Not Login To Decated Server By Root User
i can not login to my decated server by using root. the password is not correct.. becasue i did something wrong with my server. i used chmod 777 -R /public_hmtl and chown to modify my server. and i can not login anymore, LT asked me to reload my server, do i need to reload it?
View Replies!
View Related
Plesk IIS WP User & Compromised Server
My server (using plesk 8.1 on windows 2003 server) has been compromised with some sort of rootkit and I'm investigating vulnerabilities. This server hosts some of my asp.net applications and I have to grant Modify Permission to IIS WP (iwam_plesk) user on Some subfolders (under Httpdocs folder for each domain). Is it a security problem? if yes, how else can I allow asp.net applications to write to, say, an Access db?
View Replies!
View Related
Adding Of User Defined Services In Windows 2000 Server
Just checking how do I add a Windows Defined service in Windows 2000. I saw some info. But it seemed to apply to Microsoft Windows 2003 Server as there isn't instsrv or srvany in Windows 2000 server even after I uploaded the Resource Kit Tools. Am I missing something? Or can someone tell me where to download these for Windows 2000?
View Replies!
View Related
MySQL Error : MySQL Server Has Gone Away
I keep getting this error : MySQL Error : MySQL server has gone away How do I fix it? my.cnf contents Quote: [mysqld] safe-show-database old_passwords back_log = 75 skip-innodb max_connections = 800 key_buffer = 48M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 3000 thread_cache_size = 128 wait_timeout = 90 connect_timeout = 30 tmp_table_size = 128M max_heap_table_size = 64M max_allowed_packet = 256M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 4 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 3M query_cache_size = 48M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_user_connections = 500 [mysqld_safe] nice = -5 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 64M read_buffer = 16M write_buffer = 16M [mysqlhotcopy] interactive-timeout
View Replies!
View Related
Monitoring A User's SSH? Also... Mysqld Running At 103%cpu & Stats Overload Emails
I have 3 questions. 1.) I have a user that's kinda knows a lot about linux. More than me. He has a lot of stuff on the system which I have no idea what it is. Is there any way I can install a SSH log, so I can monitor what he does in shell? 2.) My server seems REALLY sluggish. I ran a top in shell, and mysqld was taking up from 70% to 110% of the cpu. Is there any way to fix this or find out why? I've restarted the server, and it's fluctuating between 50% and 90% now. 3.) I think this MIGHT be related to the sqld issue, but I've received about 12 emails saying Quote: "[statscheck] Stats/Server Overload on my server". "MPORTANT: Do not ignore this email. This is cPanel stats runner on server1.cewxp.com! While processing the log files for user cewxp, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 15:49:16 up 5 days, 10:52, 2 users, load average: 27.59, 31.36, 31.83" and also another email Quote: IMPORTANT: Do not ignore this email. This is cPanel stats runner on server1.cewxp.com! While processing the log files for user vegapunk, the cpu has been maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of this email is 12:34:26 up 5 days, 7:37, 2 users, load average: 19.90, 17.59, 17.97
View Replies!
View Related
|
TRACKER
