Will do. Thanks!
--Walt
On Sun, May 17, 2009 at 2:37 PM, Baron Schwartz wrote:
> Walt,
>
> I mentioned your question to Vadim Tkachenko who knows the most about
> it, and he suggested that it might be more appropriate to discuss on
> the percona-discuss...@googlegroups.c
ails are concerned.
If anyone could give me some information, or point me to some good
documentation, It would be much appreciated.
Thanks,
--Walt
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]
'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]
Thanks, as it turns out the solution to the problem was a bit more mundane:
we ran out of disk space on the partition the tables are on. :>)
--Walt
On 10/11/05, walt <[EMAIL PROTECTED]> wrote:
>
> Walt Weaver wrote:
>
> >Hi,
> >
> >I have a job runnning that&
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
&
nge, or if I'm
barking up the wrong tree, show me which tree to bark at?
Thanks,
--Walt Weaver
Bozeman, Montana
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,
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
r buy a company
just because he's caught up in the groovy sunshine world that's Open Source.
And, as an employee of a company that's very, very heavily committed to
MySQL (we're just about completely moved off of Oracle and are using InnoDB)
this whole thing leaves us rather
Here's a SQL statement that converts dates to epoch time in Oracle.
I'm too lazy to convert it to MySQL but it should give you a start.
select 86400 * ( to_date('14-feb-2000 10:38:39', 'dd-mon-
hh24:mi:ss')
- to_date('01-jan-1970'
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
It's probably not odd.
Does every query take 10 seconds to execute, or is that how long it
takes to return data?
Why don't you run tkprof on the Oracle queries to see how long they
actually take to complete?
--Walt
> -Original Message-
> From: Jaime [mailto:[EMAIL PR
i and 9i at the latest patch
levels. Applying the appropriate patches on Oracle can make a big
difference too.
--Walt
> -Original Message-
> From: Jaime [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 16, 2004 4:59 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL vs Oracle
>
>
Perl/DBI is a possibility.
--Walt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: ORACLE to MySQL migration
>
>
> Hello colleagues,
> I have to migrate a lo
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 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
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
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]>;
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
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.
>
>
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
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
Or use an outer join with "where members.list_id is null", as was
mentioned on the list earlier today.
--Walt
> -Original Message-
> From: Martijn Tonies [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 3:18 PM
> To: [EMAIL PROTECTED]
> Subject
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]
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
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 .
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
; 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
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]
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
I use MySQL in both a Unix "real" C/S config and then on my laptop standalone. The
documentation on the Web site showing how to take commands from a file is simple
enough. source file_name_containing_commands; and this works just fine in Windows,
but in UNIX, no matter how I try to resolve 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]
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 "
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 -
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:
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
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
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
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 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: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 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"
> > >
> 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 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
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 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]
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
, 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]
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
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:
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
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
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
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
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
--
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
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
: 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
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
--
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
<[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
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
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.
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
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
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
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)
? 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
--
<[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
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
st be at
least 4 bytes for a large table, if it says 3 you have a problem!
This is isn't clear from the CREATE TABLE section of the manual, but
is in the "1.2.4 How Big Can MySQL Tables Be?". I don't know i
Peter Zuidema wrote:
> Please help,
>
> We have big performance problems.
>
> This is the situation:
>
> We haven an Windows NT server with a P355 processor and 256MB Ram. We have
> installed version 3.49 of mysql
> (we have also tried version 3.52).
>
> When we do a select on a table which contai
server over the
> net, but I'd still like to know for future what causes this, as I'm to
> decide soon what to upgrade to, 7.3 or 8.0, at this point, I'm leaning
> heavily towards 7.3 as my gutt tells me this might be some kind of a
> bug.
>
> Thanks for the help so f
able to use
/usr/bin/mysql -u user_name database_name< file_name_with_sql
If you're using linux/unix, you can something like this to your .bashrc
sq ()
{
/usr/bin/mysql -u user_name database_name < $1
}
which will let you do
sq file_name_with_sql
walt
---
On Tuesday 22 October 2002 03:41 pm, Petre Agenbag wrote:
> Hi Walt
> Thanks for the quick reply.
>
> Answer to both questions is yes.
> As a matter of interest,
> What I usually do is to create a "myodbc" db with a "myodbc" user and
> password &quo
-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Petre,
If you run
netstat -an |grep tcp
do you see that the mysql port (3306 ) listening?
Also, even if you dont have a firewall,
if
replication.
I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and
stopping mysql on both
the master and the slave. Then delete log files on the master including the
*.index file. I'd then delete
any files on the slave that deal with replication (master.info).
Once all th
ource rpm was installed, everything should have been installed in
/usr/scr/redhat/ .
If you simply ran
rpm -i rpm_name.rpm
then you shouldn't need to run mysql_install_db. You shoud be able to start mysql
from the script
/etc/init.d/mysql
walt
---
On Tuesday 15 October 2002 05:07 pm, Jesse Sheidlower wrote:
> I did check out the link below, in which someone else has an
> error identical to mine, and Sinisa Milivojevic replied
> basically saying that the answer is described in detail in the
> Manual.
>
> Well, I can't find it in the Manual.
On Tuesday 15 October 2002 04:53 pm, [EMAIL PROTECTED] wrote:
> Thanks very much for your replay
> Is very interesting but how to change that declaration on mysql or
> on the headers if there is any to modify. I have others Linux boxes
> running mysql fine but each time I have to deal with the oth
[EMAIL PROTECTED] wrote:
> Hi everyone!
> I'm trying to build /mysql-3.23.53 on a sparc Solaris 9 box but
> without any luck
> Please guys can anyone give me an idea about?
>
> Any help will be highly appreciated
>
> -Jose
>
> Specs: solaris 9, gcc-3.2, mysql-3.23.53
> configured as:
>
> CC=gcc C
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
Jesse,
Check out
http://www.faqchest.com/prgm/mysql-l/mysql-00/mysql-0012/mysql00
'
into a date field,
when you retreive the value, it will be -00-00. The same thing happens with
numeric fields.
walt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
On Tuesday 15 October 2002 10:59 am, Heikki Tuuri wrote:
> Walt,
>
> - Original Message -
> From: "walt" <[EMAIL PROTECTED]>
> To: "Heikki Tuuri" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 15,
Heikki Tuuri wrote:
> Walt,
>
> - Original Message -
> From: "walt" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, October 12, 2002 11:20 AM
> Subject: innodb not using correct index
>
> > Is there a way to find ou
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
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
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
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
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
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
--
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
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
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 .
I'd use the InnoDB table type and establish a primary key/foreign key
relationship (parent-child) between the two. That way referential integrity
will be done for you by the database.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Chris Burger [mailto:[EMAIL PROTECTED]]
Try this (not sure the syntax is exactly right since I'm more used to
Oracle's outer join syntax):
select * from main left join activity on main.user = activity.id
where activity.id is null;
This should return only the users in main that are not in activity.
--Walt Weaver
Bozema
This must be a great scam. I'm starting to see'em all over the place.
--Walt
-Original Message-
From: Ocita Gabriel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 3:53 PM
To: [EMAIL PROTECTED]
Subject: Goodday
Attn: mysql ,
My name is Ocita G, the manager,
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
1 - 100 of 171 matches
Mail list logo