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 databa
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 6
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,
AK","256","265","1424","196
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 re
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 a
(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 5.0.19-standard-lo
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.
F
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
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
irst column 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:
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
k in 5.1 ...
BTW: Any official info 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/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
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
) ENGINE=Inn
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
pr
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 re
o I can do comparisons that way?
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
-O
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 it's
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,
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
subm
il, I know about forcing it, but I 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
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
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 exp
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/writ
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 PRO
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 thi
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 o
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 repli
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 work
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:
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 i
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 h
ine: 1
Fatal error 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 t
x27;t 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.
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.
Mar
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,
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
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 your
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
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. I
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 PROTECT
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
som
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 configuration
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)
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 th
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 (
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
u.modifie
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 pat
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-dat
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 it'
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,
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,
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
Sheeri
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 kritze
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
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 I'
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
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` varcha
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
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:http
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 actu
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.func
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 g
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
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 vari
g" error.
While the issue stems from the view 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: shee
It looks like MySQL installed but when it tried to start the server,
the server crashed. Can you confirm that?
If so, try starting it with the startup script -- you should get the
same error. If it's still broken, start it with the core-file and
core-file-size option (I recommend unlimited):
h
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
Mu
my.cnf.
>
> Best regards,
>
> Heikki
>
> Oracle Corp./Innobase Oy
> InnoDB - transactions, row level locking, and foreign keys for MySQL
>
> InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
> tables
> http://www.innodb.com/order.php
>
&g
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, quotation.qt,
It is when I order by a field that is not from this main table 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
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=1146857&page=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 spen
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) f
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
+ observ
to session to issue a commit?
-Original Message-
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:
case?
--
Steve - Web Applications Developer
http://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/ref
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 e
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:
copies, see 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
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: sh
compiled it my self 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 v
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
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. Shouldn'
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): Acce
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
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 y
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 USIN
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;
mysq
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
looking
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 ta
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 SEL
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.
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
installed/
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 '
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
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
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
Maybe I'm thick
You have a view, called vwMyView.
You SELECT rows from it, and you're able to update the view?
Yet when you SELECT with an ORDER BY clause, you're not allowed to
update the view?
I just do not understand how a read statement affects DML. I think
you're going to have to pos
Can the program write to /var/lib/mysql/mysqlmanager.log? check permissions.
On 4/19/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
MySQL 5.0.20
I've got two instances running with mysqlmanager. I'm not getting any
logging of any sort.
mysqlmanager --help shows:
I'd check to make sure you installed mysql-devel, which includes the
libraries and header files.
-Sheeri
On 4/18/06, tuxlinsecure <[EMAIL PROTECTED]> wrote:
Hi,
I uninstalled Mysql 3.23 (tar.gz )and installed Mysql 5.0 (rpm) on my server.
When I check shared lib dependencies using the follow
1 - 100 of 243 matches
Mail list logo