Hello.
> I get 142k rows back in just over 4 seconds.
It means that on the server side query works, so the problem
probably is in PHP.
> However, when I run this query using PHP through the browser, I get
> nothing at all. Occasionally, I get get an error about not being able
> to store the result, but this error does not always display.
Isn't the PHP level logging high enough? Increase the memory_limit
variable in you php.ini.
Erich C. Beyrent wrote:
> Hi all,
>
> I have a rather strange problem that I cannot seem to figure out. When
> I run the following query from the MySQL console:
>
> SELECT
> Inventory.ID as InventoryID,
> Inventory.Name,
> Inventory.Capacity,
> Inventory.Beds,
> Avails.ID as AvailabilityID,
> Avails.ResortID,
> Avails.Cost,
> Avails.OpenWhen
> FROM
> Inventory,
> Avails
> WHERE
> Avails.InvID = Inventory.ID AND
> Avails.OpenWhen > NOW() AND
> (Avails.StatusCode = 'GREEN' OR
> Avails.StatusCode = 'YELLOW')
> ORDER BY
> Avails.ResortID,
> Avails.InvID,
> Avails.OpenWhen;
>
> I get 142k rows back in just over 4 seconds.
>
> However, when I run this query using PHP through the browser, I get
> nothing at all. Occasionally, I get get an error about not being able
> to store the result, but this error does not always display.
>
> Is there some kind of query size limit that I am running into, or
> perhaps a temp table limit that is too low?
>
> mysql> show variables;
> ++---+
> | Variable_name | Value |
> ++---+
> | back_log | 5 |
> | connect_timeout| 5 |
> | basedir| / |
> | datadir| /var/lib/mysql/ |
> | delayed_insert_limit | 100 |
> | delayed_insert_timeout | 300 |
> | delayed_queue_size | 1000 |
> | join_buffer| 131072|
> | flush_time | 0 |
> | key_buffer | 8388600 |
> | language | /usr/share/mysql/english/ |
> | log| OFF |
> | log_update | OFF |
> | 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 |
> | max_write_lock_count | 4294967295|
> | net_buffer_length | 16384 |
> | pid_file | /var/lib/mysql/mysqld.pid |
> | port | 3306 |
> | protocol_version | 10|
> | record_buffer | 131072|
> | skip_locking | ON|
> | skip_networking| OFF |
> | socket | /var/lib/mysql/mysql.sock |
> | sort_buffer| 2097144 |
> | table_cache| 64|
> | thread_stack | 65536 |
> | tmp_table_size | 1048576 |
> | tmpdir | /tmp/ |
> | version| 3.22.32 |
> | wait_timeout | 28800 |
> ++---+
>
> Please note that this database is on a host, and the version of the DB
> is out of my control.
>
> -Erich-
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]