> >
> >
> >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
but cuts down a show databases on a server with 60.000
databases from 15 seconds to 0.14 seconds which is ok.
Same here - my database names start with username+underscore, so query
now takes 0.05 instead of 6 secs (I have about 15000 DBs).
--
Alexey Polyakov
--
MySQL General Mailing List
Fo
s standard user
>
> + observed file system activity.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mys
between number of records and query time where the records I am
> selecting are within a small range?
For studying select query performance issues it's better think about
index as simply about a sorted array with random-access, where each
random access costs O(lgN) and accesses to adjanced data
se in question,
then I think that check_grant_db I mentioned in previous email may be
safely hacked away.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
_db(thd, file_name)))
If a query runs faster when user has access to more DBs, then the
problem most likely lies within check_grant_db function.
But it all needs more careful investigation.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
ERE fullname LIKE "j%" AND user_id=1
>ORDER BY fullname LIMIT 10;
Probably because the engine is not using (fullname) index for this
query - optimizer sees 'const' ref for user_id, retrieves all rows
that have user_id=1 and then filters/sorts them all.
--
Alexey Po
tioning. MySQL 5.1 will have
built-in partitioning support, but the idea itself is very simple, and
you can achieve the same effect by manually spreading data among
tables.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
found out that
dir_index on ext3 doesn't help at all, it actually harms performance.
'noatime' and 'nodiratime' options do help a little.
Also, 14000 subdirectories is not something that will cause 15 seconds
delay - those 14000 subdirectories will always live in OS dentry cac
x27;ve read, and the sample my-*.cnf files that ship
> with the tarball appear to apply to the more typical installation of a
> single huge database rather than thousands of individual dbs. Can
> anyone offer any suggestions?
>
> Thanks,
>
> Gary Huntress
>
>
> --
> M
r list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yeah, it's perfectly ok to run both on the same machine at the same
time, though with MS SQL you're limited to Microsoft OS.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Adding compound (hash, years) index (or even better unique index if it
fits in your business logic) in both tables should speed up things.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mercial license).
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oops, I was obviously wrong about your example, please ignore it. :)
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql.com/doc/mysql/en/loose-index-scan.html
>
> To get decent GROUP BY performance. Is this a bug? Is there a
> workaround?
>
> Kevin A. Burton, Location - San Francisco, CA
> AIM/YIM - sfburtonator, Web - http://www.feedblog.org/
> GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04
>
>
>
>
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dditional_mem_pool_size and
innodb_log_buffer_size, cause those are allocated only once, and looks
like you have enough memory for bigger values.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
card records for every
> category used (one or various)?
>
> Thanks for any comment.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Theres --bind-address mysqld startup option, but I'm afraid it allows
specifying only one IP to bind to.
One of workarounds for your problem is to make it listening on all
IPs, but configure firewall to drop all TCP packets going to port 3306
not on IPs you want.
--
Alexey Polyakov
--
tables), and import this dump into second
database.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from db server. One way to do this is to issue 'SET NAMES latin1'
query after establishing a connection. There are also some ways to set
this as global option for all websites if you can't modify scripts.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://l
oes a scan of second table, which is performance
killer.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> However, I am trying to move my RH 9 system to Centos 4.1 and
> everything has gone well until I though I could just copy the mysql db
> into the new server.
You can. Just make sure you add old-passwords option to your my.cnf file.
--
Alexey Polyakov
--
MySQL General Mailing List
Bytes IIRC. Depending on actual content it can be 127-255 characters.
Why do you choose to convert varchar to tinytext? Doesn't look like
good idea to me.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
hink it is due to an unexpected
> config-file option
Add
log=OFF
line to your my.cnf.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in the slow query log beause it
> uses an index...)
It won't be logged if it actually will use index. In your example it won't
use index, full table scan will be used instead, because query optimizer is
able to determine that all records match where condition.
> --
> Alexey Polyakov
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
--
Alexey Polyakov
Yeah, it's safe.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Variable_name | Value |
> +---+-+
> | query_cache_limit | 5242880 |
> | query_cache_size | 3145728 |
> | query_cache_type | ON |
> +---+-+
> 3 rows in set (0.00 sec)
>
>
> Thank you.
>
> --
> Cheers,
> Maxim Vexler (hq4ev
you think? Processing cycles I have
> but easy disk space I don't.
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tions are not set explicitly in my.cnf, server could
be using ones specified during compilation.
To check charsets and collations on the running server do:
show global variables like 'c%';
--
Alexey Polyakov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
32 matches
Mail list logo