2013/06/11 12:59 -0700, Daevid Vincent
Also, just for S&G this is how we are currently implementing it, but we feel
the REGEXP is killing our queries and while "clever" is a bit hacky and
nullifies any indexes we have on the genres column as it requires a
file_sort table scan to compare s
Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
> this combined with file-per-table engines like MyISAM or ARCHIVE (maybe with
> InnoDB with innodb-file-per-table
> being active, too?) may well lead
> to a lot of file handles being used, and this again combined with the
> table_cache keeping o
Assuming Linux, check where it's listening using "netstat -lptn".
lx wrote:
>hi all:
>I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
>client in 192.168.23.73.
>I use this way:
> mysql -h 192.168.27.72 -u root -p
>
>the ERROR message is:
>ERROR 2003 (HY000): Can't connect
hi all:
I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
client in 192.168.23.73.
I use this way:
mysql -h 192.168.27.72 -u root -p
the ERROR message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.27.72' (111)
##
On 06/13/2013 09:41 AM, walter harms wrote:
Hello Manuel,
thx for your tip. We caught the problem when we moved to partitions. Strange is
that
while testing the problem did not show up and even now we no clue why we
experience
the sudden burst of use for file descriptors.
problem with partit
Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
> On 06/13/2013 09:41 AM, walter harms wrote:
>
>> Hello Manuel,
>> thx for your tip. We caught the problem when we moved to partitions.
>> Strange is that
>> while testing the problem did not show up and even now we no clue why
>> we experience
>
Am 12.06.2013 12:33, schrieb Manuel Arostegui:
> 2013/6/12 walter harms
>
>>
>> Hi list,
>> i am trying to understand the incredible use of filepointers in our mysql
>> server (5.1.53).
>> under normal condition the server reports 10k-15k open files pointer.
>> I run a 'flush tables' every 2h t
