Nope, no luck. I double-checked the code and it is doing the SQL_BIG_TABLES
for the database handle that was created. /var/tmp has about 8gigs available
in it. I also did the --big-tables on the command line for starting up mysql
as well as bumping tmp_table_size from 1gig to 2gig, but no luck.
I'm not sure? Any other ideas?
Thanks
Dave
[EMAIL PROTECTED]
-----Original Message-----
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 12:26 PM
To: 'Dave Camarillo'; '[EMAIL PROTECTED]'; Quentin Bennett
Subject: RE: Full tables...w/ show variables
Hello again.
A few thoughts - nothing certain, and all derived from the fine manual,
which you have already read, I'm afraid:
Are you issuing the SQL_BIG_TABLES=1 in the same connected session as the
query?
Is there enough space in '/var/tmp'? However, if that was filling up, mysqld
would wait for it to empty, rather than report an error.
Are you able try setting the --big-tables option for the server, or increase
the 'tmp_table_size' variable?
If these lead nowhere, I'll have to leave it to the MySQL guys to figure
out.
Regards
Quentin
-----Original Message-----
From: Dave Camarillo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 15 March 2001 8:43 a.m.
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: Full tables...w/ show variables
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.
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
