We had a bit of a scare yesterday when one of our scripts just hung
indefinitely. We nailed it down to a query in the script. When we
executed the query manually, it hung as well. We ended up having
to restart MySQL which for some reason fixed it.
Some background: We're running MySQL 4.0.25.
We had to rebuild the slave on our slave DB. After the raid got rebuilt
replication
broke. We tried to rebuild it from scratch by doing the following:
- RESET MASTER (on master)
- mysqldump -e --master-data --single-transaction --databases db1 db2
dbout
- on the slave: STOP SLAVE, RESET
/en/forcing-recovery.html
Mayuran Yogarajah wrote:
Mayuran Yogarajah wrote:
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name mysqld
got signal 11;
This could be because you hit a bug
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name mysqld got
signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is
Mayuran Yogarajah wrote:
Here is a small portion of the error log:
InnoDB: Error: trying to use a corrupt
InnoDB: table handle. Magic n 13459851911327004931, table name mysqld
got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries
We have MySQL running on a Redhat server (RHEL 3.2). We issued a
service mysql
restart yesterday and for some reason MySQL didn't shut down properly.
The init
script said it gave up waiting and deleted the PID file anyway. Since
we issued a restart,
I suspect a second copy of MySQL got
Does anyone know if there are certified binaries for 4.0.x ? I think
I read somewhere that they will have it for 4.1 and later for 5 only.
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it just me or are there no RPMS for x86 64bit? Does this mean I
am stuck using the 32bit version? This machine has 16gigs of ram
and the 32bit version won't be able to make use of all of it.
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Mayuran Yogarajah wrote:
Is it just me or are there no RPMS for x86 64bit? Does this mean I
am stuck using the 32bit version? This machine has 16gigs of ram
and the 32bit version won't be able to make use of all of it.
thanks,
M
Sorry Ignore this, Intel EM64T rpm works just fine.
M
Does anyone how to interpret the output of 'SHOW INNODB STATUS' ?
It prints quite a bit of stuff but I haven't been able to find any
documentation
explaining what everything means. Specifically:
Total memory allocated 462835256; in additional pool allocated 1385472
Buffer pool size 24576
Free
The following are from the InnoDB configuration page:
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is 2GB
*Warning:* On 32-bit GNU/Linux x86, you must be careful not to set
memory usage too high. |
glibc| may allow the process heap
I am looking for an application that can connect to a mysql db or use
an sql file and create html documents describing tables in a database
and their column types, foreign keys, primary keys etc... Does anyone
know of such an app ?
thanks
--
MySQL General Mailing List
For list archives:
Questions: The number of queries that have been sent to the server.
Is this the number of queries since the mysql installation, or the number
of questions since the last reboot ?
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Yves Goergen wrote:
Hi,
I can vaguely remember there was something like INSERT... on
duplicate key UPDATE... in MySQL, but the documentation search is
almost as useful as I'm used to - it cannot tell me anything about
this. Can you please? How does this work, what's the syntax? Is this
Currently we have one way master to slave replication setup.
The master has 2 innodb data files, the second has now grown
to 50gb+. The slave's innodb data files are less than 2 gigs.
How is this possible? They are both storing the exact same
data. Is there some way to trim the 50gb+ file down ?
Our DB in production currently has 2 innodb data files,
the second one (which is marked autoextend) has now
grown past 26 gigs. We are experiencing weird speed
problems with one of the tables. Even though there are
no rows in this table, performing any kind of select takes
about 2 minutes to
This example is from the manual:
innodb_data_file_path=ibdata1:10M:autoextend:max:500M
My question is, what happens when ibdata1 extends and
hits 500M? If that is the only data file configured, will
MySQL crash ?
thanks,
Mayuran
--
MySQL General Mailing List
For list archives: http
Is there any command I can issue to release ALL locks held by any/all
transactions ? I know that restarting the server does this, but is there
a way to do this without restarting ?
thanks,
Mayuran
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
;
This created inside the 'test' directory:
mytest.frm
Can anyone provide a reason for this.
thanks,
Mayuran
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
;
}
}
hope this helps,
Mayuran.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a perl script which fork()'s many children and each
child is updating a table, and each child is inserting/updating
DIFFERENT rows - I split up the work so that no two children
try to update the same row so that no child has to wait for any
locks to be released. The problem is, I am
When I do a SHOW INNODB STATUS i see a query which is
waiting for a lock to be released, but innodb status
doesnt show the whole query, the end of it got truncated.
it looks something like:
INSERT INTO test(col1, .., col10) VALUES ('9',
and just stops.
is it possible to see the entire query, im
How can I go about getting information about lock information? I looked
at the InnoDB status screen but it doesnt say a whole lot. Im getting
alot of problems with lock wait timeouts. What I want to know is, what
is obtaining the locks, what user is obtaining the locks and with what
This is my table:
mysql desc testing;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| date | date | YES | | NULL| |
+---+--+--+-+-+---+
Here are the values:
I would like to optimize the configuration settings
for this beast of a machine, here are the specs:
Quad Xeon 3ghz (4x2 = 8 cpus), 512 cache
16 gigs ram
running Redhat Enterprise 3.0 AS
All tables are InnoDB.
I read this warning in the MySQL documentation:
*Warning:* On GNU/Linux x86, you must be
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table name is still MyTest
but selects work with mytest ?
--
MySQL General
Paul DuBois wrote:
At 12:22 -0500 12/17/03, Mayuran Yogarajah wrote:
I am using case sensitive table names when I create tables
like :
CREATE TABLE MyTest;
If I want to do a select from this table, I have to do
SELECT * FROM MyTest, not SELECT * FROM mytest.
How can I make it so that the table
The following is a transaction from MySQL:
smysql show tables;
Empty set (0.00 sec)
mysql CREATE TABLE Userlist (
- UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY,
- Status VARCHAR(1) NOT NULL,
- EmailAddress VARCHAR(64) NOT NULL,
- Password VARCHAR(32)
Mayuran Yogarajah wrote:
The following is a transaction from MySQL:
smysql show tables;
Empty set (0.00 sec)
mysql CREATE TABLE Userlist (
- UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY,
- Status VARCHAR(1) NOT NULL,
- EmailAddress VARCHAR(64) NOT NULL
Mayuran Yogarajah wrote:
Mayuran Yogarajah wrote:
The following is a transaction from MySQL:
smysql show tables;
Empty set (0.00 sec)
mysql CREATE TABLE Userlist (
- UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY,
- Status VARCHAR(1) NOT NULL,
- EmailAddress
Diana Soares wrote:
Use PURGE {MASTER|BINARY} LOGS TO 'log_name' instead of RESET
MASTER.
From the manual:
Deletes all the binary logs listed in the log index that are strictly
prior to the specified log or date. The logs also are removed from this
list recorded in the log index file, so that
We are running MySQL 3.23 in production, and have replication
setup in the following manner: There are two machines (m1 and m2).
Replication is setup in a circular way. Both machines are master and
slave, more specifically, m1 is master to m2 and m2 is master to m1.
I checked today and saw that
I did some tests earlier where I inserted 100,000 rows into a
table (table definition below). First, I did it without using
transactions and it took 243 seconds approximately. Then, I
did the same test using transactions, and it took 28 seconds.
I am using MySQL v4. Here is the table
I created a table as follows:
mysql CREATE TABLE test (
- age INT(3),
- CONSTRAINT CHECK (age 0)
- );
Query OK, 0 rows affected (0.00 sec)
I then inserted -1 into the table, which it shouldn't
have let me do.
mysql insert into test values (-1);
Query OK, 1 row affected (0.00 sec)
mysql
How are you starting mysql? as a service? I dont think it keeps a log
file by default.
If you are not starting mysql as a service, start it with the
--log-error=/var/log/mysqld --log-warnings
flags. If you are starting it as a service, add those flags to your
mysql file inside
michael johnson wrote:
Dear All
I want to send a MySQL database to a client by email. Which is the best way
to do it?
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel +44(0)870 922 0247
Fax +44(0)1323 419554
email [EMAIL PROTECTED]
URL
Hi,
I recently upgraded from MySQL v3.23 to MySQL 4, and converted
my tables from MyISAM to InnoDB by using the ALTER TABLE
command. I did this for 16 tables. I know that MyISAM creates
seperate data/index files for each table and InnoDB uses a single file
for data and log. My question is,
This is my current setup, two MySQL servers. One master, the other slave.
Suppose I created a table with one column named 'image', which is of
type BLOB.
Now, if I inserted binary data from an image file (using perl or
something) into
that column on the master, how will replication be handled?
getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amtDateNot NullPrimary Key
operINTNot NullPrimary Key
amountDecimal(3,3)Null---
but when I choose fire it shows
39 matches
Mail list logo
