New answers tagged mysql
This is all fine and dandy, but what about the lag time between having to make the request for memory, mapping it out for what the disk cache has to release? Sure, you may say it's minimal, or not even noticeable, but maybe I care about the 0.0000001 seconds added because of this process. Who are you to decide how my RAM is used? What if I don't want to ...
Mysql doesn't have a kernel module, therefore it runs in user mode. Perhaps what you are seeing is that mysql is using memory-mapped files instead of calling read/write. So, accessing a page of memory causes a read/write without using a syscall. Or, perhaps you called strace without "-f" to follow the child processes?
Gems are usually not installed through portage. To install a Ruby gem, make sure rubygems is merged and then run gem20 install <gem> or gem21 install <gem> depending on your system. Edit: since emerge --search mysql-minimal returns nothing, you know it isn't in the portage tree and can't be installed with emerge. Running gem search mysql2 shows ...
There's a bug "Unable to install mysql-server, apt-get stuck at "Setting up".. Please refer to the above link for solution, and see if it helps you, though it was on a diff version
I am trying to write a python script which shows me the services which are running on my server. Don't do that. That's exactly what a process manager like upstart or systemd is for. Using systemd, a simple unit file for mongo might look something like: [Unit] Description=High-performance, schema-free document-oriented database After=syslog.target ...
I was able to solve using sudo yum install php-mysqlnd. I must have mistyped it when trying to install the first time. Doh! After installing php-mysqlnd run sudo service httpd restart. Apparently a coworker messed with our mysql drivers. Asked if he changed anything that had to do with php or mysql and he told me he didn't. Looked at .bash_history and ...
The mysqldump command returns nothing, which is piped trough gzip and ends in an empty gzip file. See: $ echo -n "" | gzip -9 > test.gz $ stat -c %s test.gz 20 This results in a file with size 20 bytes. So the problem is the mysqldump command. Since it's root's crontab the script runs with root priviledges. sudo is not necessary. Use it without sudo. ...
The environment that cron runs scripts in is very limited. It may not be finding all of the required programs. Capture the environment variables of the shell in which you get a good dump and carry that over to your cron script.
The script run via cron is failing. 20 bytes is the size of an empty MySQL dump.
You can use a mysql table for this,since you are already working in mysql ! A table like this should suffice - create table ( userid varchar(100), useremail varchar(100), int mailsent default 0 ); Your creator job will create (or delete) rows from this table. Your mailer will pull all rows with mailsent set as 0, send mail, and set mailsent ...
Break it down piece by piece. When you try to access, check the apache access/error logs. If apache doesn't log anything, then use tcpdump to confirm if your request is even reaching the server. There is no point digging deep in your configuration if you are not even sure if the network is allowing the request through.
Quick and dirty way: You can put a script on a cron to run every X minutes and restart mongodb if it is not running. The main thing about this simple script below, it relies on the grep response code to determine if it should restart or not. However, you need that second grep in there because the first grep will always return successful, due to the grep ...
Does it run as root? In that case you can do service xxxx start in your script where xxxx is mongodb or apache.
You can use any one of following two approaches. I) Every one hour create a file /tmp/overquotausernew.txt and compare this file with old file /tmp/overquotausernew.txt. If any new users are found in newly created file, then send email to only those users and merge newly created file with /tmp/overquotauser.txt In this way, you will maintain only one file ...
One way could be to use built-in quota tools of *nix systems... as from here. If Soft Limit is 800MB and Hard Limit is 1000MB then user will be emailed when Soft Limit is reached, allowing user to still create files until Hard Limit is reached. :)
First of all I would check that I could reach the web server from a second PC on your LAN. You would probably need an entry in your hosts file to map the domain name you the internal address. This will confirm that the server is bridged correctly and isn't firewalled, and can route to the LAN. I would then check that the server had a default route pointing ...
Top 50 recent answers are included