Re: error 13

2012-10-16 Thread Lixun Peng
he same host as the mysql server? if not, google >> the docs for 'local infile' >> > > yes. my laptop. > > > > > >> On 2012-10-16 10:45 PM, "Lixun Peng" wrote: >> >> Hi, >> >> What's the dir permissions? >> &

Re: Error message I am getting today. All help appreciated.

2012-10-16 Thread Lixun Peng
Hi, What query is running? Is web server and DB server in the same server? Have something in error.log of MySQL? On Wed, Oct 17, 2012 at 10:32 AM, ad...@canadianinvestors.com < ad...@canadianinvestors.com> wrote: > Hi, > > I run www.canadianinvestors.com and am getting this error message. > > Wa

Re: error 13

2012-10-16 Thread Lixun Peng
Hi, What's the dir permissions? For example, if we have a file in /a/b/file, dir a is 644, even though file is 777, we can't access file, too. On Wed, Oct 17, 2012 at 10:31 AM, kalin wrote: > > > hi all.. > > this hasn't happened before... > > i'm in as root on the command line cleint. trying

Re: Can I measure the use of index?

2012-10-15 Thread Lixun Peng
Hi, If you are using Percona Server, you can use this query: SELECT DISTINCT s.table_schema, s.table_name, s.index_name FROM information_schema.statistics `s` LEFT JOIN information_schema.index_statistics indxs ON ( s.table_schema = indxs.table_sc