Re: MySQL 5.1: Views, queries, updates and performance issues

2011-12-29 Thread Arthur Fuller
At first blush, your problem would appear to concern the lack of index-use. That's where I would begin my investigation. It might be painstaking, but I would do something like this: For each view Look at the Join(s) and see what columns are being joined Look at the tables and see what col

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Reindl Harald
Am 29.12.2011 19:21, schrieb Govinda: > Just a side note, that: > > Govind% which mysqldump > mysqldump: Command not found. > Govind% which /usr/local/mysql/bin/mysqldump > /usr/local/mysql/bin/mysqldump > > kind of defeats the purpose of having to know the path in advance in order > to use th

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Govinda
> [snip] > that is because Mac OSX is missing a package-managment and so you need > a little knowledge about your OS to fix the PATH or you have to use > full-qualified calls or configure/install your software to locations > which are already in the path > > "which mysqldump" as normal user wil t

Re: mysql_secure_installation

2011-12-29 Thread Reindl Harald
Am 29.12.2011 18:42, schrieb Ryan Dewhurst: > I would assume that MySQL is installed mostly on production servers > rather than in class room environments. > > Wouldn't it make more sense for MySQL to be secure by default rather > than insecure by default? yes and no yes because there are way

MySQL 5.1: Views, queries, updates and performance issues

2011-12-29 Thread Bruce Ferrell
Hi all, I've got some semi-general questions on the topics in the title. What I'm looking for is more in the line of theory than query specifics. I am but a poor peasant boy. What I have is an application that makes heavy use of views. If I understand views correctly (and I may not), views

Re: mysql_secure_installation

2011-12-29 Thread Ryan Dewhurst
Hi Shawn, I would assume that MySQL is installed mostly on production servers rather than in class room environments. Wouldn't it make more sense for MySQL to be secure by default rather than insecure by default? It would make more sense to me if there was a 'mysql_insecure_installation' script

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Reindl Harald
Am 29.12.2011 18:15, schrieb Govinda: > ...when I try this: > mysqldump -uroot -p myDBname myTableName > myTestDumpedTable.sql > > ..then I keep getting this: > myTestDumpedTable.sql: Permission denied. your unix-user has no write permissions to myTestDumpedTable.sql this has nothing to do wirh

Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Andy Wallace
I would suggest trying: mysqldump -uroot -p myDBname myTableName > /tmp/myTestDumpedTable.sql Maybe you don't have permission (or space) to write into /usr/local/mysql/bin. That would be an unusual place for such files. On 12/29/11 9:15 AM, Govinda wrote: Hi Everyone This should be quick an

why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2011-12-29 Thread Govinda
Hi Everyone This should be quick and simple, but after researching on Google quite a bit I am still stumped. I am mostly newbie with: server admin, CLI, MySQL. I am developing my PHP site locally, and now need to move some new MySQL tables from my local dev setup to the remote testing site. Fir

puzzled issue for deadlock due to locking upgrade from LOCK_S to LOCK_X

2011-12-29 Thread hiu
Hi Guys, I got a deadlock problem, and it puzzled me days. Hope some body could help with some explanation for the reason of deadlock, better if some extra advises. * * *DeadLock Info:* * * - - - (1) TRANSACTION: TRANSACTION 13D947E32, ACTIVE 0 sec, process no 10928, OS