** I am reposting. **
I am looking for some general rule to determine the innodb_buffer_pool_size and
innodb_log_file_size based on number of innodb tables, transactions, etc.
Setting these values based on how much of the server resources I am allotted is
not adequate.
Thanks
Hello
I am loo
Hello
I am looking to determine the best Innodb Settings for our MySQL Instances.
Specifically, the settings for innodb_buffer_pool_size and
innodb_log_file_size. I have read the manual and understand how they work.
I am looking for additional information that would help me determine their
Thanks - now I am getting emails from the list..
Gabe
-Original Message-
From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]
Sent: Friday, May 27, 2005 2:39 PM
To: Tucker, Gabriel
Subject: Re: No Longer Receiving Emails
You are sending messages without error, it would appear
Hi
I have not received anything from this list for a couple of days. I just tried
to "re-register", and that did not help.
If anyone reads this, please reply to ME so I can determine if the problem is
with my account or with the list.
Thanks
Gabe
<><><><><><><><><><><><><><><><><><><><><>
"T
Just a test - thanks
<><><><><><><><><><><><><><><><><><><><><>
"There are no problems, only solutions."
Gabe Tucker
Bloomberg LP
(609) 750 6668 - P
(646) 268 5681 - F
<><><><><><><><><><><><><><><><><><><><><>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Actually - I have some more details to make this clearer:
We will be using UnixODBC - already installed on a NFS mount, and the MySQL
drivers. So, could we install the MySQL drivers on the NFS Mount?
Thanks again - Gabe
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, May
Hello All
I am about to set up ODBC for MySQL (iODBC) on our UNIX systems. We have many
machines that will need to use this installation. I would like to leverage a
NFS mount that is available to all the machines. We currently leverage the NFS
mount for a MySQL Client.
I am wondering if anyo
Hello All
I have an MySQL instance running that is generating the innodb.status.
files. However, there is no innodb_monitor table in any of the databases. How
is this happening?
Thanks - Gabe
4.0.20-max-log
SunOS 5.8
<><><><><><><><><><><><><><><><><><><><><>
"There are no problems, onl
Anil
Write a script that does a slave status and check if either of the threads are
running. You could
further check for error numbers and descriptions. This is what we do.
Gabe
-Original Message-
From: Anil Doppalapudi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 21, 2004 6:05 A
All - I got my answers. Thanks.
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 10:18 AM
To: Mysql General (E-mail)
Subject: RE: Production instances down - MySQL got signal 11
All
I have discovered that I had a memory problem on this server which caused
All
I have discovered that I had a memory problem on this server which caused the crash.
I reduced the initial memory requirements for Innodb and now it is running.
I am curious why it crashed in the first place. If anyone has insight on this, I
world appreciate hearing it...
Thanks - Gabe
Hi all
I am on Solaris 8 using mysql.4.0.16 standard.
My instances crashed with the following in the .err file:
041103 07:44:16 mysqld started
041103 7:44:17 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint
Hi All
I have databases that are writing binary logs that I back up daily using mysqldump.
I was wondering what is the best way to determine which binary logs have been created
after the mysqldump, in the situation where I might do some restore that will involve
the logs.
Thanks
Gabe
<><><>
Yes
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 3:44 PM
To: [EMAIL PROTECTED]
Subject: Two versions on same server?
Can I run two different versions of MySQL on the same server? I've got a
commercial application for which the vendor
cause when it happened
originally.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 2:49 PM
To: Tucker, Gabriel; 'Mysql General (E-mail)'
Subject: RE: Innodb Message "Lock wait timeout exceeded; Try restarting
tran
Hello All
V4.0.16 on Sun Sparc 5.8
Innodb_lock_wait_timeout = 50.
A application using jboss got this error a few days ago. The SQL being used, AFAIK,
was a simple delete from table where date = {date}.
I am trying to determine why this happened. Searching back in the MySQL lists
archives, I
Hello All
I have been searching the archives and was unable to find an answer.
I need the ability to backup MySQL instances directly to a tape device.
Currently, I run a mysqldump to disk and have legato pick up the file. As I get to
some larger databases, hundred's of gigs, and higher transac
Hi All
I would like to dump certain data remotely from a table.
I am unable to use mysqldump because I do not want to dump the entire table.
The "select into outfile" will not work when the connection is remote.
I saw in the manual that "mysql -e" would do what I want. However, that is not true.
Hi
Your cnf file just needs to have log-bin and unique server-id's. Then use the CHANGE
MASTER TO commands on each. So each will be a slave to the other.
That's a brief summary.
Good luck.
Gabe
-Original Message-
From: Free Grafton - CCB [mailto:[EMAIL PROTECTED]
Sent: Monday, May 24
Hello
I am using MySQL v4.0.18. I am using the mysqldump program to do backups. I was
wondering how, if at all, does mysqldump preserver the auto_increment value?
When using phpmyadmin, there is an option to preserve the auto_increment value and the
resulting file has something like:
Sorry for the second post, I realized that my first post might not be clear...
I want the failover and the switch from "read-only" to "non read-only" to be dynamic,
no downtime.
Thanks
-Original Message-
From: [EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 4:07 PM
To: Mysql General (E
Hello all:
I am trying to setup a multi-master environment that looks like a master-slave. Let
me explain.
My system will have all the clients talk to one server. If that server goes down,
then it will fail to another. I want the setup to be multi-master so that upon
fail-over, the other se
tk_sum' is full
What can I do here?
Thanks - Gabe
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: InnoDB - Foreign Key - Error 150.
"Tucker, Gabriel" <[EMAIL PROTECTED]>
n I do here?
Thanks - Gabe
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: InnoDB - Foreign Key - Error 150.
"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote:
> Marvin
>
> I
: [EMAIL PROTECTED]
Subject: Re: InnoDB - Foreign Key - Error 150.
"Tucker, Gabriel" <[EMAIL PROTECTED]> wrote:
> Marvin
>
> I believe that is the problem with the restore. When I create the =
> archive file using the mysqldump command and options previously listed, =
L PROTECTED]
Sent: Tuesday, May 04, 2004 10:03 AM
To: Tucker, Gabriel
Subject: Re: InnoDB - Foreign Key - Error 150.
Put in your script:
set foreign_key_checks=0;
in the first line.
mysqldump dumps tables in alphabetical order.
Tucker, Gabriel wrote:
> Hello All:
>
> I am having a p
l database on its own port and then run from the
prompt "mysql --port= --socket= -p < archive_file.sql"
Thanks again
Gabe
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 9:59 AM
To: Tucker, Gabriel; Mysql General (E-mail)
Subject: R
Hello All:
I am having a problem with both V4.0.16 and 4.0.18. Let me explain:
I have a database with two InnoDB tables in v4.0.16. I backup up this database every
night using the following command:
mysqldump --allow-keywords --host=$HOST --flush-logs --disable-keys --opt
--port=$1 -
Hi All
I have read through some previous threads on this topic and I was unable to find any
to answer my question...
Can I install MySQL on a NFS mount and use its executables on multiple machines
simultaneously? The data will be NOT be on a NFS mount, just the install.
Thanks
Gabe
*
Yes - the same machine...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 11:03 AM
To: Tucker, Gabriel
Cc: [EMAIL PROTECTED]
Subject: Re: Privileging
Are you running this test from the same machine for both users
Hello
I have a user that is granted all privileges for their database. When they run a
select * on a table in that database, the request fails after about 1000 records.
When I run the same query as root, I have no problems. Consequently, I believe this
is a permissioning problem.
Since I ha
Ok
I think I am a bit confused on how the MAX_ROWS works...
This is the result of SHOW TABLE STATUS \G:
Name: gabe_test
Type: MyISAM
Row_format: Fixed
Rows: 33
Avg_row_length: 5
Data_length: 165
Max_data_length: 327679
Index_length: 1024
Dat
Hello
OS: Unix MySQL:4.0.16
OS: Linux MySQL:4.0.17
I am trying to limit the size of the MyISAM tables in a MySQL database. As far as I
can tell, my only option is using the MAX_ROWS parameter on a table. I am not looking
to do this limit at the OS level.
I wanted to test how the max_rows
33 matches
Mail list logo
