RE: Mysqld eats up RAM and CPU
Hi Jan, your problems may OR may not be resolved by upgrading your Linux(?) system to kernel 2.4x, glibc2.2x and MySql to 2.32.30. I haven't been able to get a confirmation from the MySQL people that this actualy solves the problem - it is however clear that it is the dual CPUs that are causing the problems(for me anyway). I saw someone one the list that solved his problems by upgrading the BIOS on the RAID controller...I've tried this and it made noe difference for me. Now that kernel 2.4.1 has arrived I may be able to do the upgrade myself (there was some unresolved problems with INTEL pro100 ethernet cards).. /rune On Tue, 30 Jan 2001, Matis, Jan wrote: what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= wait_timeout=150 set-variable= max_connections=768 set-variable = record_buffer=12k set-variable = net_buffer_length=12k set-variable = sort_buffer=12k set-variable = table_cache=12 I've never had more than 512 conections ... but sometimes mysql looks really slow ... ant load goes up to 40 do U have some ideas ? Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Rune Hansen [EMAIL PROTECTED] Viventus AS Liaveien 11, 1411 Kolbotn +4766812280/86 "It's a damn poor mind that can only think of one way to spell a word." --Andrew Jackson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysqld eats up RAM and CPU
keybuffer=0? tablecache=0? For complicated query, Mysql may search the harddisk for stuff again, the it holds the query for sometimes...and then some more connection come in, as a result, more ram and cpu is consumed May I suggest you to lower down the max connection, and tune up the caching/buffering setting? - Original Message - From: "Scott Gerhardt" [EMAIL PROTECTED] To: "Alejandro M. Leonian" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 31, 2001 12:06 AM Subject: RE: Mysqld eats up RAM and CPU What sort of hardware are you running? - Amount of RAM - CPU speed. Hi There.. I'm running mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) on a RedHat 6.1 Os. The server is installed and the configuration is almost by default. The problem is that most of the time the mysqld threads eat up my RAM and CPU! The server gets very slow at times and it (obviously) afects its performance very badly. Since i'm no expert i have tried as much as i could learn from Deja.com and other web resources. My /etc/my.cnf looks like this: [mysqld] port=3306 socket=/tmp/mysql.sock set-variable = key_buffer=0 set-variable = record_buffer=4k set-variable = net_buffer_length=4k set-variable = sort_buffer=4k set-variable = table_cache=4 set-variable = max_connections=550 Please any pointer/tip/manual/website is appreciated. I'm kinda desperate :/. Thanks very much in advance. Latigo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysqld eats up RAM and CPU
You've got 1G Ram! Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which folder) - Original Message - From: "Matis, Jan" [EMAIL PROTECTED] To: "'Sam Wong'" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 31, 2001 12:46 AM Subject: RE: Mysqld eats up RAM and CPU what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= wait_timeout=150 set-variable= max_connections=768 set-variable = record_buffer=12k set-variable = net_buffer_length=12k set-variable = sort_buffer=12k set-variable = table_cache=12 I've never had more than 512 conections ... but sometimes mysql looks really slow ... ant load goes up to 40 do U have some ideas ? Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysqld eats up RAM and CPU
You've got 1G Ram! Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which folder) it's not for me :)) it's for customers and because I'm lamer sometimes is 1GB not enough ... huge.cnf - thanx for hint : mysql-3.23.32/support-files/my-huge.cnf.sh look at these ... Do You have any other ideas how to improve speet of my machine ? Jan there is #free total used free sharedbuffers cached Mem: 1036004 396204 639800 16396 84032 277300 -/+ buffers/cache: 348721001132 Swap: 123900 0 123900 #dmesg 2k available (1352k kernel code, 424k reserved, 10732k data, 64k init) Dentry hash table entries: 131072 (order 8, 1024k) Buffer cache hash table entries: 524288 (order 9, 2048k) Page cache hash table entries: 262144 (order 8, 1024k) VFS: Diskquotas version dquot_6.4.0 initialized Pentium-III serial number disabled. Checking 386/387 coupling... OK, FPU using exception 16 error reporting. Checking 'hlt' instruction... OK. POSIX conformance testing by UNIFIX mtrr: v1.35a (19990819) Richard Gooch ([EMAIL PROTECTED]) Pentium-III serial number disabled. per-CPU timeslice cutoff: 99.97 usecs. CPU1: Intel Pentium III (Katmai) stepping 03 calibrating APIC timer ... . CPU clock speed is 549.0806 MHz. . system bus clock speed is 99.8328 MHz. Booting processor 0 eip 2000 Calibrating delay loop... 1097.73 BogoMIPS Pentium-III serial number disabled. OK. CPU0: Intel Pentium III (Katmai) stepping 03 Total of 2 processors activated (2192.18 BogoMIPS). enabling symmetric IO mode... ...done. ENABLING IO-APIC IRQs init IO_APIC IRQs IO-APIC (apicid-pin) 2-0, 2-5, 2-10, 2-15, 2-16, 2-20, 2-21, 2-22, 2-23 not connected. ..MP-BIOS bug: 8254 timer not connected to IO-APIC ...trying to set up timer as ExtINT... .. (found pin 0) ... works. number of MP IRQ sources: 17. number of IO-APIC #2 registers: 24. testing the IO APIC... IO APIC #2.. register #00: 0200 ...: physical APIC id: 02 register #01: 00170011 ... : max redirection entries: 0017 ... : IO APIC version: 0011 register #02: ... : arbitration: 00 IRQ redirection table: NR Log Phy Mask Trig IRR Pol Stat Dest Deli Vect: 00 001 01 000 0 00751 01 000 00 000 0 01159 02 000 00 000 0 01151 03 000 00 000 0 01161 04 000 00 000 0 01169 05 000 00 100 0 00000 06 000 00 000 0 01171 07 000 00 000 0 01179 08 000 00 000 0 01181 09 000 00 000 0 01189 0a 000 00 100 0 00000 0b 000 00 000 0 01191 0c 000 00 000 0 01199 0d 000 00 100 0 00000 0e 000 00 000 0 011A1 0f 000 00 100 0 00000 10 000 00 100 0 00000 11 0FF 0F 110 1 011A9 12 0FF 0F 110 1 011B1 13 0FF 0F 110 1 011B9 14 000 00 100 0 00000 15 000 00 100 0 00000 16 000 00 100 0 00000 17 000 00 100 0 00000 IRQ to pin mappings: IRQ0 - 2 IRQ1 - 1 IRQ3 - 3 IRQ4 - 4 IRQ6 - 6 IRQ7 - 7 IRQ8 - 8 IRQ9 - 9 IRQ11 - 11 IRQ12 - 12 IRQ13 - 13 IRQ14 - 14 IRQ17 - 17 IRQ18 - 18 IRQ19 - 19 done. checking TSC synchronization across CPUs: passed. PCI: PCI BIOS revision 2.10 entry at 0xfdb02 PCI: Using configuration type 1 PCI: Probing PCI hardware PCI-APIC IRQ transform: (B0,I4,P3) - 19 PCI-APIC IRQ transform: (B0,I9,P0) - 17 PCI-APIC IRQ transform: (B1,I3,P0) - 19 PCI-APIC IRQ transform: (B1,I4,P0) - 18 Linux NET4.0 for Linux 2.2 Based upon Swansea University Computer Society NET3.039 NET4: Unix domain sockets 1.0 for Linux NET4.0. NET4: Linux TCP/IP 1.0 for NET4.0 IP Protocols: ICMP, UDP, TCP, IGMP TCP: Hash tables configured (ehash 524288 bhash 65536) IPv4 over IPv4 tunneling driver early initialization of device tunl0 is deferred GRE over IPv4 tunneling driver early initialization of device gre0 is deferred Starting kswapd v 1.5 Detected PS/2 Mouse Port. Serial driver version 4.27 with no serial options enabled ttyS00 at 0x03f8 (irq = 4) is a 16550A ttyS01 at 0x02f8 (irq = 3) is a 16550A ttyS02 at 0x03e8 (irq = 4) is a 16550A pty: 256 Unix98 ptys configured Software Watchdog Timer: 0.05, timer margin: 60 sec Real Time Clock Driver v1.09 loop: registered device at major 7 Floppy drive(s): fd0 is 1.44M FDC 0 is a National Semiconductor PC87306 sym53c8xx: at PCI bus 1, device 4, function 0 sym53c8xx: 53c895 detected with Symbios NVRAM sym53c895-0: rev=0x01, base=0xfa201000, io_port=0x9000, irq=18
RE: Mysqld eats up RAM and CPU
on my server which runs an online game the values are all in the megabytes On Wed, 31 Jan 2001, Tony Shiu wrote: I wonder the normalization and indexing of tables, Awa the complexity of queries submitted to server. For those variables you mentioned I use in production without significantly slow-down in peak time. -Original Message- From: Matis, Jan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:46 AM To: 'Sam Wong'; [EMAIL PROTECTED] Subject: RE: Mysqld eats up RAM and CPU what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= wait_timeout=150 set-variable= max_connections=768 set-variable = record_buffer=12k set-variable = net_buffer_length=12k set-variable = sort_buffer=12k set-variable = table_cache=12 I've never had more than 512 conections ... but sometimes mysql looks really slow ... ant load goes up to 40 do U have some ideas ? Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Mysqld eats up RAM and CPU
Let me clarify that those variables in the list Jan mentioned I use mysql default values, others unmentioned I make them near megabytes. Per Andrei replied, I suspect it is due to design/query problems. -Original Message- From: Andrei Cojocaru [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:49 PM To: Tony Shiu Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject:RE: Mysqld eats up RAM and CPU on my server which runs an online game the values are all in the megabytes On Wed, 31 Jan 2001, Tony Shiu wrote: I wonder the normalization and indexing of tables, Awa the complexity of queries submitted to server. For those variables you mentioned I use in production without significantly slow-down in peak time. -Original Message- From: Matis, Jan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:46 AM To: 'Sam Wong'; [EMAIL PROTECTED] Subject: RE: Mysqld eats up RAM and CPU what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= wait_timeout=150 set-variable= max_connections=768 set-variable = record_buffer=12k set-variable = net_buffer_length=12k set-variable = sort_buffer=12k set-variable = table_cache=12 I've never had more than 512 conections ... but sometimes mysql looks really slow ... ant load goes up to 40 do U have some ideas ? Jan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -Spinlock EmpireQuest Creator http://www.empirequest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php