Hello there,
I am getting connected to MySQL through SSL.
I want to see the logs of SSL getting trigerred when someone access MySQL
database from any application or URL.
Where do I need to modify or edit the configuration, in order to see the SSL
logs?
I can only see the query logs as of now
Than
i do not use text for start_postion,i use int for it. the only col which
defined to text is characters such as "ABTGDSDFSGFDG" etc.
2009/7/13 Darryle Steplight
> Numeric indexing is a lot faster. You definitely shouldn't use text or
> varchar types as column types for you min and max values. Do
Numeric indexing is a lot faster. You definitely shouldn't use text or
varchar types as column types for you min and max values. Do an ALTER
TABLE on any column only hold numeric values and switch them to int
or mediumint.
On Mon, Jul 13, 2009 at 12:36 AM, TianJing wrote:
> sorry fo that, but i
sorry fo that, but i really need all cols in the table, i think the problem
maybe caused by one of the col which is text type, each record of this col
has 2000 characters. this makes the size of record more biger.
2009/7/13 Darryle Steplight
> You are still doing SELECT * . Do you really need to
You are still doing SELECT * . Do you really need to return all of the
columns in that table or just COL1, COL2, COL5 for example. Only grab
the columns you are actually going to use.
On Mon, Jul 13, 2009 at 12:23 AM, TianJing wrote:
> thanks for reply,
>
> i hava an index on the start_position,th
thanks for reply,
i hava an index on the start_position,the min_postion and the max_postion is
constant value, the output of the query is:
explain select * from REF_SEQ where START_POSITION between 3 and
803;
++-+-+---+-+-+
1. Don't use SELECT *. Only grab the cols that you only need. Also
make sure you have an index on min_position and max_position. After
that if your query isn't faster please show us the output of running
EXPLAIN select * from table_name where start_postion between
min_postion and
max_postion" .
At 08:06 PM 7/12/2009, Morten wrote:
Mike, you're right - sorry.
I've been reading High Performance MySQL today and got some great tips
from that which will help a lot.
Yes it is a good book. I hope you have the 2nd edition.
I think the fundamental challenge
now, is that the table contains
Hi all,
i use "select * from table_name where start_postion between min_postion and
max_postion" to select all the record in the ranges,
when the ranges is very large,such as 800(about 1000 record in it), the
query is so slow,
when i use mysql administrator i find that traffic is higher when
Mike, you're right - sorry.
I've been reading High Performance MySQL today and got some great tips
from that which will help a lot. I think the fundamental challenge
now, is that the table contains a lot of timestamps, and querying
against these involves multiple range queries which makes
Morten,
Perhaps you could also add how many rows are in the table, how many
rows are added each day, what are the column types, and what do the search
queries look like?
Mike
At 11:39 AM 7/12/2009, Morten wrote:
Hi,
I'm working on a table that has about 12 columns against which
arbi
Hi,
I'm working on a table that has about 12 columns against which
arbitrary queries must perform really well. Currently there are a lot
of indexes on the table, but I'm hitting some problems - and adding
more indexes seems a slippery slope (there are ~15 multi-column
indexes, I'd like t
B J Ambrose wrote:
> russbucket wrote:
>>
>> I agree with you, but phpMyAdmin is not available for Windows that I'm
>> aware of. The person I'm helping today is a windows user and except for a
>> little Access Experience does not do databases well. I have the database
>> set up in mysql so thats w
13 matches
Mail list logo
