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.
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 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
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, April 16, 2013 2:06 AM
To: Ilya Kazakevich
Cc: MySQL
Subject: Re: Mesaure query speed
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' speed?
Ilya Kazakevich
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
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