for logging error 13. turning logging off Pep Texas

Address Lubbock, TX 79464
Phone (806) 252-7161
Website Link

for logging error 13. turning logging off Pep, Texas

And I look the user with ps -ax and it's mysql so it's right –ReynierPM Nov 5 '15 at 18:56 2 From your update, service is running as correct mysql Any better way to determine source of light by analyzing the electromagnectic spectrum of the light Risk Management in Single engined piston aircraft flight Can Communism become a stable economic strategy? share|improve this answer answered Nov 8 '13 at 21:17 trinth 1514 add a comment| up vote 2 down vote This is not an unusual problem when services write to /var/log. MySQL takes it from {datadir} directory ------------------------------------------------------ MYSQL: protocol_version 10 version 5.0.27-log version_bdb Sleepycat Software: Berkeley DB 4.1.24: (October 21, 2006) version_comment Source distribution version_compile_machine i686 version_compile_os redhat-linux-gnu ------------------------------------------------------ Aug 31

Block for plotting a function using different parameters Why is absolute zero unattainable? It seems like a nice and clean solution for enabling/disabling query log dynamically on MySQL 5.0 However I'm having the following error: Error 13. Hot Network Questions In the United States is racial, ethnic, or national preference an acceptable hiring practice for departments or companies in some situations? Suggested fix: The slow_query_log (or general_log) is set to 0 when the FLUSH fails and disable the logging. [29 Sep 2014 22:08] Jean Weisbuch ps: the error on the error log

Update Here are the permissions for /var/log and /var/log/mysql: # ls -lhd /var/log/ drwx------ 12 root root 4.0K Nov 4 20:52 /var/log/ # ls -lhd /var/log/mysql drwxr-xr-x 2 mysql root 4.0K PS. /var/log/ [[email protected] log]# ls -l total 1192 -rw-r----- 1 root root 1037 Feb 9 22:52 acpid -rw------- 1 root root 15041 Feb 9 18:50 anaconda.log -rw------- 1 root root 23671 Browse other questions tagged mysql optimization slow-log or ask your own question. Already fixed it in the ISO.

I already had slow-queries-log turned on and it was in the [mysqld_safe] section; so I thought the log option should also go there, but it did not work out. Problem with executing MySQL queries through PHP. Turning logging off for the whole duration of the MySQL server process. The path to the slow query log was incorrect, it should have been /var/log/my.slow.log instead of /var/log*s*/my.slow.log .

Which are the right permissions on this case? The RPMs come right from upstream that way. How to handle a senior developer diva who seems unaware that his skills are obsolete? Turning logging off for the whole duration of the MySQL server process.

touch /var/log/mysql.log; chmod 640 /var/log/mysql.log; chown mysql.mysql /var/log/mysql.log The problem was that selinux was configured and running in enforcing mode.  I set SELINUX=disabled in /etc/selinux/config and rebooted the server. The server quit without updating PID file Ubuntu apt-get upgrade - The following packages have been kept back Update WordPress Amazon Product in a Post Plugin 2.X to Amazon Product in Why are Spanish adverbs formed using the feminine? Thanks, Umesh [30 Sep 2014 12:01] Umesh Umesh // [[email protected] mysql-5.5.41]$ uname -an Linux cluster-repo 2.6.32-100.28.5.el6.x86_64 #1 SMP Wed Feb 2 18:40:23 EST 2011 x86_64 x86_64 x86_64 GNU/Linux mysql> show variables

MySQL Performance Statistics mysql in a startup/shutdown loop at 30 sec intervals Copying a MySQL row to another table MySQL ODBC 3.51 driver Very Slow! mysql logging best-practices query share|improve this question edited Jun 10 '11 at 12:54 Caleb 8,58422540 asked Jun 10 '11 at 5:01 comb 8815 I like the "sysadmin's wisdom" style Reply peter says: September 14, 2007 at 3:52 am Thanks Keith, Indeed query sniffer is another good way to approach the same problem. To turn it on again: fix the cause, shutdown the MySQL server and restart it.

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?). This is because every single query will be logged, and you don't want ordinary users to view the log file because queries may contain sensitive information, such as logins and passwords. share|improve this answer answered Jun 10 '11 at 13:12 Kyle Smith 7,6751730 add a comment| up vote 1 down vote You can also use the create option of logrotate to create Reply Leave a Reply Cancel reply

Subscribe Want to get weekly updates listing the latest blog posts?

A Shadowy Encounter Truth in numbers Security Patch SUPEE-8788 - Possible Problems? Any advice would be appreciated, thanks much! Another Edit: After taking @RolandoMySQLDBA 's advice and moving my slow query config lines to under [mysqld] my settings seem to be saving. You can also use this file to specify (e.g log=/var/lib/mysql/mysql/general_log.csv) share|improve this answer answered Aug 11 '14 at 3:08 Khanh Hoang 1 add a comment| up vote 0 down vote One

I'm wondering if this process may overwrite any changes we would make. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Here is what I have in my.cnf: slow-query-log=1 slow-query-log-file=/var/logs/my.slow.log long_query_time=1 the file /var/logs/my.slow.log has mysql as the owner, also in the interest of debugging I gave read/write to all on the MySQL tips that I have come across Real-time compression for mysql udf_lzo Browse more MySQL Database Questions on Bytes Question stats viewed: 9348 replies: 2 date asked: Aug 31 '07 Follow

Are independent variables really independent? share|improve this answer answered Jan 18 '12 at 15:18 Tim 2,323813 If I can remember correctly that is the problem - mysql needs read access to the directory housing Aside from the space requirements, I don't know of any advantage of one over the other. Is intelligence the "natural" product of evolution?

It could be there is no access to the directory where this file is located or some higher level directory. Show Tony Lewis added a comment - 19/Mar/14 3:19 PM Derek We have a mysql-init-fixer RPM that fixes the startup issue with MySQl. Browse other questions tagged centos logs mysql mariadb or ask your own question. Not the answer you're looking for?

It still gives me that error 13 (permission denied) Reply peter says: September 3, 2010 at 5:04 pm Hi, Check out permission for directories as well. The copy/truncate method will copy the current log files (mysqld.slow.log) to a new file (mysqld.slow.log.1) then truncate the original file to zero bytes. So you really only want to be logging MySQL queries when you are doing debugging, as the file will quickly become very large on a production server. This can be easily fixed by changing ownership to mysql instead of root.

I have tried setting up permissions on /var/log/mysql recursive (-R) as mysql:root, mysql:mysql and root:root none of them works and I got the same messages all the time. Browse other questions tagged mysql or ask your own question. Subscribe to our blog Polls Top Database Infrastructure Concerns Highly Scalable Data Infrastructure Performance and tuning Database Monitoring Staffing Security Keeping up with updates and new bugs View Results Loading ...