ppropriate rc.x directory. Once you've done that,
the machine will boot and maybe you can find something in the mysql
error log. If you don't see anything there, adding strace to the mysql
startup script might give some more info which would be helpful in
solving your problem.
wal
is a /usr/local/include/sql.h file on that system. I don't know
how it got there. By looking inside the file it appears to be related
to MyODBC 3.5.11.
Just for kicks I copied this file to the second system, but got the same
error when trying to run ./configure.
Any ideas?
-Ryan
Ryan,
Walt Weaver wrote:
Hi,
I have a job runnning that's modifying a column on a 15-million-row table
and is throwing out the following error:
Output: Replication Error 1114, slave: replicatenj07, error: Error 'The
table '#sql-5303_3c' is full' on query. Default database
&
'BLA;'
mysql> quit
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar FOO -p
mysql> show tables;
Empty set (0.00 sec)
mysql> use BLA;
ERROR 1044 (42000): Access denied for user 'bar'@'localhost' to database
'BLA;'
mysql> quit
[EMAIL PROTECTED] 5.0.15-0-es4]# mysql -u bar BLA -p
mysql> show tables;
Empty set (0.00 sec)
mysql>
Thanks !
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
host, $alert_port, $alert_user, $alert_passw
ord);
UpdateAlertCache($db);
?>
Jacob,
Have you turned on the slow query log ?
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html
Once you have logged slow queries, than you can run explain on them and
possible tune your indexes better.
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
iptables on the db servers to get around the security updates
> Thank you for your time,
>
> Andrew
>
> On Tue, 2003-12-02 at 17:10, John Griffin wrote:
> > Hi Andrew,
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.c
are you going to connect to a database that's not running? Try su -
mysql and then `chmod 755 /var/lib/mysql`. Then try to start mysql again
as the "OS" root user.
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
; Joshua Thomas
> Network Operations Engineer
> PowerOne Media, Inc.
> tel: 518-687-6143
> [EMAIL PROTECTED]
>
> ---
> In theory there is no difference between theory and practice. In practice
> there is.
> - Yogi Berra
> ---
Joshua,
The key buffer is not used for innodb
Xavier Fernández i Marín wrote:
>
> Hi,
>
> I've been inserting a csv file of about 150Mb into a mysql database. The
> problem is that there is no enough free space on the hard disk, and the
> process have been collapsed.
>
> Now I've been trying to access to the database to drop the table and c
n the tables since mysql has crashed.
walt
Birju Shah wrote:
>
> Hello,
>
> Thankyou for your quick response.
> When I start getting this error, the mysql crashes, any application which I
> try to start which uses mysql backend, says mysql.sock error could not
> connect .
e 1045 error, it does not look like you typed everything
correctly. What is the "-number" supposed to be?
walt
On Wednesday 14 January 2004 05:03 am, you wrote:
> Hello Walt,
>
> I did and it says the following
>
> > mysql -u websquash -number
>
> ERROR 1045: Access de
server is
running, su to the mysql user and you should be able to log in to the
database using "mysql".
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Pete,
I was just glancing at this and it looks like you have about 13.5GB of
memory allocated on a 8GB machine (4096+4096+512+4096+1024).
Are you swapping badly??
walt
"Lancashire, Pete" wrote:
>
> I'm doing some tests on a small Sun server, a 280R to demo
> MySQL vs
ion2);
>>
>> As:
>>
>> (SELECT FROM table WHERE condition1) UNION (SELECT FROM table WHERE
>> condition2);
walt
Bill Marrs wrote:
>
> I've noticed that If I use an OR in my query, mysql seems to choose not to
> use my indexes. Though, it would seem to h
Ross,
rpm -qlp package_name.rpm will list all the files in an rpm for you. You
may
need to install the client rpm as well.
walt
Ross O wrote:
>
> I was able to successfully install MySQL server 4
> under windows, but am a little confused about doing it
> through linux.
>
>
I need a little advice on where to get started. I want to create a db and simple form
that will populate the db. Which language is best? What should I read to help me
along?
tia Walt
that could up date the db woul dbe
nice. The big question is where to begin, which language to use for a simple form and
how to hook the form to the db.
tia Walt
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Walt" <[EMAIL PROTECTED]>;
Those were my exact thoughts being a former cne and msce. I know how to write the
code whatever form I want, web based or standalone, I can also create the necessary
db in mySql but how do they get hooked up?
Walt
- Original Message -
From: "Donny Simonton" <[EMAIL P
ff
>atime on mounting the disks - is it really not used by the database
>anywhere? what kind of performance boost does it give?
>
> Regards,
>
> Andy
>
> --
> Andy Stubbs, B.A., Ph.D.
> Network Manager, Active Hotels Ltd.
> +44 1223 578106
>
Andy,
A
gt;
> > sql, query
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> --
> MySQL General Mailing List
> For list archives:
Anthony,
Try adding this to the my.cnf file
set-variable =sort_buffer=30M
walt
arobins wrote:
>
> I would like to change the sort_buffer variable but
> that variable doesn't seem to be configurable.
>
> i.e.
>
> I get the following when doing mysql --help.
> Do
, and a hot backup tool for MySQL
> Order MySQL technical support from https://order.mysql.com/
That is great news! Will a single table be able to span several
datafiles?
Thanks!
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
export instead of whole
database export. If you still have files that are too large to easily
edit, use a utility like split to break them up. Below is the script we
use to backup all of our tables except for 100_PATS and 400_PATS as
those tables are dropped and reloaded everynight anyway.
Hope this
on on the other computer.
Jonathan,
Have you tried running myisamchk on the database in question before
running queries on it?
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
no problems. I even tried logging in as root
> before starting the mysql client, still made no difference.
>
> Thanks in advance..
>
> Jeff
Jeff,
You probably need to create the database first.
"create database sampdb"
then do the "grant all"
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 04 August 2003 02:10 pm, Richard Gabriel wrote:
> I have been getting this type of error ever since I upgraded from MySQL 3
> to 4. I actually have set up a cron to check/repair tables hourly because
> of this. The following diagnoses have been suggested, but I would bet it's
> an obscu
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jean,
Have you tried adding
[mysqladmin]
user=root
password=blabla
to the .my.cnf file for the user running the script?
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
> On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
> > On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
> > > Andy,
> > > I don't see
> > > "log-slave-updates"
> > >
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
> > Andy,
> > I just noticed that you have
> > a mix of port numbers. Can you try
> > `netstat -an | grep 3306`
> > from the command line and see if the master is indeed listening on that
> > port?
>
> $ netstat -an | grep 3306
> tcp0
On Tuesday 05 August 2003 08:58 am, Jonathan Patton wrote:
> Walt,
>
> Thanks for the suggestion. I ran myisamchk on the table and it said it was
> corrupted. So I ran myismachk on the table with the -r and it said the
> table was fixed. I then ran the update queries I was run
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
> > There is one more thing I can think of to check...
> > Can you send me a copy of the
> > "master.info" file. I've had to manually change it before after changing
> > the master in the my.cnf file. I found out later that you could do
> > "C
On Tuesday 05 August 2003 09:06 am, Richard Gabriel wrote:
> My database experiences a similar effect, but I can't pinpoint the specific
> queries because it gets thousands per second. I have not noticed the
> problem on a machine that is only used occasionally. Is there a way to get
> queries ou
Fabio Bernardo wrote:
>
> Hi there,
> Do you know a sql command which I can write to obtain the last date that I
> updated a table
Fabio,
mysql> SHOW TABLE STATUS LIKE 'table_name'
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
440 2213
> Ph: 021 980 4969
Tom,
I'd use a perl script. You could either write it where it runs in a
continuous loop checking every X seconds or use the cron daemon to
launch the script. The advantage to using the cron daemon is that daemon
will email you if something goes wrong in your s
es out to a text file and then use a perl
script to look for "insert into table_name" or "update table_name" and keep
reading lines until you hit a ";".
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We've run into a problem where binary char column types crash our c++
application when migrating from RedHat 7.3 to RedHat ES. Is there a way to
specify the data type to be returned in the select statement. In the below
example, selecting office_id will crash the app if it's left as a binary
co
I'd bump up these two settings.
innodb_buffer_pool_size=32M
innodb_additional_mem_pool_size=16M
I'm not sure what the max is on innodb_buffer_pool_size,
but that is where innodb caches data. The more that is in cache
means less disk reads which equals speed.
walt
K Old wrote:
Does anyone know if it is better to have 1 large innodb datafile on a disk or
if it is better to have a few smaller datafiles?
Here is what I have. Both drives are 15K scsi running at full 160MB/S speed.
/var/lib/mysql/ - contains all myisam tables as well as a 1GB innodb
datafile.
/mysql2 -
ever, I'm seeking suggestions in fine tuning the
> parameters.
>
> The machine is a Dell PowerEdge 4400 with 2 Xeon 1G processors and 2GB of memory.
> There are 4 disks running raid 0+1. Attached the my.cnf for your easy review. Thanks
> a lot in advance.
>
Rainer,
The "
s.mysql.com/[EMAIL PROTECTED]
Priyanka,
This might work for you - http://otl.sourceforge.net/home.htm
walt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I used to program with VB using MS access as the db. VB was very quick to develope
nice looking forms. Which language would be the best to use with mysql to create
similiar forms. These forms would be for scrolling through the db, adding, updating,
deleteing, printing...
Walt
I am new to mysql and started a tutorial for it and php. Mysql is running ok on my
redhat server. I thought VB might be to unstable. VB is easy to use but I think its
not web based. Also all the job adds I see want mysql and php.
thanks for responding
Walt
- Original Message -
From
I've run into an interesting problem. I have a large innodb table (2274962
rows, 46 columns, 2 datafiles - 4.5GB total).
When I run a query that uses a clustered_index in the where clause and the
data I'm selecting is not the primary key of the table, it takes up to 2 1/2
minutes to return zer
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Jeff,
I'm not sure if this will help or not, but we ended up adding our own version of
quote to
perl cgis. Someone told me when I ask a similar question to check the val
? Try: http://lists.mysql.com/php/unsubscribe.php
Rick,
Are the addresses appearing in the correct format (http://www.somewhere.com) when
you pull them from the db?
If so, you'll still have to build the part in the html so it is
infact a hyperlink.
walt
--
IL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Vaso,
What version of mysql and what OS?
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I ran into a problem a few weeks ago with a query that would take up to 2
minutes to return 0 rows found when selecting anything other than the primary
key (0 rows is correct). When I selected just the primary_key, the query
would take less than 3 seconds. The 2 columns involved in the where par
ted 40 miles away before moving the
logs. Since you are not keeping
the logs around, you may want to change the mv command to rm.
Hope this helps!
walt
#!/bin/bash
#achive_logs.sh
#
# Purpose - Archvive mysql log if size >= 5MB
# Log files are in master_server_name-bin.xxx format.
# Main sc
using the file system and storing
the
path in the database. One of the best arguments I've seen for doing it this way
is the
fact that the application getting data from the db can get the path and then
spawn a "child"
process to fet
nual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.
Paul DuBois wrote:
> At 10:34 -0500 3/13/03, Keith C. Ivey wrote:
> >I am curious why a DATE takes 3 bytes and a TIME takes 3 bytes, but a
> >DATETIME takes 8 bytes, even though TIME covers a much greater range
> >than the time part of a DATETIME, but that's just one of the
> >mysteries of MySQL t
<[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.phpI
I'm not sure I understand your email. Are you able to connect to the master?
If so, the only Privileges you should have are replication unless ot
this
on the master
GRANT SOME_PRIVILEGE ON database_name to [EMAIL PROTECTED]
or
GRANT ALL PRIVILEGES ON database_name to [EMAIL PROTECTED]
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the
the result
to the client. It's a very simple concept and has worked well. We wrote it to
get around Oracle
licensing (only one user connected to the db, but we could handle requests from
multiple
web servers).
Hope this helps!
walt
--
: http://lists.mysql.com/php/unsubscribe.php
Matthias,
I'm not sure on BSD (never used it) but with Linux if your processor
load is high and load
avg is low, you are not suffering from an I/O bottleneck. If your load
avg
was high and cpu was low, then you have lots o
Smurf wrote:
>
> >Description:
> "select distinct FOO from BAR" reports multiple NULL rows
> >How-To-Repeat:
> Unknown. It's a large table (1 entries or so). The problem
> didn't show with a simple test table.
>
> The table:
>
> -- MySQL dump 10.0
> --
> -- Ho
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Philipp,
Did you check /proc/sys/kernel/threads-max? I know with oracle 8i, you
are supposed to increase /proc/sys/kernel/shmmax as well as some other
values. You might check into that and see if changing those values will
h
TECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sherif,
What version of RH and what version of mysql? Does the mysql error log
show anything?
Does the syslog show anything strange?
walt
--
On Wednesday 19 March 2003 12:38 pm, Dan Nelson wrote:
> In the last episode (Mar 19), Philipp said:
> > i just talked about openmosix because i read about shared memory
> > segments. my only desire is to make mysql able to spawn 1000-1500
> > connections and *not* to tell my client "cant create ne
We store
stuff by date so we know to pull 1998 images from fileserver a and 1999
images from fileserver b, etc... The OS on each fileserver can then
cache what is requested most often.
Good luck!
walt
-
Before posting, please check
C++ is
development time and debugging code. Java is great because it's fast and
you don't have to deal with pointers.
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Does anyone have an idea why it would take over 16 hours to drop an index on
an innodb table. The table has/had about 1.7 million records. I used the sql
query
"alter table table_name drop index index_name". I issued the command before I
left work yesterday and it was still running this morning
Brad Teale wrote:
> We are warehousing real-time data. The data is received at up to T1 speeds,
> and is broken up and stored into the database in approximately 25 different
> tables. Currently MySQL is doing terrific, we are using MyISAM tables and
> are storing 24 hours worth of data but we d
On Friday 17 May 2002 12:58 pm, Brad Teale wrote:
> I forgot to mention, we have Oracle in-house, and the machine the MySQL
> database will reside on is a 2 proc Sun box with 1.5G of RAM. The Oracle
> databases reside on a 16 proc Sun box with 10G of RAM.
How are your apps written? We use OTL
Does anyone know where rollbacks are stored for innodb tables?
I assume memory since I keep getting a table full error when trying to drop an
index.
sql,query
Thanks for your help!
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
try using "which" instead of "whereis"
"Simon K. Chan" wrote:
> Gelu,
>
> Thanks for taking the time to respond. I did this:
>
> whereis mysqld
>
> and get this:
>
> mysqld:
>
> which is really weird, because mysqld is located in /usr/local/mysql/bin
>
> I would appreciate any advice you can off
Webmaster wrote:
> Here's my dilema. Our website runs a quarterly prize giveaway. Currently
> we have an ASP form that gathers the inputed info into a database and
> then sends us an e-mail confirmation of the entry. Our rules
> specifically state that only one entry is allowed per quarter. As I
On Tuesday 21 May 2002 12:24 am, Jeremy Zawodny wrote:
> On Mon, May 20, 2002 at 12:25:26PM -0400, walt wrote:
> > Does anyone know where rollbacks are stored for innodb tables? I
> > assume memory since I keep getting a table full error when trying to
> > drop an index.
"Williamson, David" wrote:
> Hi there,
>
> My Ibdatafile is set too big (the disk is full to the point that nothing is
> executing properly) I am wondering is it safe to delete this file and then
> in the my.cnf file reset the size to something smaller... - how does the
> Ibdata file work in conj
Does anyone know if version 4.0 will support formatted date queries.
Example:
select create_date from what_ever where create_date >
date_format('03/01/2002','%m/%d/%Y')
sql, query
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
I'm in the process of re-writing 100+ perl CGIs written for oracle to mysql.
Does anyone know how to get the dbh->quote(some_value) function in perl to
return the string "NULL" if some_value is empty. Currently its returning
'' (2 ticks) and when you update a numeric column, it sets the value to
On Thursday 27 June 2002 02:30 pm, Mike(mickalo)Blezien wrote:
> Walt,
>
> Use Perl's 'undef' for NULL values.
>
> $quoted_some_variable = undef;
>
> now the $quoted_some_variable will be a null value.
>
> >>On Thu, 27 Jun 2002 12:50:55 -0400, walt
I've set up replication and the slave is updating any changes made to the
master, but these errors keep showing up in the error log. Any ideas??
020716 12:57:26 Slave: Failed reading log event, reconnecting to retry, log
'walt-bin.002' position 265
020716 12:57:26 Slave:
I have an INNODB table which has 4 records in it. customer_number is the
primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to return the number of rows.
I ran explain on the query and it's using the unique key index on
customer_number.
If I run
S
On Tuesday 16 July 2002 05:05 pm, Jeremy Zawodny wrote:
> On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
> > I have an INNODB table which has 4 records in it. customer_number is
> > the primary key.
> >
> > If I run
> > select count(cutomer_number) from
Does anyone know a good way find and remove duplicate records from a table?
I can create an identical table structure and use a script to pull records
from the existing table and insert them into the new table if they are not
duplicates, but I'd rather not do it that way. Here is an example of a
like the index better) on all the columns and do a
insert into new_table using select * from old_table
will mysql quit inserting once a duplicate is hit, or will it keep going and
skip over the duplicates?
walt
On Tuesday 30 July 2002 03:57 pm, David Kramer wrote:
> You could always use an ins
ql -u user_name database < sms.sql
I added this to my .bashrc and saved my password in ~/.my.cnf
alias sql='/usr/bin/mysql -u xxx xxx '
then added
sq ()
{
sql < $1
}
which allows me to use
sq sms.sql
walt
---
I've run into a weird problem. If I try to insert this value, 78978978,
into a FLOAT(9,2) column, the value changes. See below.
System info:
MySQL-shared-3.23.51-1
MySQL-client-3.23.51-1
MySQL-devel-3.23.51-1
MySQL-Max-3.23.51-1
MySQL-3.23.51-1
Red Hat Linux release 7.3 (Valhalla)
#Wrong
mysq
Does anyone know if version 4.x has/will have warnings if data being inserted
is too large for a column?
sql,query
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
"If it's not broketweak it"
Froilan Mendoza wrote:
> Hello,
>
> I have two machines that I am trying to use replication on. Here are their
> configurations:
> master (my.cnf)
> log-bin
> serveri-d = 1
>
> slave:
> server-id = 2
> master-host=master.domain.com
> master-user=replicate
> master-password=replicatedb
> lo
//www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe
Serge Paquin wrote:
> This is the only option? That's not a very automated process and I must import this
>data once a day. I also will not be able to get them to reformate their data since
>I'm only one of many many people downloading everyday. Is their no way for load data
>to do this aut
On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote:
> Walt,
>
> At 01:09 PM 8/20/2002 -0400, walt wrote:
> >on the slave you should run
> >show slave status
>
> on slave:
x,
use the 2.4.x kernel. I would recommend RedHat 7.2 or 7.3 (Oracle has been
certified on 7.2 which helps give that warm fuzzy feeling). RedHat's kernels are
also built from Alan Cox's kernel tree which contains misc. performance patches.
walt
up only files that have
changed.
3. If you store the files in MySQL and you later decide to switch DB software,
you'll pull your hair out!
4. You can archive the files that don't change on CD.
walt
-
Before postin
t;
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dean,
There has been some issues with gcc 3.x if I remember correctly. I know RedHat
released another beta because of problems with gcc 3.x. Have you tried it on a
box
f not you can.
1. ALTER TABLE tbl_name TYPE = INNODB;
2. recreate the table with type=INNODB
3. add default-table-type=innodb to the my.cnf file, restart mysql, and recreate
the table
hope this helps
walt
-
Before posting, ple
-
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMA
he list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Keith,
When you say "Emailing and MD5'ing at the data source.". Are y
hat is the load avg on the db and application server when query/update fails?
6. If the query or update fails, what happens if the perl app sleeps for a few
seconds and trys again?
hope this helps
walt
-
Before posting, please
com/php/unsubscribe.php
Soheil,
If you have a partition that you can dedicate to mysql, just rename the current
mysql directory,
mount the dedicated partion as /var/lib/mysql/ and copy the files from the mysql
directory you
renamed .
tp://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FYI -
Be careful using dbh->quote with inserts and u
To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Keith,
It might be a path issue. What error message is the cron generating?
walt
-
Before posting, p
g,
I've found that its faster to drop a table, recreate it with the new index, and
reimport
the data. From what I understand,
it's because the indexes are kept along with the data unlike myisam where the indexes
are
seperate files.
Hope this helps!
walt
--
Franz Alt wrote:
> I use some mail-lists for mysql, php and security with Outlook Express.
>
> When I "reply", some lists set their list-adress automatically, some the
> adress of the person originally posting. The second version may not so good
> IMHO, because I think so many replies are not goi
anual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Brent,
You mentioned placing the
I have a few questions regarding recovering an innodb tablespace/datafile.
Here's the situation.
I lose a drive on my master database that contained an innodb datafile. I then
shut the database down and umount that drive.
What would I need to copy from the slave database in order to bring the
Scott Pippin wrote:
> I am trying to set up two data files in case the first one fills up. I
> tried to use the following in my.cnf but it says there is an error. If
> I take out the reference to the second data file everything works
>
> AIX 4.3.3
> MySQL 4.0.4
>
>
>innodb_data_file_path=libda
Is there a way to find out what index an sql query is using? I know you can
use explain, but those are just "possible" indexes that the query might use.
I'm trying to find out exacly what execution path it is taking. Something
similar to Oracle's "set autotrace on;"
MySql version - MySQL-Max-3
1 - 100 of 171 matches
Mail list logo
