I think that fastest way to get round this (mite be wrong)
is to use the binary. Then all you need to do is change the sym link!
This is a bit of a work round but should work?
Simon
- Original Message -
From: "Ross O" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 1
Is it just not the case that InnoDB table have to do more as they have more
functionality and so take more time?
Simon
- Original Message -
From: "Jiří Matějka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 10:38 AM
Subject: Speed of MyISAM vs. InnoDB
>
I hope this helps.
What table format are you using?
When did data loss happen eg. after power loss?
Yes do use the MySQL tools to repair the tables.
Also you could run the bin logs back in to MySQL so all
sql changes are run on the table again.
The other thing to think about is locking tables
Here's another hintfrom the mysql site:
http://www.mysql.com/information/presentations/presentation-oscon2000-27
19/index.html
Increase number of open files for system and for the SQL server.
(add ulimit -n # in the safe_mysqld script).
Also --
http://www.mysql.com/documentation/m
Has any one use LVM to take a snapshot in MySQL and use this to back up
data?
Simon
-Original Message-
From: Paco Martinez [mailto:[EMAIL PROTECTED]
Sent: 18 November 2003 10:00
To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED]
Subject: Re: Backup question.
Is there any problem
The main problem we are looking at is backing up the database.
We have several big tables that all need to backed so the problem is these
tables
are being use 24/7 so taking a snap shot of the database will course down
time.
We have had no problems with auto increment columns.
-Original Mes
On UNIX you need to run a creat datbase using scripts/mysql_install_db
Simon
-Original Message-
From: Larry Wasserman [mailto:[EMAIL PROTECTED]
Sent: 20 October 2003 16:30
To: [EMAIL PROTECTED]
Subject: Starting the mySQL Server
I cannot start the MySQl Server. I am running Windows XP.
CONCAT turns every this in to a string then puts them together?
LIKE is not case sensitive with string?
When is this turned in to BINARY?
What have I missed please
Simon
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTECTED]
Sent: 20 October 2003 15:38
To: [EMAIL PROTECTED]
Subj
Why would the REPLACE statement not work?
Simon
(ps mite have missed some thing if so sorry)
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: 17 October 2003 14:08
To: Mike Knox
Cc: '[EMAIL PROTECTED]'
Subject: Re: Check for data before inserting
Mike Knox wrote:
This is down to the OS. As MySQL is multy threaded its all down to SMP
support.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 16 October 2003 12:25
To: [EMAIL PROTECTED]
Subject: Parallel Processing
I've been reading the online docs and asking around
http://www.mysql.com/doc/en/SELECT.html
Look at INTO OUTFILE for what you need.
Simon
-Original Message-
From: Wang Feng [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 08:54
To: [EMAIL PROTECTED]
Subject: Newbie Q: how to send the records of a table to a file and then
print them out?
Hi
I know that there are two problems when using NFS and MySQL.
One is speed.
My question is that with a good filer like a Netapps with Gig Ethernet would
speed stop being a problem?
Two locking.
Why is this a problem? Do locks get missed when righting from the system to
the filer?
Thanks for an
Hi
The only thing I can say is that if you optimise the table often there is
less work for it to do so you table will be left locked for shorter time.
I have not looked in to this but if you use the RAID option. I don't know if
splitting the table up you could just work on one bit at a time??
As much memory as you can get you hands on (we have 4 gig).
As fast disks as you can get.
Then a good multi threading operating system (64 bit would be nice).
Simon
-Original Message-
From: mixo [mailto:[EMAIL PROTECTED]
Sent: 09 July 2003 08:58
To: [EMAIL PROTECTED]
Subject: Ideal set
Try this in mysql/bin/perror
Tells you what the error code means.
<---snip--->
> ./perror 13
Error code 13: Permission denied
<---snip--->
Simon
-Original Message-
From: Grzegorz Golofit [mailto:[EMAIL PROTECTED]
Sent: 04 June 2003 08:36
To: [EMAIL PROTECTED]
Subject: Mysqld problem
I had a go with putting a image into MySQL and it did not work.
But what I did do is put the directory and image location
"/image/smile.jpg".
This is very good way to use the index of the db and the speed of the file
structure.
Sorry if this was not what you were looking for but I hope it helps a
Hi
I am installing MySQL's supper-smack on Linux.
The problem is that it will not 'make'. It errors on two files 'die.cc' and
'gen_data.cc'.
If in add '#include ' to die.cc and '#include ' to
gen_data.cc in will 'make' and 'make install'.
But then will not work. It runs with out any errors but ther
The table type HEAP is in MEMORY table so if you turn off or cash you loss
your data.
The up side is speed.
Try table type = MyISAM
Simon
-Original Message-
From: Fernando Morais [mailto:[EMAIL PROTECTED]
Sent: 25 February 2003 13:43
To: Simon Green
Subject: Re: Newbie question...
Well
No this is not right.
How are you creating the tables?
How are you entering the data?
Where are you putting them? e.g. /mysql/var/your_table.frm
What type of table are you using?
Simon
-Original Message-
From: Fernando Morais [mailto:[EMAIL PROTECTED]
Sent: 25 February 2003 13:29
To: [EMAI
Hi Richard
What we do is use Master Slave set-up on MySQL.
So the Master dose all the work and the slave is like a host standby that we
do backups from.
We use Heartbeat (HA project) with all requests going to one IP.
As soon as MySQL fails on box one the IP address is past to the slave.
Another sy
show tables from databasename;
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 17 February 2003 16:11
To: [EMAIL PROTECTED]
Subject: Checking existence of a table.
What query would I use to check for an existence of a table within a
database? I'm curre
Put the error number in to perror in ../mysql/bin
It will then tell you what the error is about.
<---snip--->
/usr/local/mysql/bin$ ./perror 13
Error code 13: Permission denied
<---snip--->
This is an operating system error.
Simon
-Original Message-
From: wiley [mailto:[EMAIL PROTECTED
The fastest way would be to use C.
But the reason for using a DB would be.
1. Access to data. You could use PhPMyAdmin or some thing you put together
to update the policy so making managing the data easy (possibly so non
tickers should make changes).
2. If the data you are getting needs to be retri
Did the update work?
I would expect it did and is just reported that you have not added or taken
away any rows.
Simon
-Original Message-
From: Daniele Lo Re [mailto:[EMAIL PROTECTED]]
Sent: 28 January 2003 14:24
To: [EMAIL PROTECTED]
Subject: SELECT & UPDATE
Hi everybody.
I got a really
There are two ways I use to dynamic backup.
One lock table can copy it. Use some think like hotcopy. The only down side
can be that if the table is very big the lock can queue two may questions.
The other way it to use replication can make the backup from the slave.
If it is taking up to an hour
Hi
I have two questions about replication on MySQL.
One: How far behind can a SLAVE get on reading the BIN log before not being
able to catch up?
My SLAVE was off for 4 days and it just seams as if it can not catch up.
Two: On SHOW SLAVE STATUS one of the fields in called Skip_conunter. Due to
an
In the first statement you are selecting * (ALL the row) from tbl1 with no
restricting comment (e.g. where) so if you are going to select every thing
in the table you do not need to use the index (MySQL uses B-tree).
Simon
-Original Message-
From: Prasanth Krishna [mailto:[EMAIL PROTECTED
The error that you have is normally that MySQL in not running.
If it is running then MySQL client can not find the sock file.
I should not think you will have to reinstall.
Simon
-Original Message-
From: Daniel Florian [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 13:11
To: [EMAIL PROTE
Use table type =Innodb for foreing keys and transacionts...etc
and type =myisam for speed
Simon
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]]
Sent: 14 January 2003 10:20
To: MySQL
Subject: Foreign keys
HI all,
I've read the following text in a book:
ANSI SQL supp
Hi Andy
Is MySQL loading the tables in to memory?
MySQL AB say running MySQL on 64bit system should be faster.
Sorry I can not be more help.
Simon
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 15:34
To: [EMAIL PROTECTED]
Subject: Solaris Performance
I know this is a emotive subject but PLEASE drop it from the MySQL list.
Thanks
Simon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
It is up to you, but for a guide have a look at what MySQL training cover
and if you know that then you are up to speed?
Simon
-Original Message-
From: Jeff Snoxell [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2003 09:25
To: [EMAIL PROTECTED]
Subject: When is learning chargeable to a client
What we have done it right a small script:
It logs on to the MySQL server.
It then locks the databases and tables we have put in a config file.
Simply copies the data files to a new directory.
Unlocks the tables.
Once this is done (copy if fast) you can tar or zip up the copied files.
Simon
---
ALTER TABLE
Simon
-Original Message-
From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 16:30
To: [EMAIL PROTECTED]
Subject: column name
Hi all,
I guess it's a dumb question for you guys, but MySql manual doesn't seem to
offer newbies a great deal of help on this
Have you looked if there is a problem with page0page.c ?
Simon
-Original Message-
From: Ervin Gerke [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 12:07
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: InnoDB crash?
Got this one after a power failure.
My system is Redhat 7.3, ker
There is data in the logs. So you mite be able you use them to recreate the
data?
Simon
-Original Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: 09 December 2002 09:05
To: MySQL
Subject: total idiot
Okay,
Let's just say I made a stupid mistake, and deleted an entire table
:46
To: Helmut Apfelholz
Cc: [EMAIL PROTECTED]
Subject: RE: Serwer Hardware p4 or pIII ?
On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote:
> --- Simon Green <[EMAIL PROTECTED]> wrote:
> > MySQL uses memory and HDD the most and so processor
> > speed is not so
> > impo
Once server 1 is down you should be able to set server 2 master and then
point dns to server 2 and all should be good for server 1 to come back as
slave.
If you did not set server 2 as slave it would still work as a master the
only problem is how to point the questions to server 2! Dynamic DNS?
Si
MySQL uses memory and HDD the most and so processor speed is not so
important.
So I would go with what ever costs me the less.
Also how you OS works with the processors will be important.
What OS are you going to got for?
Threads and OS limits will also play a big part with speed.
Simon
-Orig
A LONGBLOB can store 4294967295 bytes
A LONGTEXT can srote 4294967295 bytes
Simon Green
-Original Message-
From: Grant Cooper [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 11:20
To: [EMAIL PROTECTED]
Subject: MYSQL and large fields
We have switched over from Microsoft Access to
See Notes
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 02 December 2002 14:01
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Error in SELECT
Hi,
I have the following statement that is causing a syntax error:
sLearnerSQL = "
SELECT *
>From LearnerDetai
Not out of the box.
You would have to right some code to do this.
The best way to do this is get every one who rights code to set up to hosts
at the top of there code.
Simon
-Original Message-
From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 09:48
To: Jon Frisby
C
pp
p
Look like you need a 'p' :-)
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett@;bard.edu]
Sent: 13 November 2002 16:28
To: MySQL Mailinglist
Subject: setting passwd?
after install binary mysql 3.23.49: must be something obvious but i'm
missing it - how come i can't
3.23.55 Production
4.2.2 is ALPHA
4.0.4 is BETA
So if you are runing a production server go for 3.*
If you can risk it go for 4.0.4 (should be ok)
and if you want to have some fun 4.2.2
Simon
-Original Message-
From: P. Fawcett [mailto:fawcett@;bard.edu]
Sent: 13 November 2002 16:05
To: [
For speed multiple or single database makes no difference.
For SQL I would stick with one if all the data is related.
Index any thing you are going to select on. So if you have a user database
you would index name and password not there age and job title.
Simon
- Original Message -
From:
select * from table_name limit 1;
or limit 2,1;
I hope this helps a bit?
Simon
-Original Message-
From: Beauford [mailto:beauford.2003@;rogers.com]
Sent: 12 November 2002 15:04
To: [EMAIL PROTECTED]
Subject: Scrolling Databases
Hi,
I have created a contact database using Mysql and want
See links form mail list.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
http://jeremy.zawodny.com/blog/archives/000264.html#000264
Simon
-Original Message-
From: Bogdan TARU [mailto:bgd@;icomag.de]
Sent: 07 November 2002 10:35
To: [EMAIL PROTECTED]
Subject: MySQL CPU
I like FreeBSD so it pains me to say it but the penguin has it.
As threads are so important to MySQL Linux it just better at this at the
moment (we will see what happens with V5 FreeBSD).
MySQL was developed on Suns Slowlaris so it is a bit more native to Linux...
Simon
PS the devil will be back :-
One we know how much data we are going to store we can calculate HDD size.
Then we look at the types of question we are going to use on the DB and
combined with the size of data we now know how mush memory we should need.
But how do I know what CPU I will need to run this?
I know we need to look a
How much CPU per mysqld_multi user would be needed?
I work for an ISP and would like to give 100 users a mysqld each
How do a calculate the CPU's I would need?
Thanks
Simon
Hoping to give MySQL to all?
-
Before posting, plea
Hi
I am putting together a MySQL server for the ISP I work for. We are going to
provide a mysqld for each web user.
I plan on using mysqld_multi for this. But what I can not work out is how
much CPU and memory I will need for each user.
As this is a generic system all I need is a average system!
It looks like you have a dynamic IP your end and the mysql server is looking
for a fixed IP.
Try name based DNS form your PC.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:manuvi@;eth.net]
Sent: 18 October 2002 09:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Urgent
ESCAPE
Mite help...?
Simon
MySQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To un
OK two thinks to lookat
1. Use GRANTS as you will not have so much truble with them
2. Use "mysqlaccess" this will tell you if you have got the privileges
right..
If a user can select in 'user' table then he can do so on all databases.
(what ever is set in 'db')
If a user can select in 'db'
I can do a bit.
set-variable= max_user_connections = 100
set-variable= max_connections = 500
So if you change max_connections to = 1000.
Then set max_user_ connections to the max you what any one IP/host/user to
have this will help.
The number of simultaneous connections will also
SELECT INTO TABLE!
Simon
-Original Message-
From: Insanely Great [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 06:31
To: Scott Pippin; [EMAIL PROTECTED]
Subject: Re: copy one database to another
Greetings...
I dont think that there is any SQL statement to do that.
As of changing th
The file you are looking for is my-huge.cnf, my-large.cnf, my-medium.cnf,
ny-small.cnf.
Should be under /mysql/share/
Copy to /etc/ and edit for you needs.
Simon
-Original Message-
From: Perumal [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 06:23
To: [EMAIL PROTECTED]
Subject: I co
If it on the same system just stop the old mysqld and stat the new one
pointing at the same mysql/var/.
OR copy the table across useing cp or mv...it should just work (did for
me)...
This is all unless you are useing a new table format but you could use ALTER
TABEL TYPE..
Simon
-Original
Sets number of connectons per user/host
set-variable= max_user_connections = 100
Sets total number of connections.
set-variable= max_connections = 500
Also see number of threads for FreeBSD at www.FreeBSD.org
Also in MySQL log on and do a "show processlist" and see how many
connocetons y
Too many connections
Is the message you get when all are used up. The limit is about 1000 (Linux)
but can be set higher.
With MySQL you can set a limit for each user. So I would set this to say 100
for each user and 1000 in total.
What courses this is pconnects or threads that will not drop. If yo
Have a look at
http://www.mysql.com/doc/B/L/BLOB.html
Simon
-Original Message-
From: Khanh Pham [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2002 09:59
To: [EMAIL PROTECTED]
Subject: Save Image (GIF or JPEG) file in the database ?
Hello ladies & gents,
I am new to MySQL. I wonder if
There is one.
Go to http://www.mysql.com/newsletter/
Simon
-Original Message-
From: Bart Burkhardt [mailto:[EMAIL PROTECTED]]
Sent: 30 July 2002 10:12
To: [EMAIL PROTECTED]
Subject: a newserver would be better than this mailing list
hello list,
i think it would be better to have a mysq
What I am trying to do in MySQL.
Table1
UserID ProductID Old_UserID
1 2 4
2 3 5
Table2
UserID ProductID
4 Null
5 Null
Table1 has new correct data.
Table2 has old incorrect data.
The link is Table2.UserID and Old_UserID
What I
by me is careware. This means that it can only be reread and
kept if you are good for all the life here on earth and beyond. If you don't
agree to these terms, you should return this email in no more than 24 hours
stating the reason of disagreement.
-Oorspronkelijk bericht-
Van: Simon
> Hi All
> I am trying to copy data from one table to another using in MySQL
> INSERT INTO table1
> SELECT table2
> statment but I would like to add some fixed values to this and so some
> thing like.
> INSERT INTO table1
> SELECT table2
> VALUES ('A','B');
> But I can not find if this can be d
Hi All
Some thing that is a bit lighter
Where can I get a MySQL Tee Shirt?
We now have a FreeBSD devil and a Linux Penguinin my department
All I would like it a Dolphin to keep up!
Simon
-
Before posting,
Hi Ken
I have had a look on FreeBSD.org and can only find a ref to polling as a
subroutine that is used if the system crashing.
What douse this number?
And so how will it effect MySQL?
Thanks
Simon
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: 16 July 2002 16:07
To
RAID --with-raid splits tables up to stop size problems or put one table on
more than one disk.
So is not required for hardware raid.
Simon
-Original Message-
From: Ismael Touama [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2002 10:26
To: [EMAIL PROTECTED]
Subject: RAID
Hi,
This is my fir
are just not it one column?
Thanks
Simon
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: 27 June 2002 05:00
To: Simon Green; Mysql (E-mail)
Subject: Re: Cartesian Product
At 13:22 +0100 6/26/02, Simon Green wrote:
>Hi
>When I run my MySQL question I get what I
Hi
When I run my MySQL question I get what I think is a cartesian product?
SELECT table1,Username
FROM table1, table2
WHERE table1.Username != table2.Username;
If I just run'=' then no problem but it seems to what to match every thing
with every thing
and so I run out of memory.
Is there a way
> Hi
> When I run my MySQL question I get what I think is a cartesian product?
>
> SELECT table1,Username
> FROM table1, table2
> WHERE table1.Username != table2.Username;
>
> If I just run'=' then no problem but it seems to what to match every thing
> with every thing
> and so I run out of mem
Thanks for this...
So I think I need some joins!
Simon
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]]
Sent: 24 June 2002 12:19
To: Mysql (E-mail)
Cc: Simon Green
Subject: Re: Out of memory on simple question.
* Simon Green
> After running this simple questio
Hi
After running this simple question I get this error. I have looked at the
my.cnf file and all looks fine and the system has 1.256 G of memory.
Can some one please tell me where I have gone wrong.
select in_names.Username
from in_names, in_names2
where in_names.Username != in_names2.Username
We are ruing a box with freeBSD and MySQL with twin processors
It looked like it was using only on processor but we decided that it was the
way FreeBSD's threads work?
There seems to be two problems with ruing MySQL on FreeBSD.
One: Seems not to use both processors (on twin system)
Two: All wa
GRANT ALL ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123';
TO
Simon
-Original Message-
From: Kaan Oglakci [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2002 09:05
To: '[EMAIL PROTECTED]'
Subject: GRANTs and %
Thanks Dan And Okan for replying to my email but I have tried what you ha
What happend when you ran scripts/mysql_install_db ?
Also when you run the databases with --skip-grant-tables as soon as you
grant a user acess and flush privileges it will then use the grant tables (I
think)..
Simon
-Original Message-
From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
Se
There are two ways to do this.
One open a hole in the firewall.
Two put a second Ethernet card in each system and use this for BIN updates.
Simon
-Original Message-
From: Agris [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2002 09:17
To: [EMAIL PROTECTED]
Subject: Mirroring / synchronizing two
ALTER TABLE tablename CHANGE oldname newname VARCHAR(40)
Simon
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2002 15:37
To: MySql Mail List
Subject: changing column name
Hi
Can anyone plz give me the query for chaning the column name of an existing
table
You have to look a bit more.
There is lots about runing MySQL on windows.
It also will not get the MS SQL worm that is about
So just have a nother look it will be woth it.
Simon
PS start..
http://www.mysql.com/doc/W/i/Windows_installation.html
-Original Message-
From: Inbal
wait_timeout
8 hours as standard
Simon
-Original Message-
From: Anatol Mayr / HEXAGON [mailto:[EMAIL PROTECTED]]
Sent: 28 May 2002 09:26
To: [EMAIL PROTECTED]
Subject: killing mysql-threads?
Is it possible to set a variable to kill mysql-threads which sleeps for a
time e.g. 5 hours?
Wh
Re Gunnar Helliesen e-mail
I have FreeBSD4.2 and MySQL 3.23.49.
I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
After making the suggested changes to my.cnf we rebooted the system.
For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%.
Has any body know why FreeBSD wit
Sounds about right.
How have you got your my.cnf set?
Have you got RAID on you HDD?
Simon
-Original Message-
From: Florian Wilken [mailto:[EMAIL PROTECTED]]
Sent: 23 May 2002 10:17
To: [EMAIL PROTECTED]
Subject: MySQL Query Speed
Hello
our database consists of one table with approx. 15
Hi
We using FreeBSD 4.5 and MySQL 3.23.49 with native threads...
It uses a lot of CPU and mite not be using both CPU's?
So we have seen that compiling with Linux threads can help
Do with just ./configure --with-named-threads-libs=???
What is the complete statement?
And do we need to put an
If you are ruing as user mysql do
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql
Change to sute tast (or what you database is)
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 13:51
Look in db mysql.user to see what users can do what.
GRANT ALL ON *.* TO user@% IDENTIFIED BY "password";
Simon
-Original Message-
From: Unix Newbie [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 10:15
To: [EMAIL PROTECTED]
Subject: Mysql users setup.
Hello all!
I am just starti
I think this is some thing that should be in on V4.1...
Have a look at things to do on the site
Simon
-Original Message-
From: Uma Shankari T. [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 08:28
To: [EMAIL PROTECTED]
Subject: Triggers
Hello All,
Is Mysql supports sql trigger
> Hi List
> I know super-smack was writing for Linux but I am trying to get it to work
> on FreeBSD.
> Has any one done this or is there a another many threaded bench mark
> software out there for MySQL ?
>
> Thanks
> Simon
-
B
I am trying to compile super-smack on a FreeBSD-4 systems.
I have got some thing working but it sill not right.
Running it gives me.
%super-smack -d mysql select-key-mysql.smack 10 1000
super-smack: Unsupported database type
Is my copy just broken?
If so what is the best way to compile on Fr
not connect to mysql:
<---snip--->
Simon Green
Internet Systems Engineer
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential
Would you not be better of just runing myisamchk from crontab?
Simon
./myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386
By Monty, for your professional use
This software comes with NO WARRANTY: see the PUBLIC for details.
Description, check and repair of ISAM tables.
Used without options
have got a backup script that locks the MySQL tables then use cp to copy
the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live Life
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
I have got a backup script that locks the MySQL tables then use cp(unix) to
copy the tables.
It then tar, then zips them up.
So my queston is what is the minimum privileges that this MySQL back user
needs just to lock tables?
Thanks
Simon Green
--
Live
usr/local/mysql/bin/safe_mysqld --user = mysql &
or ./safe_mysqld --user = mysql &
Have a look at /mysql/bin/var/hostname.err.log
Hope this helps
Simon
-Original Message-
From: Hammer [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 10:19
To: [EMAIL PROTECTED]
Subject: How to start the My
We have a problem with other system..
When a service that uses the MySQL database loops and so creates to many
connects to the DB it uses up all the available connections. So we have DOS
from aware own server.
I know that we can limit the connections used over 1 hour but I need to set
a max co
We have a problem with other system..
When a service that uses the MySQL database loops and so creates to many
connects to the DB it uses up all the available connections. So we have DOS
from aware own server.
I know that we can limit the connections used over 1 hour but I need to set
a max co
Yes and no
If you are taking info from a live database you would have it in a steady
state to copy it. This means locking the tables.
But once you have a copy of the table all you would need to do is update the
changes from the logs.
Using replication for this I is the most simple way but wo
We asked on the MySQL training last year and were told that this is a manual
job...
Just have to delete entree for each table.
Unless some one else knows different?
Simon
-Original Message-
From: Steve Wright [mailto:[EMAIL PROTECTED]]
Sent: 18 March 2002 16:52
To: [EMAIL PROTECTED]
Sub
Hi All
Do any of you use SSL option in MySQL and if so are there and performance
problems when connecting to MySQL?
Thanks
Simon Green
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person or entity to
1 - 100 of 214 matches
Mail list logo
