ld. For starting with MySQL, you don't need
MySQL-Debug
>
>
> Varuna
>
Greetings from Germany,
Steven
P.S.: Why you don't use XAMPP? Especially for beginners is the clearly
better choice, since much is already preset.
--
MySQL General Mailing List
For list archives: htt
ct, I wanted no discussion on the pros and reignite XAMPP. I just
wanted to help. ;-)
> Viel Gluck!
> Martin
Good Luck? What for?
Greetings,
Steven
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nd logging at the time of the incident was 14314, way
beyond 8648.
At this point I'm lost on what to do, any help would be appreciated.
-Steven
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
teps I can take to trouble shoot this
or I would be grateful.
-Steven
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the server with phpMyAdmin the newly created
database doesn't show up.
Only the test database created by the install_db script shows up. What
could I be doing wrong? Please cure me of my ignorance... Thanks,
Steven
This is a text part of the message.
It is shown for the users of old-style e-mail clients
Does anyone know if there are plans to add support for JDBC 4.0 to the java
connector? I'm particularly interested in support for the
Connection.createQueryObject(Class cls) method.
Thanks.
Steve Buroff
checking for mysql_init in -lmysqlclient... yes
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
-
Original Message-
From: Steven Altsman [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 11:37 AM
To: 'mysql@lists.mysql.com'
Subject: Using MySQL libraries for a client app
checking for mysql_init i
Has anyone here successfully managed to install mysql
4.1.15 on a RedHat 7.3 box? RedHat 7.3 seems to be
using
the glibc 2.2.5 libraries and mysql seems to insist on
using glibc 2.3. Am I out of luck?
__
Yahoo! Mail - PC Magazine Edit
Ok, I just saw a post about using view's in mysql. I tried to look it up
and found how to use it, but my question is: what is a view and why would
you use it? Is it like a temporary table? Does it write a new database to
the disk or use memory?
Thanks
Steve
> -Original Message-
> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> Behalf Of Baron Schwartz
> Sent: Monday, February 09, 2009 9:19 AM
> To: Steven Buehler
> Cc: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009
that sound
correct?
Thanks
Steve
From: Martin Gainty [mailto:mgai...@hotmail.com]
Sent: Monday, February 09, 2009 11:26 AM
To: Steven Buehler; ba...@xaprb.com
Cc: mysql@lists.mysql.com
Subject: RE: MySQL View
My current understanding of the delta between Views and Temporary Tables
View
Steve
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Monday, February 09, 2009 3:59 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: Re: MySQL View
Steven,
I would suggest you the reading of a basic book about SQL and Databases, I
explain you why.
Views are a very fundam
> -Original Message-
> From: Jochem van Dieten [mailto:joch...@gmail.com]
> Sent: Tuesday, February 10, 2009 5:10 AM
> To: mysql@lists.mysql.com
> Subject: Re: MySQL View
>
> On Mon, Feb 9, 2009 at 3:41 PM, Steven Buehler wrote:
> > Ok, I just saw a post abou
created, my php app adds the username/customerid to that
server, then makes a connection to the logging server and creates the same
record, same with deleting and updating... but there just has to be a
simpler way :)
Thanks in advance.
Steven Staples
--
MySQL General Mailing List
For list
it before, but I guess my searching keywords were
insufficient ;)
Steven Staples
-Original Message-
From: harrison.f...@sun.com [mailto:harrison.f...@sun.com]
Sent: December 9, 2009 2:07 PM
To: Johan De Meersman
Cc: Neil Aggarwal; Steven Staples; mysql@lists.mysql.com
Subject: Re: S
what I am needing now)
Steven Staples
-Original Message-
From: Michael Dykman [mailto:mdyk...@gmail.com]
Sent: December 11, 2009 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: Stored Proc's
of course. you can have entries
u...@domain1.me.com
u...@xxx.foo.com
the only caveat is t
t.ProdID = p.ID
;
<-- end -->
I didn't run this, or try to replicate it, it was just my observation on the
query.
Steven Staples
-Original Message-
From: Victor Subervi [mailto:victorsube...@gmail.com]
Sent: December 14, 2009 11:26 AM
To: mysql@lists.mysql.com
Subject: Joi
t increase performance if this
was a large database? If so, could I just
symlink the test/ directory to another raid array to increase performance?
Or would the increase be negligible?
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Good morning!
I have been struggleing with creating a store procedure, that will allow 2
users
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
lhost`) PROCEDURE
`sstest`()
.
CREATE definer=`use...@`%` OR definer=`sstapl...@`localhost` PROCEDURE
`sstest`()
.
CREATE definer=`use...@`%` definer=`sstapl...@`localhost` PROCEDURE
`sstest`()
I can't think how it would be possible? Or is it?
Steve
-Original Message-----
Fr
ql. We're getting an error now. Apparently one of
the tables is out of sync now? What appears to have happened, is that when
the slave was down, i truncated a table on the master.
I've read that this sometimes causes errors, is this a bug? Or a is there
something I should do different
te on the master, where ID <
XXXX.
Steven Staples
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: March 5, 2010 1:11 PM
To: Steven Staples
Cc: mysql@lists.mysql.com
Subject: Re: Master/Slave - trucate master table
Does START SLAVE fail?
If so, what is th
i will just delete from the table
where the ID < and then reset the ID to 0 or 1... and then delete
everything from and beyond
I was just wondering if this was a bug, or if there was something wrong with
what I did?
Steven Staples
-Original Message-
From: Ananda Kumar [mail
shoulnd't even be an i/o or cpu issue.
Please help! :)
Thanks in advance
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
details?
Also, when i would do a select, if i wanted say d02f1, would it load the
entire row first, and then just give me that field?
-Select `d02f01` from `mytable` where [where clause]
Or would it jsut load that field...
Does these questions make sense? (they do in my head)
Steven Staples
ysql site:
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_grou
p-concat
SET [GLOBAL | SESSION] group_concat_max_len = val;
Steven Staples
> -Original Message-
> From: kalin m [mailto:ka...@el.net]
> Sent: April 7, 2010 12:59 PM
> To: Nathan Sullivan
> Cc: m
, when I do my "JOIN"s, I tend to write "ON
(table1.field=jointable.field)" rather than just "ON (field)".
And on a final thought, the where cause, seems to be the join clause as
well, so isn't that redundant? (or is would that only be in the way that i
said i do
(`datefield`);
(this was just taken off the top of my head, but it should give something
that you're looking for... hopefully ;) )
Steven Staples
> -Original Message-
> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
> Behalf Of Baron Schwartz
> Sent: A
If you wanted to use/go that route, then why not select a random limit 1
from that table, and then delete that row?
SELECT `column` FROM `table` ORDER BY RAND() LIMIT 1;
On a side note, I would use the auto-inc field still, and store this number
in another field.
Steven Staples
I am doing wrong? I can't seem to see anything wrong.
Also, upgrading from 5.0.32 would require upgrading both the master and
slave, and right now, that is not a good idea (we are discussing it though)
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
irst_table`.`progress` > 0;
Granted, you have not provided structure or names of the tables so this is
just my interpretation, but maybe something like this could give you a
starting point?
Steven Staples
> -Original Message-
> From: Michael Stroh [mailto:st...@astroh.org]
> Se
I am glad that I was able to help someone finally :)
There may be other ways to do this, but that was what first came to mind.
I would maybe run an explain on that query to ensure that it is using
indexes.
Steven Staples
> -Original Message-
> From: Michael Stroh [mai
RE pnum LIKE
'555-12%';
It gives me this error:
Error Code : 1054
Unknown column 'pnum' in 'where clause'
Any ideas?
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Putting the 'HAVING' in there, works perfectly :)
THANKS!
Steven Staples
> -Original Message-
> From: SHAWN L.GREEN [mailto:shawn.l.gr...@oracle.com]
> Sent: June 10, 2010 8:03 PM
> To: Steven Staples
> Cc: 'MySql'
> Subject: Re: WHERE clause fr
replicating 3 other servers). So, all the sql databases will have to
be updated/upgraded, but is there anything I/we should be made aware of
before we go ahead? (there is a lot of release notes to sift through)
Steven Staples
> -Original Message-
> From: baron.schwa...@gma
that would be ideal.
Thanks in advance,
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
s to run all weekend long...
Can I just kill it, or will it corrupt the table it is currently on?
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Nevermind, it just finished... holy uggh!
Steven Staples
> -Original Message-
> From: Steven Staples [mailto:sstap...@mnsi.net]
> Sent: June 18, 2010 2:31 PM
> To: mysql@lists.mysql.com
> Subject: analyze table issue
>
> Ok, I know I am an idiot sometimes, and I
and the 5.1.47)?granted, this is not the debian mailing list, just
thought I would ask that last part ;)
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
y projects I am working on, where I've done this, but done it in
code, rather than in mysql.
Steven Staples
> -Original Message-
> From: Dušan Pavlica [mailto:pavl...@unidataz.cz]
> Sent: June 29, 2010 11:26 AM
> To: Victor Subervi
> Cc: mysql@lists.mysql.com
>
mmand line, just incase you're
locked out of it somehow, or if you need to repair, backup or create users.
But if you're a windoze user, 99% of them don't know what a command line is
:)
Steven Staples
> -Original Message-
> From: Krishna Chandra Prajapati [mailto:prajap
take care of the mysql as well?
Steven Staples
> -Original Message-
> From: alba.albetti [mailto:alba.albe...@libero.it]
> Sent: July 15, 2010 10:00 AM
> To: mysql
> Subject: Why is MySQL always linked to Php?
>
> Browsing the Web I've seen that usuall
FLOOR() CEIL() or ROUND()
SELECT ROUND(1+1.6, 0);
= 3
SELECT FLOOR(1+1.6);
= 2
SELECT CEIL(1+1.6);
= 3
Steven Staples
> -Original Message-
> From: Ashley M. Kirchner [mailto:ash...@pcraft.com]
> Sent: July 20, 2010 1:52 PM
> To: mysql@lists.mysql.com
> Subject: Re: [MyS
cause of the problem, before
adding to it.
Steven Staples
> -Original Message-
> From: Nunzio Daveri [mailto:nunziodav...@yahoo.com]
> Sent: August 4, 2010 2:40 PM
> To: mysql@lists.mysql.com
> Subject: Moving from one MySQL server to three MySQL servers?
>
> Hel
I am not too good with charting (even though I would like to be), but what
about getting the max, min and avg, if the max/min is greater than x% of the
avg, show that... ?
Just throwing out ideas... prolly not useful... but may cause a better idea ;)
Steven Staples
> -Original Mess
On another thought, what about if you group it by whatever, if the MIN()/MAX()
is greater than X times STDDEV(), show MIN() or MAX() ?
I just recalled a conversation with my boss the other week about the STDDEV()
Steven Staples
> -Original Message-
> From: Steven S
I am hoping that I can do this with one query, I have a table, "Domains"
with 3 columns
accountID, domainID, mailname
what I am trying to do is find all accountID's for "domainID" of 12345 and
see if a second row with "domainID" of 54321 exists for that
"accountID,mailname". If it doesn't exis
DATE_ADD(NOW(), INTERVAL 1 DAY) will give you tomorrow...
Not sure if that is what you're looking for or not...
Steven Staples
> -Original Message-
> From: Eric Bloomquist [mailto:eric_bloomqu...@cooley-dickinson.org]
> Sent: August 27, 2010 12:17 PM
> To: mysq
Good morning list,
I am having issues with my replication setup. it seems that every few
weeks/months something happens, and I have to restart it, skip a row, or
delete, rsync and restart replication from scratch.
The databases that are being replicated, are rather large... there are about
12 new
you
-
> memory tables as example are making much more troubles as myisam
>
> Am 10.11.2011 14:26, schrieb Steven Staples:
> > Good morning list,
> >
> > I am having issues with my replication setup. it seems that every few
> > weeks/months something happens, and
ll() command instead, but I would rather avoid that if
at all possible.
Thanks in advance!
Steven Staples
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
> -Original Message-
> From: Peter Brawley [mailto:peter.braw...@earthlink.net]
> Sent: February 22, 2012 11:07 AM
> To: Steven Staples; mysql@lists.mysql.com
> Subject: Re: MySQL Session Variables with PHP
>
> On 2/22/2012 9:47 AM, Steven Staples wrote:
> > Go
Hello!
I am trying to do something, but I can't seem to figure out how...
My query is as follows:
SELECT `user_id`, GROUP_CONCAT(DISTINCT `login_ip`) AS 'login_ips',
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP
> -Original Message-
> From: Mihail Manolov [mailto:mihail.mano...@liquidation.com]
> Sent: March 19, 2012 12:44 PM
> To: Steven Staples
> Cc:
> Subject: Re: Group_Concat help...
>
> Try this
>
> SELECT `user_id`, `login_ip`,
> COUNT(`id`) AS 'co
> AFAIK the tables will be locked one by one until checked/repaired.
>
> On May 10, 2012, at 3:07 PM, Adrian Fita wrote:
>
> > On 10/05/12 21:51, Mihail Manolov wrote:
> >> You can enable check/recovery automatically by using
> >> "myisam_recover". Look it up in the documentation.
> >>
> >> There
> -Original Message-
> From: Andrés Tello [mailto:mr.crip...@gmail.com]
> Sent: May 12, 2012 10:08 AM
> To: mysql
> Subject: Mysql is toying me... why sometimes an insert or update can be
> slow!? I getting bald cuz this
>
> While doning a batch process...
>
> show full processlist show:
> -Original Message-
> From: Rick James [mailto:rja...@yahoo-inc.com]
> Sent: September 17, 2012 3:04 PM
> To: peter.braw...@earthlink.net; mysql@lists.mysql.com
> Subject: RE: function INTERVAL in view
>
> INTERVAL is a keyword. This is probably the root of the hiccup.
> Is that your Sto
> -Original Message-
> From: ratlhaga...@yahoo.com [mailto:ratlhaga...@yahoo.com]
> Sent: September 18, 2012 7:31 AM
> To: mysql@lists.mysql.com
> Subject: [Possible Spam]Php programmer
>
> Hi,
>
> I need help, I'm working on a project that need time query in Mysql. I
want
> to display a
Hello all,
I've looked though, what I believe to be, the relevant areas in the MySQL
docs as well as standard search engine searches without luck. I was
hoping to find some documentation that would tell me:
- how MySQL session Ids are generated (specifically, are they considered
"random")
- do
rather than just reconnect using the session ID from the "dropped"
connection?
I apologize about these basic mysql-mechanics questions - I need to satisfy
our auditors, so I need to understand =)
Thanks,
S
On Fri, Jun 21, 2013 at 7:13 AM, Hartmut Holzgraefe wrote:
> On 21.06.2013
sightful and quite helpful responses.
S
On Fri, Jun 21, 2013 at 7:58 AM, Denis Jedig wrote:
> Steven,
>
> Am 21.06.2013 13:35, schrieb Steven Siebert:
>
>
> If the TCP connection is lost...is the effectively session over and
>> can not be re-established on another soc
they come in. I suspect,
> however, that you're looking for session IDs as used by websites
> -generation of those is entirely not a mysql issue, it is only a potential
> store for them.
>
>
> Steven Siebert wrote:
>>
>> Hello all,
>>
>> I've looked tho
Hi Larry,
I'm trying to figure out what your wanting to do with the data once its in
mysql? At first it seemed you didn't want to put it in as a lob because
you might want to query on the data in different ways (kind of an
assumption on my part, but a common reason to do this). Then, you thought
#x27;s own benefits and downsides; nothing prevents you from taking any
> or all of those approaches at the same time.
>
>
> - Original Message -
> > From: "Larry Martell"
> > To: "Steven Siebert"
> > Cc: "mysql mailing list"
>
> -Original Message-
> From: Artem Kuchin [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 07, 2007 4:35 AM
> To: mysql@lists.mysql.com
> Subject: How to auto repair db on hosting with quota
>
> I am asking this question as a hosting PROVIDER, not
> as a hosting client.
>
> The sitation
I have a column in a table that was turned into an cp1251_general_ci
for a type of encryption. Question is, how do I unencrypt it?
Thanks
Steve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a query that I just can't seem to get working.
insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id) (select
'36',game_date,begin_time,loc_id,home_team_id,away_team_id,(select div_id
from team_season where team_id=s1.div_id) from scheduler s1);
Of course, I am getting the d
Thank you, but I still get an error and I can't figure it out: " Unknown
column 's1.div_id' in 'on clause'"
Any other thoughts?
Steve
-Original Message-
From: Andy Shellam [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 16, 2008 9:40 AM
To: Steve
Thank you, but I still get an error and I can't figure it out: " Unknown
column 's1.div_id' in 'on clause'"
Any other thoughts?
Steve
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 16, 2008 9:50 AM
To: And
l
Steve
-Original Message-
From: Andy Shellam [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 16, 2008 10:03 AM
To: Martin Gainty
Cc: Steven Buehler; mysql@lists.mysql.com
Subject: Re: Multiple Query/Insert help
Hi Martin,
Good point, I normally do but was just illustrating the join. I woul
I have a client that needs to be able to remotely connect to port 3306
securely. I have tried to suggest an SSH Tunnel, but they do not want their
clients to have SSH access. Another problem is that even if we do tunnel,
it needs to go thru one server that is connected to the Internet and into
th
whatever the interface that faces internet is called.
iptables -A FORWARD -i $EXTIF -p tcp -s --dport 3306 -j ACCEPT
iptables -A PREROUTING -t nat -p tcp -s \
-d --dport 3306 -j DNAT --to :3306
On Wed, May 2, 2007 17:03, Steven Buehler wrote:
> I have a client that needs to be able to remot
ING -t nat -p tcp -s \
-d --dport 3306 -j DNAT --to :3306
On Wed, May 2, 2007 17:03, Steven Buehler wrote:
> I have a client that needs to be able to remotely connect to port 3306
> securely. I have tried to suggest an SSH Tunnel, but they do not want
> their clients to have SSH a
But I also need to make sure that nobody is sniffing between Server-1 and
Server-2.
Steve
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 1:35 PM
To: Steven Buehler
Cc: mysql@lists.mysql.com
Subject: RE: secure port 3306
On Mon, May 7
The error is stating that your innodb log sequence is higher that that of
the actual data files...any chance your data partition is full after your
restore?
On Fri, Jan 22, 2016 at 3:23 PM, Neil Tompkins wrote:
> Hi,
>
> Hoping someone can help me identify why I keep having to restore my
> datab
Simple answer is no. What are you trying to accomplish?
S
On Mon, Feb 29, 2016 at 8:31 AM, lejeczek wrote:
> hi everybody
>
> a novice type of question - having a php + mysql, can one just encrypt
> (internally in mysql) tables and php will be fine?
> If not, would it be easy to re-code php to
What level of control do you have on the remote end that is
collecting/dumping the data? Can you specify the command/arguments on how
to dump? Is it possible to turn on binary logging and manually ship the
logs rather than shipping the dump, effectively manually doing replication?
I agree with o
Totally with you, I had to get up and wash my hands after writing such
filth =)
On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith wrote:
> On 29/02/2016 16:32, Steven Siebert wrote:
>
>>
>> At risk of giving you too much rope to hang yourself: if you use
>> mysqldump to dump
l php script on cron or whatever ingest it, allowing
for your business logic for data validate/etc to be done in code (IMO where
it belongs).
S
On Mon, Feb 29, 2016 at 12:12 PM, lejeczek wrote:
> On 29/02/16 16:32, Steven Siebert wrote:
>
>> What level of control do yo
If you insert new records (or update existing) containing correct UTF-8
data to the production database using a mysql client, does the data save
correctly?
Could it be your data source for the production database has/is incorrectly
handling the charset prior to the data being stored in the product
Hi! I just finished a project just like this.
We just put in a brand new mail server running PostFix on Mac OS X
Panther. We added all the extra bells and whistles for spam and virus
filtering, as well as squirrel mail
There is an single-line option in Postfix's config file to have all
email go
I have replaced one server with another, and the new one has everything new
(RHEL 3, newest updates) and MySQL 4.0.23 (old one was RH9 and MySQL
4.0.18).
We now get table corruptions constantly (it only takes a minute before
several tables get marked as crashed). I'd like to revert to the 4.0.18
v
> See:
> http://downloads.mysql.com/archives.php
Thank you. Nice link to have around.
>> Key 3 is the FTS key. The others are a UNIQUE KEY (#1) and a KEY(#2).
>
>Do you have the same values for full-text parameters (ft_mit_word_len
>for example)?
Not at first. I had noticed that not long after
Does Mysql 4.1.1 have the two level index system integrated into it for full
text searches?
Thanks. :)
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You did an insert this way:
mysql> insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql> select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in set (0.00 sec)
The formatting of the POINT coo
Thanks for the additional information. When 4.1.2 comes out, I'll give it a
test and return with some stats on real world result times (for my data set
at least).
-steve-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
-+
| GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
'some_user'@'localhost' IDENTIFIED BY PASSWORD
'*43933BDF3E95B05EC8BE52E6AEE83DB1B1E309CA' |
| GRANT S
I am wary of something so 'do it yourself'. Have you looked at ReHat's
clustering solution?
http://www.redhat.com/software/rha/cluster/
http://www.redhat.com/software/rha/cluster/manager/
I don't think it has any issue with InnoDB, key buffers, etc.
I believe this solution works best for failove
I saw something like this as well. Using 4.1.2 made it go away. Try doing a
bk pull of the dev version of 4.1.2 and give it a go.
-steve--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Here is the background: Anyone that is running a huge system like MARC
> that has millions of uncompressed blob records in huge tables, needs to be
> able to migrate, in real-time and without down-time, to compressed blobs.
> Therefore, we need a way to know if a given field is compressed or not
try passing the --host param to specify the ip address of the MySQL
server. Lets say that you have MySQL running on 192.168.1.105
$ mysql --host=192.168.1.105 -u username -p
do a man mysql for more info
SK
On Sat, 2003-05-31 at 15:34, ABHIJIT NAIK wrote:
> Dear Friends,
>
> I am new user of My
$ mysql --version
On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote:
> Howdy all!
>
> How do I find out what version of mysql I am running from the command line?
>
> Is there a type of system select statement I can execute?
>
> Rob
> :)
> :->
> :-}
>
> --
> MySQL General Mailing List
> For
Try using [EMAIL PROTECTED] (assuming you're connecting
from localhost) to grant permission. I had similar problems
and doing that fixed it for me.
Steven:)
Ronan Lucio wrote:
Hi All,
I created a user "dfn" and I granted access to only the
database "dfn".
Now, if I
After testing a lot of different configurations (which was quite a
headache), I came up with the following. First of all, for both speed
and reliability, you will want SCSI. The list of reasons are quite long
for SCSI, and as you are doing research on the subject, it is an obvious
choice and I don'
> If you're using a non-persistent connection, PHP will close the
> connection when the script terminates, and the MySQL server will roll
back
> implicitly. For a non-persistent connection, the connection remains
open
> and you may not see the rollback behavior your expect.
I thought this was fi
Just a couple of quick notes:
1. While I use PHP CLI for a lot of things (can we say cron?), it is not
a sufficient replacement for triggers. What happens when someone is
using the Mysql command prompt to alter data? Or using a non-PHP
application?
2. While I agree that having application code ra
> What sort of throughput are you seeing in that setup?
God, I can't remember anymore. I can run a test again though. If you
have one you want me to run, just send it. We don't have other people's
money to spend, so all our disks are U160 18GB 15K IBM. They were less
than $100 each when we got the
2 x 2.8 GHZ Xeon
4 GB of RAM
5 15K SCSI Drives
ICP SCSCI RAID control card with 1 Gb of ram on it.
I just bought 30 of these boxes to build out my mysql farm for close to
400-600 queries a second with 60 connections a second of mix read /
writes.
What kind of queries are you doing? Our s
1 - 100 of 413 matches
Mail list logo
