all InnoDB or InnoDB for the
tables with write and MyISAM for the others would work for you.
Good luck,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Apr 26, 2006, at 3:54 AM, Dr. Frank Ullrich wrote:
Duzenbury, Rich wrote:
Hi all,
I've inherited an innodb database that is configured like:
innodb_file_per_table
innodb_data_file_path =
ibdata1:3000M;ibdata2:3000M;ibdata3:3000M;ibdata4:3000M:autoextend
Um, doesn't this allocate 12G that
On Mar 21, 2006, at 1:08 PM, Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in
MySQL is lousy. I read the manual and worked with
innodb_per_file_table. So when I shutdown mysql I should be able to
delete ib_logfile0, ib_logfile1 and ibdata1, because all
could think of no downside to using it.
Good luck,
Ware
Thanks,
Grant
Ware Adams [EMAIL PROTECTED] wrote: On Jan 31, 2006, at
9:54 PM, Grant Giddens wrote:
Since changing these tables, I've noticed some large files in my /
var/lib/mysql directory. This is on my test server and I'm running
On Jan 31, 2006, at 11:01 AM, Adrian Bruce wrote:
Thanks for the reply
yep mysqldump also causes the service to crash.
i have a few innodb tables mixed in amongst the myisam, it seems
that it is the innodb tables that may be causing the problems but i
am not sure why ???
If it's InnoDB
On Jan 31, 2006, at 9:54 PM, Grant Giddens wrote:
Since changing these tables, I've noticed some large files in my /
var/lib/mysql directory. This is on my test server and I'm running
gentoo linux.
The files in this directory look like:
/var/lib/mysql/gentoo1-bin.01 (1 Gig in size)
On Oct 7, 2005, at 11:46 PM, Jasper Bryant-Greene wrote:
Walt Weaver wrote:
Well, forgive me for being a bit skeptical and cynical but this
sounds like
spin to me.
As a 17-year Oracle DBA I have never seen Oracle do anything that can
remotely be called benevolent. Larry Ellison buys
On Sep 14, 2005, at 6:16 PM, Chris Kantarjiev wrote:
I'd like to spread the disk arm load across multiple drives. At
the moment, we mostly use MyISAM tables, but we are also
experimenting with InnoDB.
What's the 'best practice' for doing this? There's no obvious
configuration that lets me
On Jul 25, 2005, at 5:47 AM, Marvin Wright wrote:
You recommend to dump tables before changing then re-import them
back. But
if all databases are in there own tablespace I should need to do
this dump
should I ?
Unfortunately I think that's your only option to create a new table
space.
On Jul 22, 2005, at 6:22 PM, Bruce Dembecki wrote:
So it appears I am having an issue with 4.1.13 which I'm guessing
is a bug... wanted some input before I file it...
Setting up a new machine to take over for an old one, so it's
clean, Operating System and some empty disks... the server
On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote:
I am all most ready to give up on MySQL at this point. I'm still
getting regular table corruption on multiple installs of OS X.
I went as far as reporting it as a bug:
http://bugs.mysql.com/bug.php?id=12066
They seem to want more info but my
On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote:
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote:
Has your mysql crashed or have your restarted the machine without
first shutting down mysql manually? We only saw this error when
mysql was not shut down normally. You can look in your .err
On Jun 24, 2005, at 10:56 AM, Markus Benning wrote:
i have a problem with my replication setup and SET statments.
The SET statments seem to be not logged with the queries.
This is a replication limitation in versions prior to 4.1:
Update statements that refer to user variables (that is,
On Jun 20, 2005, at 5:37 PM, Kevin Burton wrote:
Kevin Burton wrote:
We're noticing a problem where if we were to write to the master
with multiple threads that our slave DB will fall behind.
BTW.. I should clarify.. when I mean break I really meant to say
that the slave replication
On May 25, 2005, at 9:34 AM, David Brewster wrote:
A client of ours has experienced some rather serious hardware
failures resulting in disk errors and therefore corrupted InnoDB
files.
We could not get mysql to restart unless the innodb_force_recovery
was set to 5. In this situation we
On May 25, 2005, at 10:06 AM, David Brewster wrote:
Here is the log dump :-
Thanks
David
050525 13:24:10 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max' socket: '/var/lib/mysql/mysql.sock' port: 3306
050525 13:24:11 InnoDB: Assertion failure in thread
On May 25, 2005, at 5:12 PM, Farid Hamjavar wrote:
Situation:
System XYZ RH AS 2.1
RH mysql client -- mysqlclient9-3.23.22-8
RH php -- php-4.1.2-2.2 php-mysql-4.1.2-2.2
System ABC RH AS 3.0
RH mysql server -- 4.1.10-standard
The mysql client on XYZ can not talk to mysql server on
On May 19, 2005, at 12:51 AM, Dan Rossi wrote:
Hi there, I am having issues with this funny error message. I am
trying to do a sub query and then a group by clause on a date.
However i keep getting this annoying message for some reason.
Happens via terminal aswell as my sql gui. Here is the
On May 13, 2005, at 8:34 PM, Hassan Schroeder wrote:
Ong Khai Chin wrote:
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in C:
\Program Files\Apache Group\Apache2\htdocs\mysqltest.php on line 2
Could not connect:
On Mar 31, 2005, at 1:13 AM, Rafal Kedziorski wrote:
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem).
But under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: Lock
On Mar 18, 2005, at 7:06 AM, Andy Hall wrote:
Hi,
I have tried the following process in order to try and replicate a
database
with InnoDB files:
1. created a new database in PHPMyAdmin
2. via command line, copied all the .frm files from the old database
directory into the new database directory
used gcc 3.3 that comes with the current developer tools/XTools.
Good luck,
Ware Adams
Best Regards,
Boyd E. Hemphill
WEST Project Manager
MySQL Certified Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2278 x 405
M: (512) 470-6146
--
MySQL General Mailing List
For list
, but this might be the cause of
loss of integrity:
http://bugs.mysql.com/bug.php?id=7011
We hit it on 4.0.23. It requires the use of multi table updates on the
master and replicate-*-table options on the slave.
Good luck,
Ware Adams
--
MySQL General Mailing List
For list archives: http
are updated as on the master. However cross
table updates won't run on the slave under replication.
We had to downgrade to 4.0.21.
Good luck,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sep 24, 2004, at 4:03 AM, MaFai wrote:
Dear [EMAIL PROTECTED]:
Here's my setting:
innodb_data_file_path = ibdata1:10M:autoextend
Now the ibdata1 has been grow up to 1.3G
We try to add more ibdata file to store the data by the following
setting.
innodb_data_file_path =
. Performance seems fine as is.
--Ware Adams
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL support from http
Boyd E. Hemphill wrote:
But, some select and replace statements are taking an unusually long
time. These seem to revolve around a couple of tables that are
written to and read from very often.
innodb_data_file_path = ibdata1:15G:autoextend
We are running Gentoo Linux 2.6.4 on a dual AMD
Kieran Kelleher wrote:
Does anyone out there have a suggested innodb parameters or even a
working set of params that I could start with.
The InnoDB manual gives good suggestion. Some minor comments (none
particularly OS X specific, but InnoDB works fine on it)
innodb_buffer_pool_size is very
Kart v wrote:
sort buffer size 2097144
join buffer size 131072
max heap table size 16777216
max join size 4294967295
max sort length 1024
myisam max sort file size 2147483647
myisam sort buffer size 8388608
Upto my understanding mysql runs on a single thread
and is not capable of utilizing both
Kart v wrote:
Also it would be helpful if you could give me some hints on what
system variables to set and what table types to use. After doing the
basic setup, I will play with the queries to optimize them.
Your key buffer looks very small, assuming you are using MyISAM
tables:
key buffer size
Kart v wrote:
If your not using the cpu fully, you definitely need to optimize
mysqld's settings and/or optimize your queries. Even if the cpu is
running full out, optimizing queries to examine fewer rows can help.
Yes Ware, the CPU is not fully utilized. It shows just 10 -15%
utilization. Could
Kart v wrote:
If your not using the cpu fully, you definitely need to optimize
mysqld's settings and/or optimize your queries. Even if the cpu is
running full out, optimizing queries to examine fewer rows can help.
Yes Ware, the CPU is not fully utilized. It shows just 10 -15%
utilization. Could
chueewowee wrote:
[raisinspace:/usr/local/mysql] chueewow% Starting mysqld daemon with
databases from /usr/local/mysql/data
040612 23:32:05 mysqld ended
mysqld isn't starting. See what the error log says, it will likely be
in /usr/local/mysql/data
--Ware
--
MySQL General Mailing List
For
Jonathan Villa wrote:
in /usr/local/mysql/data there is one dir named the same as the db
they are working on, then there is this other file called ibdata1
which is 2.1G in size.I take a look at the first few lines and all
I get is garbled data, as if it were a binary file or something.
Jose Manuel Islas Romero wrote:
I start MySQL and it seems to start the server normally
TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe
Starting mysqld daemon with databases from /usr/local/mysql/data
040512 21:27:05 mysqld ended
It's not starting normally. It's starting
tables are InnoDB. Still, even
with the settings above I would have expected to be able to get InnoDB
to 3 GB if the overall process limit is 4 GB.
Thanks for any help,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Andre MATOS wrote:
Is it possible to set MySQL to save all the changes that can happen,
for example, if some one insert a new record into table X, MySQL save
a log about this task performed and all data that was inserted. I
another person update one field from table Y, MySQL save all the
. Also, InnoDB Hot Backup only
backs up the InnoDB table space and logs. You must also back up your
table definitions and binlogs separately.
This is all described in the InnoDB manual at http://www.innodb.com/
We use both methods as they are helpful under different circumstances.
Good luck,
Ware
No, InnoDB hot backup only backs up the table data, not the definitions.
You need to back those up separately. This is all explained here:
http://www.innodb.com/manual.php#Backing_up_myisam_and_innodb
There's also a perl script that can help you with the backup. Even
though it says MyISAM, you
Tofu Optimist wrote:
When I set up the databases, I recall assigning
a few large fixed-size files to the InnoDB engine for
data (and I think) logs.
I've been adding data to my databases daily and wish
to know how full they are,
Use this command:
show table status from database_name like
Paul Stearns wrote:
As reported under the subject Random Database Slowdowns... on the
win32 list, our database still hangs on an average of 1-2 times per
day.
I can find no error messages or logs associated to the problem. It
affects both IIS ADO connections as well as local connections from
?
Thanks,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
like to
give this a try.
I haven't tried it, but I did come across this the other day:
http://www.pogma.com/blosxom.pl/2003/Aug/17#back
Looks like it requires Fink.
Also, you might try CocoaMySQL which works well:
http://cocoamysql.sourceforge.net/
--Ware Adams
--
MySQL General Mailing List
Chris Nolan wrote:
2GB limit? On MacOS X?
On almost every OS I've played with lately, the file size limit is
massive - as in far beyond what disc capacity today will allow. Does
MacOS X have a 2GB limit?
No, OS X has a file size limit of 2 TB (prior to 10.2), 8 TB (10.2.x) or 16
TB (10.3).
to cache records as well as keys.
Have you tried setting innodb_buffer_pool_size to a number over 2GB?
Thanks,
Ware Adams
- Gabriel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Peer Reiser wrote:
Next week I will have access to a new PomerMac G5 with Dual 2GHZ
processors, and i want to do some indexing. Does anyone know if MySQL
will take advantage of dual processors if the only process running is
the indexing process??
No, it won't directly. However, other processes
Andy Eastham wrote:
How big are the table and index files? Can your OS handle files
bigger than 2/4Gb?
Yes, OS X can deal with files larger than 4 GB.
--Ware
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Jeremy Zawodny wrote:
On Fri, Oct 03, 2003 at 06:23:24PM -0400, Ware Adams wrote:
Peer Reiser wrote:
Next week I will have access to a new PomerMac G5 with Dual 2GHZ
processors, and i want to do some indexing. Does anyone know if
MySQL will take advantage of dual processors if the only process
set up and edit a my.cnf
file to tune the memory parameters of mysqld so it doesn't page.
The details of top can be found by typing 'man top' in the terminal window.
--Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Andy Callan wrote:
When i try to startup the mysqld it works but then I get msqld ended
immediately afterwards, I tried to follow the two posts about that
with the online documentation with no luck. If you need anymore info
just let me know, thanks a lot for your response.
Find the error log
(or all three) in this case.
--Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to be after they log out.
Shouldn't these connections be shut down, or is there some other variable
or option that I need to check.
Thanks,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
have other programs running
heavily it doesn't tell you much, but if it's at 25% and the rest of the
capacity is idle then the CPU isn't the problem.
--Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Chris Nighswonger wrote:
Hi All,
Is it possible in MySQL to use UPDATE to update fields in one table with
data from another table? For example, the following code seems to be the
answer but fails with a syntax error in MySQL:
UPDATE test_demo1.products SET nontaxable=(SELECT IMFSalesTax FROM
Victor Pendleton wrote:
You could create your own script that runs myisamchk then after completing
starts the MySQL service and place this in the windows startup folder.
-Original Message-
From: Luis Lozano [mailto:[EMAIL PROTECTED]
How can i check and repair DBs, before service in
I think you have some slight errors in your connection line:
Werner van Mook wrote:
/usr/local/mysql/bin/mysqladmin -u root password password
should be:
/usr/local/mysql/bin/mysqladmin -u root --password=password
/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
password
should
). Recovery is
quicker as the tables exist in the backup directory in full MyISAM table
form. With mysqldump you need to actually execute the dump files which can
take a while for large tables. mysqlhotcopy does not work with InnoDB.
--Ware Adams
Jake Johnson wrote:
Is this better than using
InnoDB Hot Backup is non-free and works only with InnoDB.
mysqlhotcopy is free and works with MyISAM tables but not InnoDB.
mysqldump is free and works with both.
The easiest thing to do is use mysqldump...you'll get text files that
contain create and insert statements allowing you to restore
Yes there is, that's what Paul was referring to regarding InnoDB...it has a
table space made up of multiple files on the disk and the tables reside
within the tablespace. Thus the tables are not bound by the file system's
maximum file size.
Details are in the MySQL manual in the table types
Hello,
I'm having an odd problem with my MySQL server that I thought someone might
have some ideas on.
Setup:
MySQL 4.0.10-max
Mac OS X Server 10.2.3
DP G4 1.25 GHz
1G RAM
MySQL data and temp files on 400G striped RAID array (off an Acard hardware
controller) that is 90% empty
Clients accessing
60 matches
Mail list logo