cant select more than 1000 records

[bart@sonik.pl]

Hi all
command "select * from table" whith 3000 records give me only 1000
rows
I can't figure out what is wrong. I think that something wrong is with
my my.cnf but can't find which varaible I have to change. Can you
sugest something?

[mysqld]
skip-locking
set-variable = max_user_connec tions=100
set-variable = max_connections =150
set-variable = key_buffer=128M
set-variable = join_buffer=4M
#set-variable = record_buffer=1 M
set-variable = sort_buffer=5M
set-variable = table_cache=102 4
set-variable = myisam_sort_buf fer_size=32M
set-variable = thread_cache_si ze=128
set-variable = wait_timeout=45
set-variable = connect_timeout =10
set-variable = interactive_tim eout=60
set-variable = max_allowed_pac ket=16M
set-variable = max_connect_err ors=10
set-variable = flush_time=600
innodb_data_hom e_dir = /var/lib/mysql/
innodb_data_fil e_path = ibdata1:10M:aut oextend
set-variable = innodb_addition al_mem_pool_siz e=5M

[querycache]
#query_cache_li mit = 1M
query_cache_siz e = 32M
query_cache_typ e = 1
thread_concurre ncy=4

[mysqldump]
quick
set-variable= max_allowed_pac ket=16M

[mysqlhotcopy]
interactive-timeout

[isamchk]
set-variable = key=16M
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[myisamchk]
set-variable = key_buffer=20M
set-variable = sort_buffer=20M
set-variable = read_buffer=2M
set-variable = write_buffer=2M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
safe-updates

[Peter]

Re: cant select more than 1000 records

What interface are you using for retrieving data? Are you using mySQL
control center? In this case, you must edit the connection and set-up the
limit to "unlimited" . By default, mySQLcc only retrieves 1000 records.

HPEter
<bart@sonik.p l> wrote in message
news:a45bb295.0 408010215.1b59c 2c@posting.goog le.com...[color=blue]
> Hi all
> command "select * from table" whith 3000 records give me only 1000
> rows
> I can't figure out what is wrong. I think that something wrong is with
> my my.cnf but can't find which varaible I have to change. Can you
> sugest something?
>
> [mysqld]
> skip-locking
> set-variable = max_user_connec tions=100
> set-variable = max_connections =150
> set-variable = key_buffer=128M
> set-variable = join_buffer=4M
> #set-variable = record_buffer=1 M
> set-variable = sort_buffer=5M
> set-variable = table_cache=102 4
> set-variable = myisam_sort_buf fer_size=32M
> set-variable = thread_cache_si ze=128
> set-variable = wait_timeout=45
> set-variable = connect_timeout =10
> set-variable = interactive_tim eout=60
> set-variable = max_allowed_pac ket=16M
> set-variable = max_connect_err ors=10
> set-variable = flush_time=600
> innodb_data_hom e_dir = /var/lib/mysql/
> innodb_data_fil e_path = ibdata1:10M:aut oextend
> set-variable = innodb_addition al_mem_pool_siz e=5M
>
> [querycache]
> #query_cache_li mit = 1M
> query_cache_siz e = 32M
> query_cache_typ e = 1
> thread_concurre ncy=4
>
> [mysqldump]
> quick
> set-variable= max_allowed_pac ket=16M
>
> [mysqlhotcopy]
> interactive-timeout
>
> [isamchk]
> set-variable = key=16M
> set-variable = key_buffer=20M
> set-variable = sort_buffer=20M
> set-variable = read_buffer=2M
> set-variable = write_buffer=2M
>
> [myisamchk]
> set-variable = key_buffer=20M
> set-variable = sort_buffer=20M
> set-variable = read_buffer=2M
> set-variable = write_buffer=2M
>
> [mysql]
> no-auto-rehash
> # Remove the next comment character if you are not familiar with SQL
> safe-updates[/color]