MySQL: Ver 5.0.51a-24+lenny4-log for debian-linux-gnu on x86_64 ((Debian))
Hi, I am looking for alternate methods to rotate the query and slow query
logs. Currently we employ the following method, in psedu code:
sh# rename mysql.log mysql.log.foo
mysql> FLUSH LOGS;
sh# move mysql.log.foo /back
Hi, I tried searching for an answer to this to no avail. I noticed my
mysqld.log contains negative connection/thread IDs. mysqld itself shows
positive IDs as expected. Some sort of wrap?
/usr/sbin/mysqld, Version: 5.0.32. started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time
Hi, care to elaborate on the pit-falls of binlog-do-db?
Thanks,
Atle
On Wed, 4 Mar 2009, Baron Schwartz wrote:
No. But I would recommend removing binlog-do-db and using
replicate-wild-do-table=.% on the slave instead. The
binlog-do-db approach has many pitfalls anyway, and is likely to burn
You should be able to do this fine. It would help if you specified what
the error you were getting was.
Atle
On Tue, 22 Jul 2008, Jim Lyons wrote:
I recently installed 2 instances of mysql on the same server, using port
3307 for the second server, the normal 3306 for the first server. I fou
I don't think anyone answered your actual question, so here's my attempt..
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
"Many status variables are reset to 0 by the FLUSH STATUS
statement."
Atle
On Fri, 20 Jun 2008, Venu Madhav Padakanti wrote:
I am us
I've found that if you take your time properly configuring, that
mysqld_multi works great with managing multiple instances. There is
supposedly a new way that has replaced mysqld_multi, however I am not
familiar with it.
Our most common use of running 2 or more instances on the same server is
I wrote this Nagios (http://nagios.org/ - a monitoring tool) specific Perl
plugin a few years ago, but you can easily use it for your needs. The
version I have online does not support mysql 5.0+ but that is easily
remedied..
info;
http://www.byveka.com/files/README.check_replic
script;
Sounds like Gerald is right, your database server is not configured to
support replication. Have you given your database server a 'server-id'?
On Wed, 20 Jun 2007, Gerald L. Clark wrote:
> Ananda Kumar wrote:
> > Hi All,
> > We have setup replication. Mysql version 5.0.40. On master db, if i ex
The "\!" command is specific to the mysql client and executes locally,
making it useless for this purpose.
If you don't have access to 5.0.41+ and the database you are querying is a
replicated slave, you can use the 'server_id' variable to tie the server
to an actual hostname (SHOW VARIABLES LIKE
Have you tried this flag?
-q, --quick Don't buffer query, dump directly to stdout.
On Sun, 29 Apr 2007, Fredrik Carlsson wrote:
> Hi,
>
> I have a problem with mysqldump, its exiting with the message
>
> mysqldump: Error 5: Out of memory (Needed 22042208 bytes) when dumping
> table `t
There is no option to do this to my knowledge. However, this would be a
quick workaround:
- TRUNCATE TABLE ; # clears table completely, akin to doing
DROP/CREATE TABLE
- INSERT INTO SELECT .. FROM ..;
On Mon, 16 Apr 2007, Amer Neely wrote:
> > At 08:14 AM 4/13/2007, Amer Neely wrote:
> >> I'm
Out of curiosity, how many queries/sec are you able to push from each
slave? If I may ask.. :)
Atle
On Mon, 5 Mar 2007, Ross Vandegrift wrote:
> On Fri, Mar 02, 2007 at 12:57:25AM -0800, Gary W. Smith wrote:
> > Pdns?
>
> Close! bind-dlz
>
> > Anyway, did you enable the slow query logging? Th
Joern, is the client version of mysql in PHP the same as your client libs
on the server (where you run perror)? PHP is often times compiled with its
own mysql libs and you have to specifically tell PHP to build with the
system mysql libs if you want to.
Just a thought.
Atle
On Sun, 25 Feb 2007,
2 way replication, also referred to as dual master replication, has been
available for quite some time. However implementation can be tricky. Look
for the "Dual master" section in chapter 7 of the High Performance MySQL
book:
http://dev.mysql.com/books/hpmysql-excerpts/ch07.html
If you nee
2) Your OPTIMIZE statement does cause mysql to create a temporary table,
which eventually replaces your current one.
I suggest you try something along the lines of this and compare speed:
- LOCK TABLES ..
- CREATE TABLE `` (..) # identical table
- INSERT INTO `` SELECT * FROM `` WHERE date < (NOW(
Ed, this is unfortunately "by design". Personally I don't get why this
choice was made...
Reference:
http://lists.mysql.com/mysql/190869
Regards,
Atle
FCI, Inc. - Unix Systems Administrator
On Tue, 12 Dec 2006, Ed Pauley II wrote:
> We recently upgraded to MySQL 5.0. Since upgrading
Pretty much the only way you're going to find out is by giving it a shot.
:) I imagine it shouldn't take too much time to setup. Server and query
tuning is what will take most time, but I suspect it will be worth it in
the end.
Once you have your setup, it'd be worth explaining your data and how y
Sounds like you need to configure a user that has SHUTDOWN privileges.
From: http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html
Make sure that the MySQL account used for stopping the mysqld servers
(with the mysqladmin program) has the same username and password for each
server. Also, make
Jay, mysqld_multi will do what you want, it's a tool to help you manage
two or more mysql daemons on the same host. You can either have the two
databases bind to different IPs or same IP and different ports.
To the other replies in this thread: why wouldn't you want to have
development databases o
Jocelyn, without more information about how many queries your system has,
it's impossible to say. I do not know how MySQL calculates the
'Seconds_Behind_Master' data, but:
If your system has bursts of queries, why is the data represented
below confusing? What if inbetween your 1st and 2nd '
rite ratio where you can get by having
only one master while using multiple replicated slaves (even for really
high traffic sites).
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 4 Aug 2006, Atle Veka wrote:
> You can have a simple LVS setup running with a plugi
You can have a simple LVS setup running with a plugin from Nagios,
check_mysql, which will connect to the mysql daemon and run a status
query. If you want anything more than that you most likely will have to
write a custom check plugin (shouldn't be that hard). LVS works nicely as
a mysql loadbalan
So, you're looking at 150-300 databases and ~31-62k tables based on your
numbers? MySQL should be able to handle that, as should your OS, but the
most important part IMO is how your clients will be using their
data(bases). What sort of queries, how many, etc. Will it be possible for
one client to h
Replicating a live setup, especially one running on the web is extremely
difficult if not near impossible. Assuming you don't have the freedom to
stop/start your mysqld for tuning/tweaking, here are some things you can
do:
- Enable slow-query-log
- Enable query log
- Query processlist periodically
I assume you are referring to this thread:
http://lists.mysql.com/mysql/197528
If so, a very important question still stands: What version of MySQL are
you using?
MySQL replication uses the binary log (binlog) to pass update queries
(INSERT, UPDATE, etc) to the slave; in other words it do
On Mon, 1 May 2006, Kishore Jalleda wrote:
> On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote:
> > I ran mysqlcheck against a replication master database and it reported a
> > problem with a table, which it corrected. Is the slave now out of sync?
> > If so, how do I correct the problem without
On Fri, 28 Apr 2006, Mohammed Abdul Azeem wrote:
> Hi,
>
> I have 2 mysql servers with version 5.0.15-standard-log running on
> redhat es4 installed on 2 different geographic locations. The default
> storage engine used is innodb on both the servers. I run an insert query
> on both the servers tha
Yes, that is certainly possible and would be just the same as configuring
replication between different machines.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Thu, 20 Apr 2006, Mohammed Abdul Azeem wrote:
> Hi,
>
> Is it possible to configure a master and slave server on the same
gt; Gabriel PREDA
> Senior Web Developer
>
> On 4/7/06, Atle Veka <[EMAIL PROTECTED]> wrote:
> >
> > However, even though
> > there is plenty of free memory linux makes weird decisions from time to
> > time, temporarily killing performance, swapping in/out to
On Sat, 8 Apr 2006, Leonardus Setiabudi wrote:
> when i log into server 2 using port 3307, i can see the data in db2
> updated, which means the replication succeed (show slave status tells
> the same thing), and the same thing with server 3, i can see db3
> updated, also with server 4 where db4 up
Anyone have any experience to share about running mysql on a linux tmpfs
(using memory)?
For us it's worked out pretty well and is normally operating lightning
fast compared to an identical SCSI based system. However, even though
there is plenty of free memory linux makes weird decisions from time
Do you have control over your DELETE queries? If so, 'SET SQL_LOG_BIN=0'
would be an easy implementation.
A common approach in my experience is to have a script query the master
and archive data to a second database before any deletes are done.
If you have no control over the DELETE queries and w
Thank you MySQL Cluster, for ignoring my information request after
submitting about a year and a half ago. I was told in email that I was
supposed to be contacted, that never happened. Thank you for automatically
signing me up for all sorts of MySQL mailinglists for seminars that I do
not want to a
Do you have control over the DELETE queries? If so I would look into the
option of using 'SQL_LOG_BIN':
http://dev.mysql.com/doc/refman/5.0/en/set-option.html
SQL_LOG_BIN = {0 | 1}
If set to 0, no logging is done to the binary log for the client.
The client must have the SUPER priv
To restore specific tables (or full databases) I often use this trick (I'm
just writing this down from memory, you would want to run it through a
test environment first). It runs something like this:
1) MASTER: query> FLUSH TABLES WITH READ LOCK;
query> SHOW MASTER STATUS\G
2) SLAVE:
Hi Hiro, we have noticed severe performance loss with HT enabled under
FreeBSD but not with MySQL. However, we could be having problems with
MySQL as well without knowing as we haven't done any testing as it is
operating fine. What operating system are you running?
We now disable HT on all servers
Your subject is misleading, I would rather call this something like
Chained Replication. Unless your slaves all replicate from 'Master', in
that case your drawing is the culprit. :)
Does the error log on slave3 or slave2 indicate any problems?
Atle
-
Flying Crocodile Inc, Unix Systems Administra
To my knowledge the only way you can do this is by running 2 daemons on
the same host. You can easily do this with the 'mysqld_multi' script that
comes with mysql.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Mon, 13 Feb 2006, Rob Gormley wrote:
> Short of running two MySQL instan
No, unfortunately you cannot have multiple masters on a single replication
slave.
You can however have multiple daemons running on system (C) via
mysqld_multi.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 13 Jan 2006, Jeff wrote:
> Anyone know if it's possible to do replicat
To add a few short notes:
1) What happens when you modify data on the slave directly depends on how
you configure your setup. It is possible to have slave updates appear on
the master, that is usually referred to as circular replication. Since you
have 2 replication slaves I would advise against u
Where are your .frm files, are you not including them in your directory
listing or are they missing? If they're missing, that's most likely your
problem right there.. :)
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Wed, 4 Jan 2006, Simon Faulkner wrote:
> An old server died during
Trying to help you with your replication problems is pretty much
impossible without more information, such as: mysql versions and a more
detailed explanation of your replication setup.
I manage setups ranging from 1-14 replication slaves transmitting up to 2
gigabytes of data per day, and none of
Less optimal solution:
Create a DNS round-robin alias, say
mydatabase.myinternaldomain.com, that point to S2-4.
"Optimal" solution:
Set up a real load balancer, hardware based or software based
(http://www.linuxvirtualserver.org/), and have it configured to distribute
your connecti
Are you saying that "from time to time it happens that data gets inserted
directly to the slave"? In other words, they are NOT inserted into the
master.
Have you looked into using this mysqld option, which prevents accidental
slave updates?
--read-only Make all tables readonly, with the
Just be glad you're not stuck supporting a product that was designed about
6 years ago. "Hey, let's have each account get its own table"
[db1:~] find -L /usr/local/mysql -name \*.frm | wc -l
8116
The programmer that designed that system is now synonymous with bad
design..
Atle
-
Flying Croc
More investigation shows that the query does make it to the slave, at
least into the relay log, yet it's still ignored. 'replicate-do-db' is set
and shows the correct DB in the slave status.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Thu, 20 Oct 2005, Atle Veka
I ran into a problem on a replication setup, where if you issue the
following CREATE statement on the master the table will get created and
the query entered into the binlog, however the slave ignores it silently:
CREATE TABLE `db`.`table` (a INT DEFAULT 0)
I have duplicated this exact iss
I am planning on running some tests on a SATA server with a 3ware 9000
series RAID card to see if there's a stripe size that performs better than
the current setting (which I don't recall at the moment, probably
whatever the max is). This will be RAID10 and our databases are either in
the 500Mb or
I use this in my.cnf (along with mysqld_multi settings fwiw) and it works
great (mysql version 4.0.X):
[mysqld_safe]
timezone = GMT
It depends on how you start up mysqld.. If you don't use mysqld_safe, the
above wont work for you.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
Symlinking works fine but keep in mind an important gotcha: if you ever do
a table rebuild, mysql completely ignores your symlink and overwrites it
with the file (which may even fill up your disk).
Have you noticed these table options (from
http://dev.mysql.com/doc/mysql/en/create-table.html)?
Depends on how your table is designed. You could do an 'INSERT INTO ..
SELECT FROM ..' with a WHERE/ORDER BY/LIMIT combo (switch the ORDER BY for
each new table). It would be probably easiest if you have an
AUTO_INCREMENT field..
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 1
Here are two ways to find the queries:
1) 'SHOW FULL PROCESSLIST\G' in the mysql client and taking note of what
queries seem to be taking the most time
2) enable update logging and slow query logging
When you have gathered a list of queries that you want to look into
optimizing, run [in the clie
What type of drives to you have on your system? That is often more
important than CPU speed. My guess is that there are nightly maintenance
crons slowing down disk access.
I have never monitored replication via the seconds-behind-master function
as we do not use 4.1, so I can't speak for how accur
On Tue, 21 Jun 2005, Kevin Burton wrote:
> >Out of curiosity, how many queries are we talking and what sort of
> >complexity level? I've had replication setups do 600 (simple) updates/s
> >and slaving was current most of the time and never more than 1 second
> >behind.
> >
> >
> Mostly INSERTS.. W
On Mon, 20 Jun 2005, Kevin Burton wrote:
> We're noticing a problem where if we were to write to the master with
> multiple threads that our slave DB will fall behind.
>
> Note that we're trying to perform as many inserts as humanly possible
> and the load on the master is 1.
Out of curiosity, ho
If it works fine currently, the rule usually is: don't mess with it. :) I
would stick with MyISAM if I were you, it should be plenty good enough for
such a small table and usage as you described.
If you are experiencing performance issues, I would recommend looking at
indexes if you haven't alread
On Fri, 10 Jun 2005, Nico Alberti wrote:
> 2005/6/10, Atle Veka <[EMAIL PROTECTED]>:
> > The speed of the drive will have a lot to say on how long the queries run.
> > You haven't said anything about what type of master you have, OS, mysqld
>
> Thank you all for y
The speed of the drive will have a lot to say on how long the queries run.
You haven't said anything about what type of master you have, OS, mysqld
version, etc, but I would assume that your server is much much faster
(faster drives, more memory, faster bus, ...).
Are both your mysql daemons confi
That all depends on how you have configured your caching, but it is easy
to do.
'mysqld --help':
--query_cache_type=#
0 = OFF = Don't cache or retrieve results. 1 = ON = Cache
all results except SELECT SQL_NO_CACHE ... queries. 2 =
It's impossible to say pretty much without more information. Have you
checked the error log on the slave? How about 'SHOW SLAVE STATUS'? Did
your "backup guy" gzip all binlogs, if so that would most definitely stop
replication.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 3 Ju
SELECT ... INTO OUTFILE 'filename' export_options':
http://dev.mysql.com/doc/mysql/en/select.html
The 'export_options' are the same as this syntax:
http://dev.mysql.com/doc/mysql/en/load-data.html
That may work for you.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 17 May 200
Excellent, I'll be waiting to see performance numbers, specifically for
FreeBSD vs. Linux.
Save for a few odd machines, we're pretty much pure FreeBSD and the last
releases in the 4 branch are really impressive as far as speed and
stability. That being said, the Opteron would have to offer a prett
On Sat, 7 May 2005, Kevin Burton wrote:
> It looks like you're saying here that a single disk is FASTER than your
> RAID 10 setup.
>
> Correct?
>
> Which is interesting. I'm wondering if this is a RAID config issue. It
> just seems to make a LOT more sense that RAID 1 or 10 would be faster
> tha
On Fri, 6 May 2005, Kevin Burton wrote:
> For the record... no a loaded system what type of IO do you guys see?
> Anywhere near full disk capacity? I'm curious to see what type of IO
> people are seeing on a production/loaded mysql box.
Mostly Linux in this thread so far, so I figured I'd throw
On Fri, 29 Apr 2005 [EMAIL PROTECTED] wrote:
>
> I set up replication and it was working fine but I re-created my master
> database (droped and created empty tables) and now my replication
> doesn't work. I checked the status of master and slave and they think
> they are in sync but when I add a n
Here are two threads you might find useful:
http://lists.mysql.com/mysql/182017
http://lists.mysql.com/mysql/180889
As long as you have a thorough understanding of replication, it's not that
complicated. I would recommend searching the list for other threads,
getting a handle on replication, and a
On Mon, 25 Apr 2005, Fagyal Csongor wrote:
> Hi,
>
> I am new to replication so excuse me if my question is stupid.
>
> The manual recommends that a nice scenario to take advantage of
> replication in MySQL is to send all updating queries to the master
> server, and reading from the slave. I would
To answer the original poster of this thread, it would help if you could
post more details about what happened such as error messages and mysqld
versions. My hunch is that the binlog got corrupted and the slave choked
on it. Did you try issuing 'SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1' (omit
GLOBAL if
Sounds like this is what you want:
http://dev.mysql.com/doc/mysql/en/handler.html
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Wed, 13 Apr 2005, Homam S.A. wrote:
> Is there a way to use dirty reads (that acquire no
> read locks on the table) with MyISAM tables?
>
> I want to avoi
Here are two posts on list that you might find relevant:
http://lists.mysql.com/mysql/182017
http://lists.mysql.com/mysql/180889
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Tue, 12 Apr 2005, Luis Calero wrote:
> Hello, I've been discussing with a coworker if it's possible to
>
What version of MySQL are you using? Also, are you issuing only "GRANT .."
statements or modifying the privilege tables manually as well?
Search for 'GRANT':
http://dev.mysql.com/doc/mysql/en/replication-features.html
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 1 Apr 2005, N
On Thu, 31 Mar 2005 [EMAIL PROTECTED] wrote:
>
> We have one master and one slave database and use the slave for reads.
> If for some reason our master goes down,
> we would like to make our slave the master and use it for both writes
> and reads and then switch to the original configuration
> whe
On Tue, 29 Mar 2005, Shamim Shaik wrote:
> Can I run load data from master on myisam tables where my table size is
> approx 30G?
>
> Is there a better way to do this ?
Hi,
1) LOAD DATA FROM MASTER: From the manual:
" It acquires a global read lock on the master while taking the
snapshot,
Even if you replicate the 'mysql' DB, GRANT/REVOKE statements are not
replicated, nor are FLUSH statements. So if you are adding new access
privileges on the master they will not be active on the slave until you
issue FLUSH PRIVILEGES (one the slave).
Hope this helps. :)
Atle
-
Flying Crocodile
On Thu, 3 Mar 2005, E SA wrote:
> Hi,
>
> I am trying to obtain read/write statistics from our
> database (4.0.21). I started by using the
> Bytes_received and Bytes_sent from "show status";
> however, today one of them (Bytes_sent) reset itself
> to 0...
>
> Which really messes up my calculation
On Thu, 3 Mar 2005, Olivier Kaloudoff wrote:
> Hello,
>
> we're working on a two node setup to achieve high
> availability using 4.1.8;
>
> we first setup both servers with --bin-log, and only
> the slave server (db1) with --log-slave-updates. (binary logfile
> name is "master" on bot
On Fri, 25 Feb 2005, Chris Aitken (The Web Hub) wrote:
> Its highly possible as this is the first database ive had to use with a
> large number of records. I shall look into indexing part of databasing now.
> Any suggested places to start that explains it helpfully ?
One way to do it, would be t
On Thu, 24 Feb 2005, Chris Aitken (The Web Hub) wrote:
> Hi all,
>
> I have just created a databased website that is working with a fairly large
> number of records (well, 10 million records is the biggest database ive
> ever worked on so far) but also have a large number of searches of these
> r
On Mon, 14 Feb 2005, Eric Bergen wrote:
> My understanding is that relay-info.log stores Exec_Master_Log_Pos so
> in order to only use master.info in a snapshot you need to make sure
> that the slave is caught up when the snapshot is taken. It's common
> for the I/O thread (controls master.info a
On Mon, 14 Feb 2005, Eric Bergen wrote:
> Did you copy the relay-log.info and relay logs from the seed slave?
>
> Relay_Master_Log_file is line 3 in the relay-log.info file. This file
> is managed by the SQL thread and helps the slave keep track of what it
> has execute in the relay logs.
> http:
On Mon, 14 Feb 2005, Jeremy Cole wrote:
> AFAIK, the log file name is not known by the slave unless it either
> receives a rotate log event (go to next log) or you have started it
> against a particular log file. If you start replication "from the
> beginning" (not specifying a log file) against
Yesterday I set up 4 new MySQL 4.0.22 replication slaves on 2 FreeBSD
4.10-R machines (via mysqld_multi). We have 10 other identical slaves and
I followed the same procedure as always when seeding them. The new slaves
were working fine, however when I issued SHOW SLAVE STATUS the
Relay_Master_Log_
The easiest way, which does not need any code changes, is to set up DNS
round robin. Every time the application resolves the database domain name
it gets a "random" (I believe the nameserver just circulates the list) IP
back.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 21 Ja
Master: mysqld 3.23.58 on FreeBSD 4.10-R
Runs two masters via mysqld_multi
Rotation #1:
10x mysqld 4.0.22 on FreeBSD 4.9-R, 4.10-R
1x mysqld 4.1.8a on FreeBSD 4.10-R
Rotation #2
2x mysqld 4.0.22 on FreeBSD 4.9-R
We have had the following happen twice in the past
I have been reading and researching ways to create a failover system for
our MySQL databases that require as little intervention as possible.
However I am having trouble coming up with a way to get the system back
into a stable state after a failover has occurred and the main master has
been fixed
Doesn't look like my reply last night made it to the list, resend...
Hello Seth,
On Mon, 7 Jun 2004, Seth Brundle wrote:
> 1. The timeout is set to 5 min, because of the number of queries, there
> are a lot of unused http processes that linger with connections, and the
> only way to seeminly k
Hello Chris,
I'm not familiar with super-smack, but it's compared to Apaches 'ab' which
IMO is great for getting quick performance numbers but should in no way be
trusted compared to a real world production environment. We run probably
about 50+ dedicated mysql servers on various FreeBSD 4.X rele
I've been working off and on now for a while to try to set up a master
server containing all of the mysql privilege tables for our mysql servers.
This has turned out to be a huge pain and now I don't even know if it will
ever work. The biggest culprit is the fact that the mysql database is the
onl
I guess part of my question is:
. When did the change in the mysql code happen so that the -s switch is
added to hostname for the mysql_install_db?
. For what particular reason? :)
Thanks,
Atle
On Wed, 31 Oct 2001, Atle Veka wrote:
>
> On Wed, 31 Oct 2001, Dan Nelson wrote:
>
On Wed, 31 Oct 2001, Dan Nelson wrote:
> In the last episode (Oct 31), Atle Veka said:
> > Is there any good reason for ``mysql_install_db'' to use the -s
> > option to hostname instead of using FQDN? Every time I install mysql
> > 3.23 out of ports, it fails ru
Hi all,
Is there any good reason for ``mysql_install_db'' to use the -s option to
hostname instead of using FQDN? Every time I install mysql 3.23 out of
ports, it fails running that script and I have to edit it manually and
remove the -s option.
# grep "/bin/hostname" work/mysql-3.23.36/script
Hi All--
We have a really busy mysql 3.23 server utilizing replication which dies
on a daily basis. The mysqld process itself doesn't die, but we have
monitoring tools that notifies us saying "Can't connect to mysql [..]
(60)" (60 = Operation timed out). The largest table has over 16 million
ro
On Thu, 1 Mar 2001, Daren Cotter wrote:
> Ok, here goes...
>
> mysql> select member_id, signup_date from members order by member_id desc
> limit 410;
> +---+-+
> | member_id | signup_date |
> +---+-+
> (here's the last 20 or so rows)
> | 0120472 | 2001-0
>From the 'user' table in the 'mysql' database:
mysql> describe user;
+-+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+---+--+-+-+---+
| Host| char(6
Chris,
I *strongly* suggest you read up on SQL. You simply don't know the
difference between the most important commands :)
There shouldn't be a space in your database (and it cannot either). Please
also post what commands you're using to select your database etc. From
what you show us here, we
On Tue, 27 Feb 2001, Ron Beck wrote:
> No, it's not normal. You managed to create your database with a space
> in front. You'll probably have to delete and recreate the database.
>
This *is* normal. It's got nothing to do with the database :)
The behavior we see here is quite normal from wha
On Tue, 27 Feb 2001, Chris Hallgren wrote:
> ok here is my problem i have redhat 7 i installed mysql via the rpm and i get the
>following error
>
> mysql> select chrishallgren;
> ERROR 1054: Unknown column 'chrishallgren' in 'field list'
> mysql> select ' chrishallgren';
> ++
it would be helpful to see the last lines of your error logs.. from this
it's impossible to tell what's wrong ;)
Atle
On Tue, 27 Feb 2001, Find4u wrote:
>
>
> this is what happens
>
> [root@find4uls1 bin]# Starting mysqld daemon with databases from
> /var/lib/mysql
> 010226 13:12:22 mysql
what version of mysql are you using? AFAIK, this behavior is only
supported in 3.23.x
Atle
On Mon, 26 Feb 2001, John Tsangaris wrote:
> If I turn on auto increment and let it do it's thing and then later on
> delete a few of the entries (let's say 1, 2, 3) and the current high entry
> has an
IMO, you might as well keep them in one table. But I think that's up to
you. Choose a design method that you like and stick with it :)
Atle
On Fri, 23 Feb 2001, Nino Skilj wrote:
> The data would be 1's and 0's (on/off)
>
> Nino
>
> -Original Message-
> From: Tbone [mailto:[EMAIL PR
1 - 100 of 139 matches
Mail list logo
