Hi Sebastian,
I did not remove any ibdata files. They are present.
regards
anandkl
On 6/21/07, Sebastian Mendel <[EMAIL PROTECTED]> wrote:
very wisely taken topic "mysql error." ...
Ananda Kumar schrieb:
> [...]
> I cleared some old bin-logs and when i restart mysql using "mysqld_safe"
> [..
very wisely taken topic "mysql error." ...
Ananda Kumar schrieb:
> [...]
> I cleared some old bin-logs and when i restart mysql using "mysqld_safe"
> [...]
> InnoDB: using the same InnoDB data or log files.
> InnoDB: Unable to lock /data/mysql/ibdata1, error: 11
> InnoDB: Check that you do not alr
Hi All,
In my master db, bin-log was not getting generated due to space issue, so i
shut it down using 'mysqladmin shutdown".
I cleared some old bin-logs and when i restart mysql using "mysqld_safe", i
am getting below error. I checked for any other mysqld process, but did not
find any. Please he
http://www.hi5.com/register/kVpo2?inviteId=A_7e7f21c_NcJWKAPvLSm0
VenuGopal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is: mysql> show variables;
Native
./configure --..., ...
\On Saturday 16 June 2007 02:56:02 Andrey Kumykov wrote:
\> Hello,all.
\> There is the function "phpinfo" in the PHP interpreter, which allows to\>
know configure options. Is there analog ability in Mysql?
\The equivalent command for mysql is: mysql> show variables;
Native
./configure --..., ...
Dear All,
I have problem that API node on cluster always auto restart mysql (every
30, 20, 15 or just 5 minutes). I see many error messages at message log
file:
Jun 20 15:27:18 PrivateData1 sshd(pam_unix)[30280]: session opened for
user root by root(uid=0)
Jun 20 15:51:24 PrivateData1 kernel:
Hello,
MySQL Cluster on Windows will not be available in version 5.1.
Older versions of the product used to run on Windows, but the interest
was low and the code has suffered from bit rot as a result.
We are really waiting and seeing for the interest to pick up before
allocating resources to
Login to mysql
Perform this on the table
ALTER TABLE tbl-name MODIFY COLUMN Rating varchar(10);
Then recreate the ODBC link in OpenOffice
Give it a try.
Colleen Beamer <[EMAIL PROTECTED]> wrote:
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level
Hi,
I apologize for posting here, because I only use MySQL at a very basic
level - I wanted to create an Access-like database and found that I
could use Open Office with an ODBC connection to a MySQL database to do
what I wanted.
Up to this point all has been fine. However, I just upgraded to My
Could also be the DISTINCT processing depending on the number of dups
and the fields in the result set that must be sorted to perform the
distinct operation. Normally if there were a lot of dupes I would
suggest a sub-query but that is not a great option for MySQL.
-Original Message-
From
Thanks a bunch for the suggested workaround. This method was exactly
what I was looking for.
Thanks again.
CL
At 01:33 AM 6/20/2007, Ananda Kumar wrote:
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 > binlog_sql.sql.
This will give you all the d
Yes I already did try adding an index on tag, but as you said it didn't work
as its using the primary key from the freetags table for the join , anyway I
will try adding an index on "object_type", and see if that helps ...
Thanks
Kishore Jalleda
http://kjalleda.googlepages.com
On 6/20/07, Brent
I have read some where that MySQL cluster will be available in 5.1 release,
will it?
Is there some progress in this regard?
Thanks
CPK
--
Keep your Environment clean and green.
Have you read the manual, and the user-contributed comments?
http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html
Ananda Kumar wrote:
Also, Flush logs on master is not creating any new bin-logs, any specific
reason. Now we have close to 19GB free space.
regards
anandkl
On 6/20/07, A
At 11:11 PM -0700 6/10/07, Ace wrote:
Hi Experts,
When issuing updates in mysql (in the console window), mysql will tell
you if any rows matched and how many rows were updated (see below). I
know how to get number of rows udpated using mysql_affected_rows(), but is
there any
way to get the numb
Also, Flush logs on master is not creating any new bin-logs, any specific
reason. Now we have close to 19GB free space.
regards
anandkl
On 6/20/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
Hi All,
I tried both
mysql> show master status;
Empty set (0.00 sec)
mysql> show master status\G
Empty
At 12:12 PM -0400 6/12/07, Ofer Inbar wrote:
We run a mysqladmin flush-logs from cron every night. This causes our
server to start a new binary log. However, the slow query log does
not get flushed - our server continues updating the same slow query
log file.
If I run mysql and then issue a "f
I am using mysql client 5.0.27. When the Mysql server is stopped (signal
19) the client calls do not timeout.
I am setting the timeout values using MysqlPP setoptions method, to set
the op_read_timeout value.
I've looked through the bug database and found that this problem was
reported pre
Hello,
To get started, have you tried enabling the slow query log?
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
"The slow query log can be used to find queries that take a long time to
execute and are therefore candidates for optimization."
Jimmy Guerrero
Sr Product Manager
MyS
I hadn't even thought that you might want to monitor the process list. If this is what
you want to do, I suggest innotop: http://innotop.sourceforge.net/ Not only can you
see what queries are running, you can easily run EXPLAIN on them with a single
keystroke (press the 'Q' key to watch the pr
Ben Edwards wrote:
We are having a problem with out mysql database (4.2) and think we may
have indexes missing. What we are trying to do is find out the most
popular queries that run. We know there are not may and that they are
relatively simple.
Does anyone know of a tool that allows us to se
Hi Ben,
If you are running MySQL on one of NIX*.
You can use a script similar to the one I wrote to monitor one of our
DBs
==
#!/bin/ksh
while true
do
/bin/date >> db_access.report
/data/mysql/mysql-standard/reloc/my
Hi All,
I tried both
mysql> show master status;
Empty set (0.00 sec)
mysql> show master status\G
Empty set (0.00 sec)
Can you please let me know what i need to do. Actually, when we loading data
using "LOAD DATA" method, the file system became 100% and the slave stop and
is giving the below err
The problem is probably due to your using both '\G' and ';' to end your
command statement. You can only use one or the other.
Thanks,
Daniel J. Donckers
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 20, 2007 9:23 AM
To: MySQL General
Subject: ma
Ben, there's a slow query log feature that may be just what you're looking
for:
http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html
There's an analysis script that will show you the most popular slow queries,
too, '*mysqldumpslow'.
You can take those queries and use the EXPLAIN feature to
Ananda Kumar wrote:
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
You do not have replication setup.
ERROR:
No query specified
Use \G or ; but not both.
what could be the reason,
We are having a problem with out mysql database (4.2) and think we may
have indexes missing. What we are trying to do is find out the most
popular queries that run. We know there are not may and that they are
relatively simple.
Does anyone know of a tool that allows us to see what queries (i.e.
Hi All,
We have setup replication. Mysql version 5.0.40. On master db, if i execute
the below command it showing
show master status\G;
Empty set (0.01 sec)
ERROR:
No query specified
what could be the reason, and how do i fix it. Please help
regards
anandkl
As Dan mentioned, you're searching on the 'tag' field which has no
index. But since that field is in the table you're joining on, adding
an index on it might not help. You actually searching on the tag_id
in the join field, not the 'tag'.
Add an index on 'object_type' in the freetagged_object
Try to look under the directory
/var/lib/mysql/
You will need to be root or mysql user.
the other option is to use locate and type the file name
locate mysql.sock
If it does not find it try to update the db it uses.
updatedb
On Wednesday 20 June 2007 00:55:15 John Mancuso wrote:
> I would
Hi!
Baron Schwartz wrote:
The situation is more complicated.
I have 2 servers and ring replication between them.
On 1 server there is a process which cashes some data from DB (this
decrease number of queries very match and increase performance).
But sometimes there are some modification of data
32 matches
Mail list logo
