On Fri, Apr 10, 2009 at 10:40 AM, Wm Mussatto wrote:
> On Fri, April 10, 2009 05:24, Uwe Kiewel wrote:
>> Moon's Father wrote:
>>> Hi.
>>> If the server has 16 cores, how to set parameters to make MySQL runs
>>> well.
>>
>> IIRC is mysqld multi threaded - so if you have parallel queries, mysqld
This is part of the SQL Standard. MySQL has a worklog open on it:
http://forge.mysql.com/worklog/task.php?id=2081
On Sat, Feb 14, 2009 at 9:05 PM, Moon's Father
wrote:
> Hi.
> Who could tell me when the MySQL support array datatype?
> Any reply will be appreciated.
>
> --
> I'm a MySQL DBA in
Sounds like you want to walk tables in order of their fk dependencies
- a topological ordering. You might want to take a look at SQLAlchemy
which has some methods to do just this in sqlalchemy.sql.util:
def sort_tables(tables, reverse=False):
"""sort a collection of Table objects in order of
On Tue, Jan 13, 2009 at 6:06 PM, Dan wrote:
> On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
> wrote:
>
>> This sounds like you need to raise max_allowed_packet for mysqldump
>> (and possibly mysqld) - these are separate settings for both the
>> client and the serve
On Tue, Jan 13, 2009 at 7:07 PM, Baron Schwartz wrote:
>> If you have separate indexes on ssn and id_num, MySQL may be able to
>> efficiently use an index merge optimization . See
>> http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html.
>> This is only in 5.0+ - on older versions
Do you have an index on id_num? What sort of explain output do you
get when you don't use a query hint? Your USE INDEX hint may be
causing MySQL to ignore a better strategy.
If you have separate indexes on ssn and id_num, MySQL may be able to
efficiently use an index merge optimization . See
ht
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or specify it as an option on the command line "mysqldump --opt ...
--max_allowed_packet=1G dbna
On Wed, Oct 8, 2008 at 3:10 AM, Zbigniew Szalbot <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I hope someone can help. Due to they way my HD has been sliced I had
> to move mysql database to /usr/local/mysql. All works fine. Last week
> I added this entry:
>
> #expire bin logs
> expire_logs_days = 7
