I am on a CentOS 64 bit and used webmin to rotate MySQL slow query log. Now the thing is although logs are being rotated daily but the new log files being created are empty which means MySQL is unable to write them due to some reason. I have checked using "ls -l" that both permission and owner of files is same but still MySQL is not writing logs. What could be the reason?
View 10 RepliesI am using MySQL 5.0.77 Version rpm on CentOS 5 Red Hat Linux. I want to install micro second slow query log patch on this MySQL S/W version.As I found the slow query micro second patch on percona site i.e. [URL]step by step to install above mentioned patch with rpm based MySQL installation? Do we need MySQL source files to apply patch ?
View 13 Replies View RelatedI have the following mysql query which works great.
Code:
SELECT msg FROM `logs` WHERE ((`host` = 'aaa.bbb.ccc.ddd') OR (`host` = 'aaa.bbb.ccc.ddd')) AND `msg` REGEXP CONVERT( _utf8 'physical addresses' USING latin1 ) COLLATE latin1_swedish_ci
I need to refine this query so that I can query the last # hours using the `datetime` field in the database. I have researched the DATE_SUB function and can query for example the last 1 hour like this:
[Code]....
I want to install mysql query browser in debian
View 1 Replies View RelatedI am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
In ssh_config, I do have ForwardX11 set to yes.
Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
Can query browser be installed in 11.4??
I've tried to use workbench but it's such a big step backwards in that you can't easily edit the output from a "select x,y,z from table" query. I'd have thought that was a pretty basic requirement...
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
Heres the HTML code
<html>
<head>
</head>
<body>
<body bgcolor="#6881bb">
<center>
[Code]....
At the moment when i click the button, no matter what I enter every students marks appear on the screen.
I think, but obviously dont know for sure because if i did i would know how to solve the problem, the code that i need to change is in green.
When i enter this query to mysql:
Code:
return this error:
Code:
when i delete the insert part :
Code:
query is ok:
Code:
1 row in set (0.00 sec)
i have MySQL on my CentOS server and have installed it and got it up and running through the command line.
I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.
Trying to export a Mysql query to a .csv file the query draws from multiple tables, e.g. sales, purchase and currency
Code:
What i'm trying to do is to export both the sales and purchase to a single line where both the currency for the sales and the purchase is specified.
Basically like this:
Code:
Problem here is that i'm stating currency.value twice in the same select and don't know how to define which currency.value applies to sales and which to purchase.
It is under PHP/MySQL
$queryresult = $conn->query("INSERT INTO normalrequests VALUES($finalkey, 1234, 5678, FALSE)");
It is connected to the database successfully but I feel there is something wrong with the statement up there.
i will be quick, im trying to send a mysql query output into an array ie:
Code:
declare -a HD
HD=`echo "USE db; SELECT uid FROM user" | mysql -u $login -p$pwd -h $dbhost -B`
echo ${#HD}
those vars in mysql connection are previously and correctly assigned.
but got an error
script.sh: 2: declare: not found
I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'`
IFS=$'
'
for i in $DATA; do
echo "item = $i"
[Code]....
I am not sure if this is possible. I have IP's stored in a mysql database. When I query the database, it returns the IP. I would like to replace the IP with something else prior to displaying the results. Is it possible even though I have not stored it in the database?
I have the following in a while loop (mysql_fetch_array).
Code:
<td align="left">' . $row[IP] . '</td>
Instead of displaying $row[IP] from the database, I would like it to display something else which I define in the PHP code but based on the IP.
ie. aaa.bbb.ccc.ddd = hostnameABC
So I've got a rather vast database, one of the columns is date in the following format: DD/MM/YY HH:MM:SS. This is starting to cause problems with a php page I'm writing which asks the user for a 'start date'. Would it be better for me to split the date column into date and say time? Or is there a way of using distinct and masking the times.
View 10 Replies View RelatedDoes anyone know where I can get a link to download MySql query browser(windows version)?
I want to query my database on my fedora box in windows to make life easier... I can not seem to find a link to download the query browser though
I need help about the error in my website. I have the following error....
Code:
user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.
how can I rotate the pen when I rotate the screen, and I would like to share this knowledge to other people who may have the same problem I had.
I have a tablet fujitsu-siemens t5010 with installed the wacum packages by default, and the pen was working, but couldn't rotate with xsetwacom command.
In Fedora 10, most guides refer to the wacom device as "stylus" which doesn't work on Fedora 11. I run command " $ xinput list " and I found the line
"PnP Device (FUJ02e5) eraser"id=3[XExtensionKeyboard]
and some lines before there is:
"PnP Device (FUJ02e5)"id=2[XExtensionKeyboard]
^^^^^^ this is the name of the device xsetwacom command needs! ^^^^^^^
I wrote first the line with the eraser cause I suppose that even someone has different wacom model, the eraser will be easy to find by grep command ( $ xinput list | grep -i eraser ), and common in most configures.
now , the edited script I use becomes like this:
#!/bin/sh
if [ $1 == 'normal' ]
then
xrandr -o normal
xsetwacom set "PnP Device (FUJ02e5)" rotate 0
[Code].....
It would be awesome if it chat could happened automatically , simply by rotating the screen, like it happens on Vista. I'll try to find out any solution and update this post if I make it !
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I have a problem with the logrotate of auth.log, it is not working. I tried using 'kill -HUP `cat /var/run/sshd.pid`'. This restarts sshd but does not create a new auth.log. Also tried "/etc/etc/init.d/ssh restart" and "/etc/init.d/ssh reload"
View 3 Replies View RelatedCurrently I have a huge issue with Mysql on a basic Fedora 12 installation (no update strait from dvd). Only a console.
Mono JIT compiler version 2.4.3.1 (tarball Thu Jan 14 10:27:43 UTC 2010) Mysql Server version: 5.1.44 Source distribution
When I what to connect with the mysql database using the 6.2.2 Mysql.Data.dll using the socket (/var/lib/mysql/myqsl.sock) I get the error:
If I connect with localhost it is very slow: Query time(0 logitem(s)): 0.805234 seconds
When I connect to that shame version using the same application from a window machine over a network the result are: Query time(0 logitem(s)): 0.23646 seconds
My AWSTATS is not updating correctly. Upon closer look I noticed that the access_log file is already >300MB. logrotate was not running. Now I have enabled log rotate. However, it's not touching this existing access_log file. Is there a way for me to manually split and rotate this file into 3 100MB files, access_log.1 access_log.2 and access_log.3? I tried running logrotate (logrotate /home/user/httpd/access_log) from console and it's throwing Segmentation fault.
View 9 Replies View RelatedCould someone tell me how to rotate an image on GIMP? Now You can rotate it 90 180 etc but I would like to rotate the image to level the shot.
View 6 Replies View RelatedI've got Ubuntu Server 10.04 on a fairly beefy box (quad-core xeon 2.67ghz, 2gb ram) Standard mysql-server installed, with many databases.Lately, mysql has been extremely slow and almost non-responsive. Server loads are low.Running mtop reveals many, many processes from the user: debian-sys-maint querying the information_schema table with the exact same query, over and over."Select count(*) from tables where engine = 'innodb'"
This is adversely affecting my database server, and thus my websites which rely on mysql. Every search I've done looking for more information about the debian-sys-maint user shows problems where that users was deleted. The user isn't deleted.
I have been trying out in learning with logrotate command and logrotate configuration file )logrotate.conf custom logfile for an process is 'test.log'
Code:
#cat /etc/logrotate.d/test
/var/log/test.log {
rotate 4
[code]....
whenever the log file (test.log) exceeds 100M a new file will be created with the file name as test.'date'.'gz'(new file is created with a current date and in a compressed format of gz) and also with permission mentioned above). I really dont know what is the role of rotate( will this be carried on only for next 4times i mean upto 400MB; (4times*file reaches 100MB)? and also what could be the purpose of postrotate?
how can I rotate logfiles multiple times a day? I notice that the configuration for the logrotate-command is hourly, daily, weekly,.I notice that I can create a cron job where I specify the different times the log rotation need to be done:15 0,8,12,17 * * *But how do I combine these two ?
View 7 Replies View RelatedI could not keep this question from turning into a wall of text so I broke it up into these 4 sections.I have 2 monitors (DELL E228WFP and a DELL 2007FP) hooked up to a EVGA E-GEFORCE 8800GT 600MHZ 512MB 1.8GHZ DDR3 PCI-E Dual DVI-I video card. I would like to have the DELL 2007FP set up to the left of the DELL E228WFP and rotated into "portrait" mode^ with both screens sharing a common bottom edge.
This is ideal for reading PDF documentation or papers on one screen and then working on the second one.Steps Undertaken I installed the NVidia drivers (via sudo apt-get install nvidia-current) rebooted ran nvidia-xconfig then ran nvidia-settings. However, like many people, I could not get nvidia-settings to write to my config file despite having run it with kdesudo. Instead, I opened the file with Kate (using KDESudo) and then used the preview from nvidia-settings and just copy pasted it into the file and saved it like that. if I use TwinView I have both monitors working, but when I try to use krandrtray to rotate one of them, it is shown as one large monitor so I cannot rotate just the one I want rotated.However, if I set them up as separate X windows the second one is black and krandrtray only shows the main monitor. I am at a loss of what to try next.
I manually rotated my catalina.out file, and now the file jumps to 30+Mb and when I try to view it, less tells me it might be a binary file. It sure appears to have binary data in it, about 30meg of it.
I did the rotate via a copy:
copy catalina.out to another file
cat /dev/null > catalina.out
I have tried using echo:
echo "" > catalina.out
...also with the same result.
This application isn't something I can just bounce when necessary. It kind of appears that the original file is still there - sort of. But is it not readable text anymore.
SunOS 5.10
tomcat 5.5.26 (version required by app vendor)
I have a mysql server in guest domU on debian squeeze. when i create test table and do INSERT INTO test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.28 sec)
At other physical server with same configuration Query OK, 1 row affected (0.00 sec)
I try this several time but on physical server max value never get over 0.05sec and on VM lowest value was 0.13sec.
Another tests:
On physical server:
OLTP test statistics:
Threads fairness:
on VM:
OLTP test statistics:
Threads fairness:
performance of disk write speed on VM is much better then on physical server .