Which MySQL server do you use?
What is your storage engine?
-Original Message-
From: Ken D'Ambrosio [mailto:k...@jots.org]
Sent: Friday, February 05, 2010 5:26 PM
To: mysql@lists.mysql.com
Subject: Help optimizing settings?
I've got a fairly large -- 100+ GB -- MySQL database. It isn't
Hello John,
There was a joke in russian PHP club: "why strore images in database? Are
you going to have a full text search on them?"
IMHO:
Storing files in DB is probably bad idea.
Here are some advantages of storing files on filesystem:
1) Theoretically it takes more time to load data from data
several ideas:
* Count 'Innodb_rows_read' or 'Innodb_pages_read' instead of actual time
* Set pool as small as possible to reduce its effect on query speed
* Set pool larger than my db and run query to load all data into pool and
measure speed then
How do you measure your queries'
_pool should be set to about 70% of
available
>RAM.
I will increase it now.
But I will need to disable swapping also to prevent my OS from swapping out
InnoDB pages.
Ilya.
>
>> -Original Message-
>> From: Ananda Kumar [mailto:anan...@gmail.com]
>> Sent: Tuesday, Apri
Hello Richard,
>the count(*) for each week of 2013 so that I end up with:
http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html
Ilya.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello,
Try to use "tuning-primer.sh": this scripts reads your variables and prints
memory size you need for that.
Here is example of its output:
MEMORY USAGE
Max Memory Ever Allocated : 2.86 G
Configured Max Per-thread Buffers : 1.80 G
Configured Max Global Buffers : 2.10 G
Configured Max Memory
Hello,
>Many thanks for your response. Can yo u offer any advice with regards
usage
>of country_codes eg gb and regions, cities etc ? I've been reading up on
>http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to use a
>Surrogate key for countries ? Or the country code like fr for
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
