Re: Query dies silently
Gleb Paharenko wrote:
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.
Good call. I did some testing, and sure enough, the mysql_query() is
successful. The failure comes in trying to retrieve the rows using
while($row = mysql_fetch_assoc($queryID))
{
$arrResults[] = $row;
}
So, it would seem that I need to take this issue to a different list.
Isn't the PHP level logging high enough? Increase the memory_limit
variable in you php.ini.
I did try to do an ini_set() on the memory_limit variable, but it
appears that my host does not have this enabled.
Thanks for the tips.
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query dies silently
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]
Query dies silently
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- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
