List:General Discussion« Previous MessageNext Message »
From:jkraai Date:May 2 1999 6:50am
Subject:3.22.21 RAM Usage
View as plain text  
Just upgraded from 3.21.33b to 3.22.21.  Running 
on RH5.2.

Previously, when I'd do a top, mysqld's were using 
around 20M of RAM each.

Here's the /etc/my.cnf:
[mysqld]
log-update = /usr/local/var/mysql.update
set-variable = key_buffer=16M
set-variable = table_cache=256
set-variable = sort_buffer=8M
set-variable = record_buffer=1M

Now, when I do a top, mysqld's are using around 6.5M.

Was I just seeing things before?  

Thanks!

--jim

Here's the output of mysqladmin variables:
+----------------------------+---------------------------------+
| Variable_name              | Value                           |
+----------------------------+---------------------------------+
| back_log                   | 5                               |
| connect_timeout            | 5                               |
| basedir                    | /usr/local/                     |
| datadir                    | /usr/local/var/                 |
| delayed_insert_limit       | 100                             |
| delayed_insert_timeout     | 300                             |
| delayed_queue_size         | 1000                            |
| join_buffer                | 131072                          |
| flush_time                 | 0                               |
| key_buffer                 | 16773120                        |
| language                   | /usr/local/share/mysql/english/ |
| log                        | OFF                             |
| log_update                 | ON                              |
| long_query_time            | 10                              |
| low_priority_updates       | OFF                             |
| max_allowed_packet         | 1048576                         |
| max_connections            | 100                             |
| max_connect_errors         | 10                              |
| max_delayed_insert_threads | 20                              |
| max_join_size              | 4294967295                      |
| max_sort_length            | 1024                            |
| net_buffer_length          | 16384                           |
| port                       | 3306                            |
| protocol-version           | 10                              |
| record_buffer              | 1044480                         |
| skip_locking               | ON                              |
| socket                     | /tmp/mysql.sock                 |
| sort_buffer                | 8388600                         |
| table_cache                | 256                             |
| thread_stack               | 65536                           |
| tmp_table_size             | 1048576                         |
| tmpdir                     | /tmp/                           |
| version                    | 3.22.21-log                     |
| wait_timeout               | 28800                           |
+----------------------------+---------------------------------+
Thread
DISTINCT and COUNT() SQL QueryMike Machado1 May
  • Re: DISTINCT and COUNT() SQL Queryjkraai1 May
    • Re: DISTINCT and COUNT() SQL QueryPaul DuBois1 May
  • RE: DISTINCT and COUNT() SQL QueryDon Read1 May
  • Re: DISTINCT and COUNT() SQL QueryMike Machado1 May
    • Re: DISTINCT and COUNT() SQL QueryThimble Smith1 May
  • Re: DISTINCT and COUNT() SQL QueryJim Faucette1 May
  • 3.22.21 RAM Usagejkraai2 May
    • 3.22.21 RAM UsageMichael Widenius2 May
  • Re: 3.22.21 RAM Usagejkraai2 May
  • a problemglen19 May
    • Re: a problem (The table 'SQL134597_0' is full)Pete Harlan20 May
      • Re: a problem (The table 'SQL134597_0' is full)glen20 May
        • Re: a problem (The table 'SQL134597_0' is full)Benjamin Pflugmann21 May
        • Re: a problem (The table 'SQL134597_0' is full)Michael Widenius24 May