Apologies for a late reply.
1) The query that tries to insert the invalid entry into Table2 fails.
Therefore, if you have 3 separate queries as in the first case, the
last one fails, but the first 2 are successful. In the second case,
they're all in one query, and if one fails, they all fail.
(apologies for the late reply).
1) A warning doesn't stop the rest of the script from running.
Temporary tables go away at the end of the session, and aren't visible
to any other session, so the server not being able to handle those
commands is no big deal.
2) I'm using MySQL
Better late than never
I believe the reason is because (at least on unix) if you connect to a
database on the same machine (using -h localhost or just omitting the
host) it will use the socket -- and therefore saying host=localhost
is like saying if they come from the unix socket, where as
As a session variable, it resets when you open a new session.
-Sheeri
On 6/21/06, Tony_10ph [EMAIL PROTECTED] wrote:
Hello guys... I have stored procedures and I want when a calling program call
my stored procedure it will return a response that the stored procedure
execute successfuly or
On 6/22/06, Scott Haneda [EMAIL PROTECTED] wrote:
I have two chunks of data to import, one is in this format:
01001 - AGAWAM, MA,01001,0,0,291,249,0,42.070206,-72.622739
Where it is comma sep and partially quoted
The other is in this format
99502 ANCHORAGE,
create view v_authornames as
select authorid, CONCAT(lastname,',',firstname)
from t_authors;
Or replace the middle term in the CONCAT function to whatever you want
to separate it -- ie, ' ' for a space, or just
CONCAT(lastname,firstname) to get output KritzerSheeri.
-Sheeri
On
Hopefully you're not still having this problem. I don't use
phpMyAdmin, but I know that it allows you to run repair table to try
to fix a table after a crash. Does that work?
-Sheeri
On 6/25/06, Khaled Jouda [EMAIL PROTECTED] wrote:
Hello,
I am having a problem with one of my MySQL
only and getting
error line now data for other columns
Hope you will find the solution
Cheers.:)
Neeraj Black Bits
-Original Message-
From: Harish TM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 30, 2006 10:23 PM
To: sheeri kritzer
Cc: Neeraj; mysql@lists.mysql.com
Subject: Re: Problem
Did you try the first query again? Is it possible that another
Szczech was added in the time you did both queries? What happens
when you the simple
mysql select id_c, name, from clients where name like 'Szczec%';
and
mysql select id_c, name, from clients where name like 'Szczech';
and most
Yes and no. The binary log is a long list of all changes to the
system, so if that's enabled you can get what was done. My binary log
(on 4.1.19) shows the query thread, but not the user/host that did the
change. So it might be difficult to implement an undo.
Also, delete from table1 does not
Firstly, I apologize for my incorrect db level grant in the syntax I posted.
Secondly, by going to mysql.com/grant I found the GRANT syntax page,
which states:
The FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE,
SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative
What's the error you are getting? What MySQL version are you using?
On 5/26/06, Neeraj [EMAIL PROTECTED] wrote:
Hi all
I have a table with following structure
CREATE TABLE `dsc` (
`ch_code` varchar(255) default NULL,
`name` varchar(255) default NULL,
`inof` blob
)
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html
-Sheeri
On 5/29/06, Michael Monaghan [EMAIL PROTECTED] wrote:
Hi,
I have a machine [Solaris 9 x86] that has MySQL v3.22.xx installed.
I am not familiar with the applications [quite a few] that use this
instance.
I need to install
or estimate about the production release?
Bgs wrote:
Nope... pure myisam...
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan
People who've asked the same question have gotten the answer that it's
not possible with MySQL, if I'm remembering correctly.
-Sheeri
On 5/29/06, Ghaffar [EMAIL PROTECTED] wrote:
Hello all,
I have seen that there are some people asking the same question.
How to bind to multiple ip addresses
?
I'm thinking about webex and how they send emails that automatically adjusts
for time zones. I think at some point, I had to tell them what time zone I
was in. I see that a lot on the web. Seems like a pain, but I don't see any
way around it.
-Brian
-Original Message-
From: sheeri kritzer
GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
It won't set up a new account, just add the privilege for you.
-Sheeri
On 5/26/06, Gilles MISSONNIER [EMAIL PROTECTED] wrote:
Hello
How to set FILE privilege enable to an already defined user ?
It seems that I have to read
You should just be doing
mysqlhotcopy ...connect-options... --regexp /~^db_name$/
or
mysqlhotcopy ...connect-options... --regexp /~^db_name$/ /path/to/new/dir
On 5/25/06, MF [EMAIL PROTECTED] wrote:
Hi, how to write pattern for backup all datases except one?
I try this, but not work as
What does
mysql-workbench --sync
give you?
-Sheeri
On 5/25/06, Gregory Machin [EMAIL PROTECTED] wrote:
I get the following when I try and lauch mysql-workbench .
[EMAIL PROTECTED] ~]$ mysql-workbench
The program 'mysql-workbench-bin' received an X Window System error.
This probably reflects
can't do
that in my case.
DÆVID
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 6:27 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: How do I turn off error checking
If you run a script with
mysql script.sql
Brian,
MySQL's timestamp function is based on the *server*'s timestamp, not
the client's.
-Sheeri
On 5/24/06, Brian Menke [EMAIL PROTECTED] wrote:
Wow, if I read that right, it means someone on the East coast submits
answers to a test, it's somehow adjusted to be the same as someone who
What exactly is the performance problem you are seeing?
Have you checked to make sure all your memory is being utilized? ie,
not just grabbed by MySQL, but actually in use?
-Sheeri
On 5/24/06, Dan Trainor [EMAIL PROTECTED] wrote:
Moritz Möller wrote:
Hi Dan,
there are about 2GB free, so
If I remember correctly from the certification guide, MySQL opens a
file handle for each table opened. When you have a MyISAM table,
that's one file handle each for the structure, data and index files.
So if you have a query that uses only one table, it can spawn up to 3
file handles.and
Rich
for what? is
SELECT host,user,password FROM mysql.user;
showing you cleartext passwords? It shouldn't.
-Sheeri
On 5/23/06, Rich [EMAIL PROTECTED] wrote:
Hi folks. Me again.
I finally got this all up and running under crypt of 'cleartext'.
So, even though I am going to be on
I don't think MySQL can do thatmaybe with some kind of stored procedure
If you're using 5.0 or higher, use the INFORMATION SCHEMA to find out
if the column exists. If not, use the show create table statement
and parse it.
Why is this a problem, though? (just curious, I'm not sure this
If you run a script with
mysql script.sql
then if there's an error, the script dies.
If you run a script with
mysql -e source script.sql
Then the script will just spit out an error and move on to the next command.
Hopefully that will help.
-Sheeri
On 5/24/06, Daevid Vincent [EMAIL
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor [EMAIL PROTECTED] wrote:
Bgs wrote:
No ideas?
I tried playing around with read/write
As an addendum to this -- this was solved. The master and slave were
out of sync.
-Sheeri
On 5/19/06, Jeremy Cole [EMAIL PROTECTED] wrote:
Hi Sheeri,
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
Well, you're going to need to state how big a record is, what OS
platform you're using, what MySQL version you're using, and exactly
what error message you get when you're trying to insert that 5th
record.
Your my.cnf would help, too.
-Sheeri
On 5/22/06, Eko Budiharto [EMAIL PROTECTED] wrote:
http://dev.mysql.com/doc/refman/4.1/en/encryption-functions.html
On 5/21/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi Guys,
Can somebody enlighten me on AES_CRYPT AES_DECRYPT functions on
MySQL. I noticed that you can mention DES key file in mysqld statup
options. how does the AES works?
Only with MySQL 5.0 is multi-master replication possible. Guiseppe
Maxia has a wonderful article about it at:
http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html
-Sheeri
On 5/22/06, Winanjaya - CBN [EMAIL PROTECTED] wrote:
Dear Expert,
I am very new to MySQL
I've found that queries that take a long time cause lag time.
Replication on a slave has 2 threads -- one to retrieve stuff from the
logs, and another to actually run the DML queries. Therefore, while
one thread is stuck on a loggg query, the other thread is
still gathering stuff from
Did you successfully alter the table? What does SHOW CREATE TABLE give you?
mysql CREATE TABLE test ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT
PRIMARY KEY, ts_create TIMESTAMP DEFAULT CURRENT_TIMESTAMP, ts_modify
TIMESTAMP );
Query OK, 0 rows affected (0.00 sec)
mysql insert into test(id)
On 5/19/06, Lyle Tagawa [EMAIL PROTECTED] wrote:
Given a nptl/linux box (or pthreads/freeBSD) for example, can you tell
what is the theoretical max running thread count (in the context of
paging/process scheduling and not in the context of memory sizing),
assuming that there's no
On 5/19/06, Martijn Tonies [EMAIL PROTECTED] wrote:
Well, one reason could be, for example, that the address changes
over time and they want to know what address the customer was
when the order was processed.
I agree.
I wouldn't enter the delivery and billing info either, but create
some
put
log
or
log=/path/to/file
in your config file (my.cnf) and restart the server. To turn it off
you have to take it out of the my.cnf and restart the server.
I've put in a request to make the general log something that can be
dynamically turned on.
-Sheeri
On 5/19/06, Rich [EMAIL
On 5/19/06, Martijn van den Burg [EMAIL PROTECTED] wrote:
Nothing special, just some updates on a single database. No flushing of
logs... The strange thing is that the condition of extremely high lag lasts
only a couple of seconds, and then tapers back very quickly to zero.
That is weird. If
Not that I know of, but if you don't do binary (case-sensitive)
searching then does it really matter?? You can retrieve with LOWER, or
put it in your application, if your application needs to display it
that way.
-Sheeri
On 5/18/06, Ferindo Middleton [EMAIL PROTECTED] wrote:
I have column and
You have to change the delimiter you use, otherwise MySQL treats the ;
as the end of the line and processes the commands. When I tried to
run your trigger (with the standard delimiter of ;) I got:
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to
I suggest writing a very simple shell script to run SHOW SLAVE
STATUS and output it to a file every 15 seconds, to verify your
script is working. I have never seen MySQL give a bad lag time for
replication -- it's always been accurate for lag time, or 0, or NULL.
As a bonus you could then use
Replication puts 2 threads on the slave -- 1 to get the information
from the master and put it into the relay log, and another to read
from the relay log. You pose a good question about master.info -- I
honestly don't know, but the read position is either the same as or
before the exec position,
It depends on what the data is being used for. If you want to know
what address an order was shipped to then you need the historical
address info. If all you need is the current customer address,
because, say, you're sending out holiday cards, then you might not
need to keep an old address.
there) and put this into it:
log=/var/log/myrequests.log
Now MySQL won't start.
Any ideas?
Cheers
On May 19, 2006, at 11:35 AM, sheeri kritzer wrote:
put
log
or
log=/path/to/file
in your config file (my.cnf) and restart the server. To turn it off
you have to take it out of the my.cnf
in defaults handling. Program aborted
/var/log/ does indeed exist
root runs mysqld
On May 19, 2006, at 12:01 PM, sheeri kritzer wrote:
Yes. idea #1 -- reply all, including the list.
idea #2 -- what's in the error logs?
Check that the user that runs mysql has permission to write
So I've seen replication break a few times due to duplicate queries.
A few times it was around a server crashing, but I thought perhaps it
was because of the crash. (ie, master sends a query, crashes, and
then tries to send the query again when it comes back up).
But in the past 16 hours, it's
Well, it's documented here:
http://dev.mysql.com/doc/internals/en/flush-tables.html
Every time a thread releases a table, it checks if the refresh
version of the table (updated at open) is the same as the current
refresh_version. If not, it will close it and broadcast a signal on
COND_refresh
The short answer is in the config file. The long answer is to read:
http://dev.mysql.com/doc/refman/4.1/en/log-files.html
Or whatever manual version is appropriate to your MySQL version.
-Sheeri
On 5/17/06, Peng Yi-fan [EMAIL PROTECTED] wrote:
Hi everyone,
How to change the log file path
Mike,
I can't really help except to ask if you're sure you copied and pasted
the query correctly. I did a similar query against a test system:
select u.uid,u.username,b.buddyUid,SEC_TO_TIME(SUM(TIME_TO_SEC(u.modified)))
as mins from Users u left join BuddyList b on u.uid = b.uid where
On 5/14/06, Jim [EMAIL PROTECTED] wrote:
Thanks Sheeri,
How do you run the profiler and what does it do?
Have recently had to add some indexes to various tables to improve
performance so does not seen to be running automatically.
-Original Message-
From: sheeri kritzer [mailto:[EMAIL
I don't know what version you're running, but a
mysql -?
will show you the variables you can set. It's not ALL variables you
can set that way, just a few. You will see that the variable you're
trying to set cannot be set via a command on the commandline.
However, your first command could be to
Yes -- did it help?
-Sheeri
On 5/15/06, Miles Thompson [EMAIL PROTECTED] wrote:
Sheeri,
So even if I am executing mysqld-nt.exe from the directory where it is
installed, preface it with the full path?
Never thought of that - worth a try.
Thanks - Miles
At 05:23 PM 5/12/2006, sheeri
You cannot get data out of a database if it's not in the database. If
there's no data for a day, you cannot get 0 for that day, because the
day does not exist in the database. You could make a calendar
table, one row per day, and join it with a count to get 0 for the day.
-Sheeri
On 5/15/06,
I've had this same problem -- if the database loses connection at the
same time the log file flushes, you need to SET MASTER_LOG_FILE and
MASTER_LOG_POS again and restart. I believe this probably qualifies
as a bug if you want to report it.
The reason the slave isn't updating log5 is because
Check out line 1 of the fill_help_tables.sql file. (on my
installation it was in /usr/share/mysql) See if there is an errant .
There shouldn't be, of course, but that's the problem according to
MySQL.
-Sheeri
On 5/15/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I start from an up-to-date
We use float. I have no idea if that's better or worse, but that's what we use.
-Sheeri
On 4/26/06, René Fournier [EMAIL PROTECTED] wrote:
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22)
This is an Access problem; you'll need to find folks who know access to fix it.
Try:
http://www.tek-tips.com/viewthread.cfm?qid=1146857page=1 ??
-Sheeri
On 4/26/06, Daevid Vincent [EMAIL PROTECTED] wrote:
I have a critical problem that I hope there is a simple solution for.
I've just spent
that I
get the above error and inability to update.
I am still at a loss as to how to fix this so that I can order by any field I
wish.
Any input is greatly appreciated.
Thanks,
Travis Eland
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Thu 5/4/2006 4:15
Hi Jesse,
Have you tried the following:
1) ordering by only part.d and seeing how long the query takes
2) putting an index on (part.d, cwGroup.stripped_cw) and seeing how
long the query takes.
1 will help pinpoint the problem, and 2 might actually help.
-Sheeri
SELECT part.d,
- 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
- Original Message -
From: sheeri kritzer [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent
http://www.devshed.com/c/a/MySQL/A-Technical-Tour-of-MySQL/
The MySQL server has it built in.
-Sheeri
On 5/8/06, Jim [EMAIL PROTECTED] wrote:
Hi All,
Didn't know there was an optemizer for mySQL.
Where can I get it from?
Thanks
Jim
Best regards,
Jim Clark
Project Manager
definition in MySQL, the actual problem
could be caused by Visual Basic, MyODBC or MySQL itself. I don't know what to
try next.
As always, any help is greatly appreciated.
Thanks again,
Travis Eland
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Fri 5/12/2006 10:01
I'll add make sure logs and data are on separate partitions so
you're not doing excessive seeking back and forth.
-Sheeri
On 5/12/06, Dan Buettner [EMAIL PROTECTED] wrote:
Hope it is useful.
I agree, you may want to look at adding another card and disks, for
speed and to segregate the various
The courses MySQL offers are excellent. Perhaps good courses to take
would be the MySQL DBA or Developer Certification Tutorials, and then
take the certification tests. http://www.mysql.com/training/ I've
taken their courses and have only good things to say.
-Sheeri
On 5/12/06, Barry [EMAIL
Not particularly. You're not buying an upgrade, you're buying a
license for a new product. You can use MySQL all you want for free,
you just can't repackage or embed it without a license.
I don't see it as an upgrade issue really. You'll want to rewrite
many queries, add new features, etc to
Hi Amer,
Indeed, the 'func' table in the 'mysql' database has the same
structure that you found in your client database. in your upgrade,
did something go wrong and you did a mysqldump of the mysql database
and reimport? Are you sure you're in the right database? What does
describe
MySQL's pretty good when it describes an error. (if the error message
is vague you might be screwed, but MySQL is pretty good).
Which means:
1) You didn't properly change the max_allowed_packet on the master.
what does show variables like max_allowed_packet; show you?
2) The slave is
http://www.ncb.ernet.in/education/modules/dbms/SQL99/
-Sheeri
On 5/10/06, Peng Yi-fan [EMAIL PROTECTED] wrote:
hi,
does anyone know where to download ISO-SQL-99?
PDF is best.
thanks
Pang
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I diagree on point 1. If you warn your members that their password is
insecure, and if you e-mail out passwords anyway, there's no reason
not to have a secure password. Many people I know use an insecure
password for many things, from silly required free registration sites
(go ahead, break into
See response below:
On 5/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
It looks like today is my day! :)
I FULLTEXT indexed my table products:
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name`
I'm going to guess that the path variable is only looking at the MySQL
3.23 mysqld binary. Try using a full path to the MySQL 5.0.20 binary
and see if you still get errors.
-Sheeri
On 5/10/06, Miles Thompson [EMAIL PROTECTED] wrote:
I am trying to install two MySQL servers to run as Windows
Hi Dan,
You never really say what your memory problems are. Is MySQL crashing
because you're trying to use too much memory?
more comments inline
On 5/11/06, Dan Trainor [EMAIL PROTECTED] wrote:
What I'm dealing with here is memory problems using MySQL 5.0.19 under
FreeBSD. Although
So, our MySQL master database crashes about once a week, then
immediately recovers. We are running a Dell 2850 -- 64-bit Fedora Core
3 box with 6G of memory, 4 Intel Xeon processors, at 3.60 GHz speed
each (says /proc/cpuinfo), each cpu cache size is 2048 Kb. It
replicates to 2 slaves, which have
http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/
Is a good article.
-Sheeri
On 4/21/06, Chris White [EMAIL PROTECTED] wrote:
I was looking around the list search and didn't find much on this subject
(maybe didn't look back far enough), but I was discussing
Do a show status like 'uptime' after the script runs. See if the
server crashed (if so, uptime will be low) -- if the server crashed
you might get that error.
show variables like %connections should show you how many
connections you can have per user and total. That shouldn't be the
problem;
If your server has log-warnings set to ON, you can check the error
logs, and use a script to count how many times for each host, in a
row, this happens.
-Sheeri
On 5/5/06, Kishore Jalleda [EMAIL PROTECTED] wrote:
On 5/5/06, Dominik Klein [EMAIL PROTECTED] wrote:
I experience that my slave
You're comparing apples to oranges -- your where clauses are
different. The first query uses the primary key because you're
actually comparing 'account' to something. The second query doesn't
because you're using the 'street' field -- what does SHOW INDEXES
FROM account; show? any indexes on
You don't have ANY idea what branch it was created with? 3.2x, 4.0,
4.1, 5.0, 5.1 ? I'd recommend finding another similar server in your
dept and see what it's running (assuming there's no standards doc, or
sysadmin to ask, etc).
Do you remember around when the time was that you last
Try looking at the documentation for groupwise maximum.
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
-Sheeri
On 5/5/06, Ian Klassen [EMAIL PROTECTED] wrote:
Hello,
I'm working on using a temporary table to get the group-wise maximum for
a number of items. I
Sounds like you want LIMIT and OFFSET --
everything after my name and before your post is copied from the doc at
http://dev.mysql.com/doc/refman/4.1/en/select.html
(or am I misunderstanding your question?)
-Sheeri
The LIMIT clause can be used to constrain the number of rows returned
by the
John,
You're close -- If a single case-sensitive letter won't help (or isn't
descriptive enough -- is 'S' sophomore or senior or special student?)
The best way to do it is NOT to make new codes. If they're giving you
codes, use theirs -- why make up a new system if you don't have to?
create
The total possible memory MySQL will use is:
innodb_buffer_pool_size + key_buffer_size +
max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
Someone please correct me if I'm wrong.
Are your most heavily used tables innodb? If not, then you're not
On 5/4/06, Luke Vanderfluit [EMAIL PROTECTED] wrote:
[snip]
I started this process remotely then went to the site to finish it.
But when the dump finished (several hours later) I was not able to
execute the following commands from my original location.
mysql SET FOREIGN_KEY_CHECKS = 1;
mysql
You are not being honest with us on the list.
Firstly, the error you got:
You have an error in your SQL syntax near 'USING USING
A
RIGHT JOIN B ON B.id = A.sectionid' at line 1
SQL=DELETE FROM A USING A
RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null
indicates that you used the
I don't know what version of MySQL you're using, but a google search
on mysql croatian got me:
http://bugs.mysql.com/bug.php?id=16373
and
http://bugs.mysql.com/bug.php?id=6504
which implies you can use CHARACTER SET latin2 COLLATE latin2_croatian_ci
but also shows that it's not quite working
LOAD DATA FROM MASTER only works for MyISAM tables. Is
tracking.session an InnoDB table?
-Sheeri
On 5/4/06, Hunter Peress [EMAIL PROTECTED] wrote:
Hi. im trying to add a second slave using load data from master ,and
it seems to me that when i run this command on the
new slave that its simply
Rich,
anonymous access means that ''@host has access. That is, blank at
host, as opposed to [EMAIL PROTECTED]
To see if anonymous access is allowed, at the command prompt type:
mysql -u asdf
if you get a mysql login, you have anonymous access.
Otherwise you'll get:
ERROR 1045 (28000):
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
(I used the default binlog_cache_size value of 32K plus your settings)
MySQL could use up to 4.991913 G of memory.
1) See if the DNS on one machine is different. If it's trying to
resolve the host on one and failing, that might be why it's slow.
2) how did you copy the database?
3) what's the data usage like on each machine? If one machine is
used a lot and the other is used very little, then it may be
it is not so easy to figure
it out And it might take a while to trial-n-error all 4.1.x
Nils
-Oprindelig meddelelse-
Fra: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sendt: fr 05-05-2006 20:28
Til: Nils Lastein
Cc: mysql@lists.mysql.com
Emne: Re: Determine version of *.frm, *.MYD and *.MYI
su - mysql
touch /var/lib/mysql/mysqlmanager.log
see if that helps; maybe having the file there will kick it into gear.
Is mysqlmanager actually running? Is there a pid file?
-Sheeri
On 5/5/06, Duzenbury, Rich [EMAIL PROTECTED] wrote:
-Original Message-
From: sheeri kritzer
if that throws any light on
things.
Regards
Keith Roberts
In theory, theory and practice are the same;
in practice they are not.
On Fri, 5 May 2006, sheeri kritzer wrote:
To: Nils Lastein [EMAIL PROTECTED]
From: sheeri kritzer [EMAIL PROTECTED]
Subject: Re: Determine version of *.frm, *.MYD
None from me, sad to say. :(
-Sheeri
On 5/5/06, Duzenbury, Rich [EMAIL PROTECTED] wrote:
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:00 PM
To: Duzenbury, Rich
Cc: mysql@lists.mysql.com
Subject: Re: mysqlmanager logging?
su
On 5/5/06, John Heim [EMAIL PROTECTED] wrote:
In fact, I would not gain clarity by using the 5-char codes that have been
imposed upon me. Freshman='10'. Sophomore='20'. There's even a '00' code
and a '05' for some status less than Freshman.
Imposed upon you? You're the DBA, right, not an
://www.sdwebsystems.com
On Fri, May 5, 2006 2:35 pm, sheeri kritzer said:
Sounds like you want LIMIT and OFFSET --
everything after my name and before your post is copied from the doc at
http://dev.mysql.com/doc/refman/4.1/en/select.html
(or am I misunderstanding your question?)
-Sheeri
-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re: importing a dumpfile from with the mysql client
On 5/4/06, Luke Vanderfluit [EMAIL PROTECTED] wrote:
[snip]
I started this process remotely then went to the site
Perhaps it's time to file a bug report, then?
-Sheeri
On 5/3/06, Alex [EMAIL PROTECTED] wrote:
This problem is indeed not related to OS / Hardware Problems.
Take a look at this thread:
http://lists.mysql.com/mysql/197542
Read the part about show databases as root vs standard user
+
(catching up on old mail) What version of MySQL are using? It
works in 5.0.19 and 5.1.9-beta. If you're trying on a version 5.0,
it won't work.
-Sheeri
On 4/9/06, Daevid Vincent [EMAIL PROTECTED] wrote:
I'm trying to follow the example in the manual to create a trigger:
Coming to the table SOOO late. But this has special relevance as I'm
working on an application that stores event dates and therefore will
also need to solve this problem.
The biggest question I have is What will this be used for? My first
thought is to have at least 2 tables -- one table with
(again, apologies for the lateness...)
MySQL has a cost-based optimizer. If it's deciding that a full-table
scan is appropriate, there's a reason. If more than 30% (approx) of
the table would be returned in a range query, the optimizer reasons
that it's LESS expensive to just do a full table
On 5/4/06, sheeri kritzer [EMAIL PROTECTED] wrote:
(again, apologies for the lateness...)
MySQL has a cost-based optimizer. If it's deciding that a full-table
scan is appropriate, there's a reason. If more than 30% (approx) of
the table would be returned in a range query, the optimizer
1 - 100 of 241 matches
Mail list logo
