using index

I have this table +---+--+--+-++-- --+ | Field | Type | Null | Key | Default| Extra | +---+--+--+-++-- --+ | ID| int(10) unsigned | | PRI

Re: slow querys

Hi, The slow queries are those like... SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1 where table have about 20.000 records and field is a text field. I need to find ALL the records that have "text", even if text is "a" i have to find all the records that have one "a". Man

mysql becomes slow

Hi, I have one p3-800, 2 uwscsi hd , debian, apache 1.3.20, php4.0.5 and mysql 3.23.38 I have one web aplication with about 10.000 visits per day and about 8.000.000 pages visited per month. Only one database with about 15 tables, the main with about only 20.000 records. The problem is that t

problems

Hi, I have one site developed with php+mysql. We have about 10.000 visits per day with more or less 250/300 users on prime time. When users increase over 200 mysql starts runing some errors and restarting... Number of processes running now: 0 010402 21:33:13 mysqld restarted /usr/sbin/my

problems

Hi, I have one site developed with php+mysql. We have about 10.000 visits per day with more or less 250/300 users on prime time. When users increase over 200 mysql starts runing some errors and restarting... Number of processes running now: 0 010402 21:33:13 mysqld restarted /usr/sbin/mysql