Re: Doubt with stored procedures

2013-04-17 Thread Antonio Fernández Pérez
Hi everybody, Firstly thanks for your reply. I'm using MySQL only in one server (I have only one), without replication and without cluster configuration. I have defined the stored procedure as a normal user, not as a root. And the call is make as a normal user also. Occurs with MySQL 5.1.49 on De

Re: Doubt with stored procedures

2013-04-17 Thread hsv
2013/04/17 14:16 +0200, Antonio Fernández Pérez I have a doubt with stored procedures functionality. Is possible that a stored procedure works with all databases form the server? I have created a stored procedure on dataBaseA and also works with dataBaseB. Is that correct? Independently o

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Reindl Harald
Am 17.04.2013 17:29, schrieb Larry Martell: > On Wed, Apr 17, 2013 at 8:32 AM, Reindl Harald wrote: [root@srv-rhsoft:~]$ cat /etc/tmpfiles.d/mysql.conf d /var/run/mysqld 0755 mysql mysql - >>> >>> Doesn't seem to be anything like that running on MacOS. I googled and >>> didn't find any

Re: Doubt with stored procedures

2013-04-17 Thread Johan De Meersman
- Original Message - > From: "Antonio Fernández Pérez" > Subject: Doubt with stored procedures > > I have a doubt with stored procedures functionality. Is possible that > a stored procedure works with all databases form the server? I have > created a stored procedure on dataBaseA and also

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Kapil Karekar
Not a solution but a workaround for " [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' " explicitly set pid_file= to some existing file path in /usr/local/mysql/bin/mysqld_safe (Line:26) e.g. you could possibly set it to: pid_file=/usr/local/my

RE: Mesaure query speed and InnoDB pool

2013-04-17 Thread Ilya Kazakevich
Hello Rick, >Run your query twice; take the second time. For most queries the first run >brings everything into cache, then the second gives you a repeatable, though >cached, timing. Yes, but I need cache to be > my database size to prevent other pages from pushing out pages for my query, right?

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Larry Martell
On Wed, Apr 17, 2013 at 8:32 AM, Reindl Harald wrote: > > > Am 17.04.2013 15:32, schrieb Larry Martell: >> On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald >> wrote: >>> Am 16.04.2013 18:34, schrieb Larry Martell: I just set up mysql on Mac OS 10.8. Each time after the machine is reboot

RE: Mesaure query speed and InnoDB pool

2013-04-17 Thread Rick James
>Run your query twice; take the second time. One more thing -- avoid the Query cache. That could lead to really bogus timings. > Yes, but I need cache to be > my database size to prevent other pages from > pushing out pages for my query, right? Well, yes and no. If the cache is big enough

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Reindl Harald
Am 17.04.2013 15:32, schrieb Larry Martell: > On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald > wrote: >> Am 16.04.2013 18:34, schrieb Larry Martell: >>> I just set up mysql on Mac OS 10.8. Each time after the machine is >>> rebooted the server fails to start with: >>> >>> 2013-04-13 14:09:54 1

Re: MySQL on Mac OS 10.8

2013-04-17 Thread Larry Martell
On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald wrote: > Am 16.04.2013 18:34, schrieb Larry Martell: >> I just set up mysql on Mac OS 10.8. Each time after the machine is >> rebooted the server fails to start with: >> >> 2013-04-13 14:09:54 1 [ERROR] /usr/local/mysql/bin/mysqld: Can't >> creat

Doubt with stored procedures

2013-04-17 Thread Antonio Fernández Pérez
Hi everybody, I have a doubt with stored procedures functionality. Is possible that a stored procedure works with all databases form the server? I have created a stored procedure on dataBaseA and also works with dataBaseB. Is that correct? Independently of the user privileges defined. Thanks ever