Re: Replica questions

That's deprecated too :-) On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote: > hi, >  #2.  try adding the information of master into my.cnf then restart the > server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?un

Re: Query from HPM book to limit rows scanned doesn't appear to work as described

Hi! On Wed, Mar 11, 2009 at 8:20 PM, David M. Karr wrote: > Using 5.0.67-0ubuntu6 on Ubuntu 8.10. > > I'm going through the "High Performance MySQL" book.  I was reading section > 4.4.1.8, titled "MIN() and MAX()".  The point of this is that MySQL doesn't > optimize MIN()/MAX() very well, but it

Re: Replica questions

hi, #2. try adding the information of master into my.cnf then restart the server. thanks 2009/3/12 Bryan Irvine : > I've got 2 questions about my newly set up master->slave replica. > > 1> When I run "load data from master;" I get an error that I do not > have RELOAD privileges and then it b

Re: Replica questions

On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine wrote: > > I've got 2 questions about my newly set up master->slave replica. > > 1> When I run "load data from master;" I get an error that I do not > have RELOAD privileges and then it boots the slave offline. > I've run GRANT SELECT, PROCESS, FILE, S

Query from HPM book to limit rows scanned doesn't appear to work as described

Using 5.0.67-0ubuntu6 on Ubuntu 8.10. I'm going through the "High Performance MySQL" book. I was reading section 4.4.1.8, titled "MIN() and MAX()". The point of this is that MySQL doesn't optimize MIN()/MAX() very well, but it showed a supposed workaround for this. The first sample query w

Replica questions

I've got 2 questions about my newly set up master->slave replica. 1> When I run "load data from master;" I get an error that I do not have RELOAD privileges and then it boots the slave offline. I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT, REPLICATION SLAVE, RELOAD ON *.* TO roo

Re: [PHP] RE: non-auto increment question

Ashley Sheridan wrote: > On Thu, 2009-02-26 at 11:27 -0500, PJ wrote: >> Jerry Schwartz wrote: >> Being rather new to all this, I understood from the MySql manual that the auto_increment is to b e used immediately after an insertion not intermittently. My application is for administr

Re: generic remote command/script for monitoring MySQL instance health

On 3/11/09, Thomas Spahni wrote: > > I am searching for a generic command to monitor that MySQL instance is > > up and running. I don't have any know-how about the schema of the DB. > What about 'mysqladmin ping' ? Hi Thomas thank you. That was the command I searched. kind regards Sven -- M

Re: mysqlimport remote host problem

Thanks. That works great. On 10-Mar-09, at 9:36 PM, Rob Wultsch wrote: On Tue, Mar 10, 2009 at 7:16 PM, René Fournier wrote: OK, I've managed to do the same thing with just the mysql command line program: mysql -h 192.168.0.224 -u root -p alba2 < /Backup/Latest/alba2_2009-03-10_0

Question about LVM snapshots and innodb tables

The book “High Performance MySQL” states the following about using LVM snapshots with innodb tables: “All innodb files (InnoDB tablespace files and InnoDB transaction logs) must be on a single logical volume (partition).” Here is portion of a df command performed on one of our hosts: /dev/mapp

Re: generic remote command/script for monitoring MySQL instance health

On Mon, 9 Mar 2009, Sven wrote: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor Hi What about 'mysqladmin ping' ? Regards, Thomas Spahni -- MySQL General Mailing

MySQL Installation Not Working

Hi, I've tried several times now to get a local installation of MySQL going on my iMac (w/ OS X ver. 10.5.6). I've carefully tried everything I could comprehend to do per the mysql.com resource pages/ manual. I have also tried several procedures I discovered via Google searches that see

Linking mysqlclient to a windows program

Hello I have configured my VC++ to link my programs with mysqlclient, but now am trying a program with Qt that is compiled using "make" from the command line, is it enough to add "mysqlclient.lib" to my makefile library configuration? I mean, is it enough to add the path to the header files and my

Re: using a subquery/self-join to recursively retrieve a tree

as you say you need recursion to build the tree from the table. if you are interested just in all the employees that are not manager with their manager info. select * from emp e1 inner join emp e2 on e1.uidman=e2.uid; cheers Claudio 2009/3/10 Ali, Saqib > Hello, > > I have following simp

Re: BSD/OS and 5.1

Hi Dave, There is not enough information here to know if your test is failing or your compile is bad. Did the compile complete without errors? What version of BSD/OS are you using there are many versions and varieties. Most of them have a package system with per-built binaries, I would re

Re: mysqlimport remote host problem

zcat /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql.gz | mysql -h 192.168.0.224 -u root -p alba2 Cheers Claudio 2009/3/11 Rob Wultsch > On Tue, Mar 10, 2009 at 7:16 PM, René Fournier > wrote: > > > OK, I've managed to do the same thing with just the mysql command line > > program: > > >

Re: Securing MySQL on Mac OSX

It mentions that root in MySQL has nothing to do with the root of Mac OSX, but I need to know if MySQL being unprotected in this way has opened a door for hackers. it means that they can do whatever they want to the mysql db's without being prompted for a password. This does not mean th

Securing MySQL on Mac OSX

I am in the process of installing MySQL and PHP on my Mac following instruction in a book written by a chap called David Powers. I have come to a section that is called 'Securing MySQL on Mac OSX'. Basically it states that MySQL is up and running with a default account of 'root' and it's no