Privet!
What hardware does your server have? What version of MySQL have you tested? If key_buffer_size isn't enough for indexes of smacker's table then performance could go bad (in my my-medium.cnf it is only 16M). Thread cache gives performance hint for my-large.cnf. Add SQL_NO_CACHE to query in smack's file to disable the influence of query cache (it's present in my-large.cnf) and compare results again. Oleg Rusanov <[EMAIL PROTECTED]> wrote: > Hello. > my-large.cnf is twice quicklier, but the description from > my-medium.cnf is approaches (such as a web server). > It is necessary that Mysql worked twice more slowly on a web server? > > amd64# uname -r > 5.4-STABLE > make WITH_XCHARSET=all BUILD_OPTIMIZED=yes BUILD_STATIC=yes install > > --------------------------my-medium.cnf-------------------------------------- > description: > # This is for a system with little memory (32M - 64M) where MySQL plays > # an important part, or systems up to 128M where MySQL is used together with > # other programs (such as a web server) > > test: > Query Barrel Report for client smacker1 > connect: max=4ms min=2ms avg= 2ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 20000 0 0 11858.11 > > --------------------------/my-medium.cnf-------------------------------------- > > --------------------------my-large.cnf-------------------------------------- > description: > # This is for a large system with memory = 512M where the system runs mainly > # MySQL. > > test: > Query Barrel Report for client smacker1 > connect: max=4ms min=2ms avg= 2ms from 10 clients > Query_type num_queries max_time min_time q_per_s > select_index 20000 0 0 21777.24 > --------------------------/my-large.cnf-------------------------------------- > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
