Wow...thanks for the quick response...
The mysql variables are:
+-------------------------+---------------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------------+
| ansi_mode | OFF |
| back_log | 50 |
| basedir | /usr/local/mysql/ |
| binlog_cache_size | 32768 |
| character_set | latin1 |
| character_sets | latin1 cp1251 |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /usr/local/mysql/var/ |
| delay_key_write | ON |
| delayed_insert_limit | 4000 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 4000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | NO |
| have_gemini | NO |
| have_innobase | NO |
| have_isam | YES |
| have_raid | YES |
| have_ssl | NO |
| init_file | |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 0 |
| language | /usr/local/mysql/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 200 |
| max_connect_errors | 10 |
| max_delayed_threads | 150 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /usr/local/mysql/var/XXXXXXX.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 536866816 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| skip_locking | OFF |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer | 134217720 |
| table_cache | 1024 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_concurrency | 10 |
| thread_stack | 65536 |
| timezone | PST |
| tmp_table_size | 1048576 |
| tmpdir | /var/tmp/ |
| version | 3.23.33 |
| wait_timeout | 28800 |
+-------------------------+---------------------------------------+
Dave Camarillo
[EMAIL PROTECTED]
-----Original Message-----
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 11:34 AM
To: 'Dave Camarillo'; [EMAIL PROTECTED]
Subject: RE: Full tables...
Hi,
The output from
mysqladmin variables
would be useful.
Quentin
-----Original Message-----
From: Dave Camarillo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 7:42 a.m.
To: [EMAIL PROTECTED]
Subject: Full tables...
Hello all,
I've run into a minor problem with my schema/mysql. I have a table with 64
columns (varying data-types) and about 7 indexes (some multi-column indexes)
containing roughly 19 million records. Were running Solaris 2.8 on Sparc
with mysql 3.23.33 with raid-tables and large files compiled in with gcc
2.95.2. In my development, I have roughly 30 MyISAM tables that are
identical in columns/indexes to this particular table, the only difference
is the number of records in this table (this table has the most records)
My problem, is that when I go to do an update statement to the table, I get
an error message back from the Perl DBI saying that "The table BLABLABLA is
full". I have this table set up with raid-0, across 8 slices, each slice
with a max size of 2 gigs. (in theory the max size of the table would be 16
gigs). After looking at the actual table slices in the mysql data directory,
the sum of the slices only takes up about 4.5 gigs while, the index file is
about 1.5 gigs and only in 1 file. There is plenty of memory on the machine,
currently mysql has malloc'ed about 4 gigs.
In my code, I've tried putting in "SET SQL_BIG_TABLES=1;", however I still
get the same error.
What kinds of things cause "Table Full" errors? I've looked through the
mysql documentation, however I haven't been able to find a fix that works.
Any suggestions, ideas etc?
Thanks
Dave
[EMAIL PROTECTED]
Some other info about how mysql is setup:
Tmp_table_size=1gig
Record buffer = 512M
Table cache = 1gig
Key_buffer = 1gig
(I've been playing around with these settings so I know they are not
optimal)
Another question, off this subject. The most memory I've seen mysql use is 4
gigs. Is it possible for it to use more? Do I need to compile it with a
different memory model? If so, what kind of model and where can I find out
more about it.
---------------------------------------------------------------------
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
