m what you say, it sounds like 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 wi
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 ta
es, in general innodb_file_per_table gives you some more
flexibility, just not as much as with MyISAM. For what it's worth
we've noticed no stability or speed issues with it and Heikki at one
point said he could think of no downside to using it.
Good luck,
Ware
Thanks,
Grant
W
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)
/v
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 c
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 companie
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 desig
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 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 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 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 doe
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, varia
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 w
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 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 114
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 e
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: Cl
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
3
compiler to use for MySQL on an Apple machine?
We 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)
verifying your slave, 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
he command line it
works fine, the records 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 = ibdata1:1500M;ibdata2:1500
and a few revisions of InnoDB newer. 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/orde
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 Op
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:
>>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%
>utilizatio
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%
>utilizatio
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:
>>
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 utili
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 l
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 sta
of OS X Server with the latest version of the
developer tools (XTools) installed.
This improved things somewhat...innodb_buffer_pool_size will now go to 2
GB, but if I try to go beyond I get the same error.
Does anyone have suggestions for pushing innodb_buffer_pool_size beyond
2 GB? We can decrease th
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
>info
ircumstances.
Good luck,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 f
lution or a solution via privileges?
Thanks,
Ware Adams
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
assistance I would 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
--
M
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).
gt;useful they'd be since all of the other parameters are tuned way down.
>(none are over 8MB) InnoDB benchmarks may be useful since it uses the
>buffer to cache records as well as keys.
Have you tried setting innodb_buffer_pool_size to a number over 2GB?
Thanks,
Ware Adams
>
>- Gabr
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 wil
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 PROTEC
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 process
ntly, then
you're havinig paging. In this case you should 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
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 l
go away, but that seems 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]
tter to add RAM,
tune your queries or get faster disks (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]
7;t utilize it because something else is
slowing you down). In this case a faster processor won't help
much...the processor isn't the limiting factor.
This assumes you're doing the benchmarking with nothing else running,
obviously. If MySQL is at 25% but you have other programs run
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
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 i
I think you have some slight errors in your connection line:
Werner van Mook wrote:
>/usr/local/mysql/bin/mysqladmin -u root password
should be:
/usr/local/mysql/bin/mysqladmin -u root --password=
>/usr/local/mysql/bin/mysqladmin -u root -h `hostname` password
>
should be
/usr/local/mysql/
). 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 us
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 yo
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 secti
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
