Re: [Webware-discuss] 'Lost connection to MySQL server during query'

[Aaron H. <aa...@me...>]

Here is my ugly work-around:

I had a midnight script that would import shut down webware, start up 
another instance of webware that would put up a 'System undergoing 
update, back in xxxminutes',
then it would drop the indexes, import 250k records, delete 250k 
records, rebuild indexes and vaccum static.
after that it would restart webware.

The app NEEDS indexes to work and the import took much too w/ indexes so 
this was the only approach to get it up the next day.

-Aaron

Frank Barknecht wrote:

>Hallo,
>Aaron Held hat gesagt: // Aaron Held wrote:
>
>  
>
>>Sorry,
>>I had the same problem with pgSQL a little over a year ago.  I'm a fan 
>>of Postgres and have had million row tables, but you will get the same 
>>connection issue.
>>    
>>
>
>So, may I ask: What did you do then? I mean, lots of us need (and use)
>databases in the back, and it seems, that "normally" it just works. 
>
>ciao
>  
>