slow queries not being logged

2010-02-22 Thread Machiel Richards
Good day all I hope you can assist me with this one... We have a client where the slow query log was disabled. We noticed that the slow query amount (when viewing global status) has skyrocketed during the last 2 weeks going up to over 2 mi

RE: how things get messed up

2010-02-22 Thread Jerry Schwartz
I thought I had replied publicly to Johan’s suggestion, with some personal experience. He’s absolutely right, that would give you a solution that would be completely transparent to your application and therefore much easier to implement. You could keep re-arranging your partitions as necessa

Partitioning

2010-02-22 Thread Jerry Schwartz
I’d like to know your opinions about partitioning the following table. Here’s the relevant snippet: Create Table: CREATE TABLE `prod_price` ( `prod_price_id` varchar(15) NOT NULL DEFAULT '', `prod_id` varchar(15) DEFAULT NULL, … PRIMARY KEY (`prod_price_id`), KEY `prod_id` (`prod_

Re: declare multiple 'Definer'

2010-02-22 Thread Michael Dykman
You don't need multiple definers to have multiple users. Why did you want 2 definers? - michael dykman On Mon, Feb 22, 2010 at 8:45 AM, Steven Staples wrote: > Well... let me finish... LOL  (hit send some how...) > > I want to be able to have 2 different users access to a stored procedure...

Re: declare multiple 'Definer'

2010-02-22 Thread Paul DuBois
The syntax allows a single DEFINER clause. On Feb 22, 2010, at 7:45 AM, Steven Staples wrote: > Well... let me finish... LOL (hit send some how...) > > I want to be able to have 2 different users access to a stored procedure... > > I've tried multiple ways to write it, and none of them seem to

Re: Using symlinks for database creation in mysql

2010-02-22 Thread Johan De Meersman
I don't think using a dot is a good idea - that's the table.field separator. On Fri, Feb 19, 2010 at 12:41 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > > Hi Johan, > > Some time back you have solved my problem of creating symlink as database > was fixed. But now When I am putti

Re: can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

2010-02-22 Thread Tomasz Chmielewski
On 22.02.2010 13:04, Jesper Wisborg Krogh wrote: On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote: When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Abo

RE: declare multiple 'Definer'

2010-02-22 Thread Steven Staples
Well... let me finish... LOL (hit send some how...) I want to be able to have 2 different users access to a stored procedure... I've tried multiple ways to write it, and none of them seem to work. Does anyone here know how to do this? CREATE (definer=`use...@`%`, definer=`sstapl...@`localhost`

declare multiple 'Definer'

2010-02-22 Thread Steven Staples
Good morning! I have been struggleing with creating a store procedure, that will allow 2 users -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

2010-02-22 Thread Jesper Wisborg Krogh
On 22/02/2010, at 9:20 PM, Tomasz Chmielewski wrote: When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Aborted # I use MySQL 5.0.89-0.glibc23 binaries from

can't dump a database with views: "stack smashing detected ***: mysqldump terminated"

2010-02-22 Thread Tomasz Chmielewski
When I try to dump a database which contains views, mysqldump crashes: # mysqldump -u root --opt --password=secret database > dump.sql *** stack smashing detected ***: mysqldump terminated Aborted # I use MySQL 5.0.89-0.glibc23 binaries from MySQL website. Is it a known problem? Are there any s