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 SLA
/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. It 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 it
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 corrupt
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 star
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]
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 fin
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 unsubscrib
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 b
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 t
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: http://list
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:http://lists.
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
ANSI-S
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 exec
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://lists.mysql.co
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:
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension. The index file has an `.MYI' (
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
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 M
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,
->
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 VARCH
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
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 tha
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
26 matches
Mail list logo