MySQL 5.1: Views, queries, updates and performance issues

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 5.1: Views, queries, updates and performance issues

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

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

[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 tell you

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

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 the

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

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.

Re: mysql_secure_installation

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

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

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,

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

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

Re: mysql_secure_installation

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 too

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

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