HUGE ProcessList

| localhost || Query | 3|| show processlist | ++---+---++-+--++--- --- + Ryan Shrout Owner - Amdmb.com http

HUGE Process List

| localhost || Query | 3|| show processlist | ++---+---++-+--++--- --- + Ryan Shrout Owner - Amdmb.com http

MySQL problem with Traffic and Updates

this, so I don't think the problem is so much in the software, but something about my MySQL config or setup. I realize this may be a MySQL issue as much as it is a PhpAdsNew issue, but I was really hoping someone here would be able to help me out with some suggestions. Thanks! Ryan Shrout Owner

Re: MySQL processor overload

This problem is almost exactly like the load level on linux one seen earlier, and like about 5 others I've seen on this list including my own. Why is we can not get a straight answer from anyone on this??? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original

Re: MySQL Performance Problem

I can't help you with your problem, because I have almost the same thing happening to my server every 2-3 days. It is exactly as you described Please someone offer us suggestions?? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From

Enabling Logging of Slow Queries

and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1

Thank you for the tip, but this is not our problem. We are running SCSI disks with over 40 MB/sec throughput. Any other ideas? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Ryan Shrout [EMAIL

MySQL Spawns Many Processes and Uses 100% CPU! PART #2

(including database table formats, queries, etc) please let me know! I will be more than happy to give them to you!! Thanks to anyone who helps me out!!! Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED]

MySQL Spawns Many Processes and Uses 100% CPU! PART #1

out what is going on here. I raised the max_connections from 100 to 300, and edited the following httpd.conf settings: MinSpareServers 15 MaxSpareServers 30 StartServers 15 MaxClients 150 MaxRequestsPerChild 1000 Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED]

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #1

Jeremy, it was included in PART #2 of the problem message. Did you get that? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August

Re: Mysql causing severe load problems on Dual-Athlon server?

, Pages.PageTitle, Pages.Text FROM Pages, Articles WHERE Ar | ++---+---+---+-+--++ --+ [root@dagger /root]# Ryan Shrout Owner - Amdmb.com

Re: Mysql causing severe load problems on Dual-Athlon server?

This just happened a second time today... that is the most frequent yet. Please, you have got to help me on this! Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: [EMAIL

Re: Mysql causing severe load problems on Dual-Athlon server?

Sorry, but this system has quad 15K RPM SCSI hard drives running RAID 0+1. I don't think hdparm applies to that. Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Sent

Re: Mysql causing severe load problems on Dual-Athlon server?

there is HDA? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 1:13 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon

MySQL + Ad Software

that doesn't have a MySQL backend, and just works off a flat file, please let me know! Thanks! Ryan Shrout Production Manager Athlonmb.com http://www.athlonmb.com [EMAIL PROTECTED]

SQL Import on MySQL

) NOT NULL , [Title] [cha' at line 1 What is the syntax problem that I am missing? And can I make MS SQL output the sql file in the correct way? Ryan Shrout Athlonmb.com Production Manager http://www.athlonmb.com/ [EMAIL PROTECTED]

Unique/Index/Primary

Could someone explain to me the difference between the Primary/Index/Unique attributes of MySQL? I am coming from using MS SQL where there is only the Primary key option. Sorry if this is too beginner of a question for this list. Ryan Shrout Athlonmb.com Production Manager http

INSERT INTO Table problems

d it fail? Thank you for your assistance. Ryan Shrout Production Manager Athlonmb.com http://www.athlonmb.com [EMAIL PROTECTED]

Warning: MySQL Connection Failed - Initial Install Help

connect to loacl MySQL server through socket 'var/lib/mysql/mysql.sock' (111). When I go to the /var/lib/mysql directory, there is nothing listed in a 'ls' command. Thanks for any help. As you can guess, I am rather new the Linux as a server operating system. Ryan Shrout Athlonmb.com Production