>Description:
MySQL crashes when a remote computer attempts to make a standard
connection. Making a local connection does not cause this problem,
connecting to other systems does not cause this problem, but a connection
from a remote computer to mySQL immediately crashes mySQL.
The deta
Is there a way to copy select fields from one table and copy them into another table?
Thank you
William Robinson
Sample Data:
ID-Row1-Row2
1-A-B
2-A-B
Row1 and Row2 are duplicate, so you only want one. Which ID do you want?
-will
On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
>
> hey all,
> I have a table "mytable" that looks like this:
> id tinyint primary key auto_increment
> row1 varchar 15
If the ID doesn't represent anything, you can
CREATE TABLE new_table SELECT DISTINCT Row1, Row2 FROM old_table
And then recreate your index(es).
All your autoincrement IDs will be changed.
On 4/17/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
>
> On 4/18/06, William Fong
Is it possible to setup replication so you would have another server to do
backups on? Replicate the data, do whatever you want to the spare, and then
delete the data from the production server.
On 4/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I need a suggestion reg
Dear Sir,
I have a database with over 80 tables. Is there an easy way to find table
names that has PERSON_ID field using SELECT query?
Thanks in advance for any help.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has th
Hello,
I am encountering a strange issue when using the STD function. On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:
SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY
When I test this query on m
Oops, the version numbers were 4.1.18-nt and 4.1.19-standard. I have tried
it now on the latest 4.1.20 version and still have the same problem.
Does anyone have any ideas? Is this a bug?
Cheers,
Bill
> -Original Message-
> From: William Bronsema
> Sent: Thursday, July 20, 2
server version for the right syntax to use near 'select
obj_act_id from c2iedm_dev2.act_functl_assoc where subj_"
I have looked at the documentation for MySQL and this seems to be the
correct syntax for using "IN".
Could someone please let me know what is wrong?
Thank you.
't be an issue, but I
am not able to change its schema.
Thank you.
- William
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you very much!
-Original Message-
From: Visolve DB TEAM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 12:44 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Incrementing using Max(Field) ?
Hello William
Try the below Query to insert next maximum value of
: http://www.mylasikweb.com
Boothe Lasik <http://www.mylasikweb.com/>
Dr William Boothe <http://www.mylasikweb.com/>
Dr Boothe <http://www.mylasikweb.com/>
Lasik Boothe <http://www.mylasikweb.com/>
Boothe <http://www.mylasikweb.com/>
Boothe Lasik <http://www.m
Glenn Kawesch
Dr. Kawesch is the surgical director of Kawesch Lasik--one of Southern
California's most experienced refractive surgery facilities. We have been
specializing in refractive surgery since 1989 and have completed
approximately 25,000 procedures.
Dr. Kawesch attended medical school at
I'm trying to relocate the database files for MySQL 4.1
I've seen two primary techniques for doing this:
1) create/alter a my.cnf file with 'datadir' set to new location
2) moving the physical files and creating a symlink in the original location
Unfortunately, neither of these methods work for me
Some more information can be found here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
On 12/31/05 7:29 PM, "JJ" <[EMAIL PROTECTED]> wrote:
> I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
> why MySQL Adminstrator says the table has 497 rows, while do
muhammad subair wrote:
On Mon, Jul 27, 2009 at 9:25 PM, Ken D'Ambrosio wrote:
Hey, all. I'm trying to "get" indexing -- like, when do you specify an
index name during index creation, is index use implicit or explicit, and,
honestly, how exactly does it work, anyway? I've been RTFM'ing, but
h
I have two tables:
PtActive
ptNum // the patient's number
user // the user who made this patient "active"
expires// when the patient becomes inactive again
primary index: PtNum
PtName
ptNum
sequence
lname
fname
primary index: ptNum, sequence
The table PtName may have multiple
I have three tables show below which I am querying in a number of ways. e.g.
I have a report which lists number of reports provided compaired to number
which were due over the duration of the project.
I am puzzling over how to select the reports which were due and were
delivered during a week base
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP. Default DATE(TIME) columns with Triggers.
PB
When I try
ALTER TABLE `ptInfo` CHANGE
On 1/27/2012 6:00 PM, Peter Brawley wrote:
On 1/27/2012 2:24 PM, william drescher wrote:
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP
I want to update a date field in a record. if the date in the
field is -00-00 I want to change it to the current date. I
would appreciate suggestions or links on how to do this.
Yup, tried reading the manual, but need a bit of help.
I will be updating another field at the same time.
bill
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
Thanks
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On 2/9/2012 8:18 AM, Michael Dykman wrote:
untested:
update set mydate = IF(mydate = '-00-00', now(), mydate)
- michael dykman
Thank you very much !
bill
On Thu, Feb 9, 2012 at 8:14 AM, william drescher
wrote:
I want to update a date field in a record. if the d
On 2/9/2012 8:58 AM, Reindl Harald wrote:
Am 09.02.2012 14:55, schrieb william drescher:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
ed for solution.
I would be greatful for any hints or suggestions as to how I might go
about correcting this problem. Thank you in advance.
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template ->
Files: mysql.jar
Reference: http://www.mysql.com
DbVis Software AB is a "MySQL Network Certified Partner"
and have the right to distribute the Connector/J driver.
So what I can't explain is why it works for one and not the other.
Regards,
web...
--
William Bulley
bug
this issue. At this point we were stumped and called it a day. :-(
Today, I got the less than helpful from the support folks at
DbVisualizer and then I contacted "the MySQL community". :-)
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters w
e notes between those versions?
I think that might be a next step, but even more expedient would be
upgrading the 5.1.58 server to 5.1.60 or 5.1.61 version and retest.
> This looks like an ugly one. I don't envy you.
Gee, thanks for those words of encouragement - NOT!
to do as you suggest is greater than simply
upgrading the 5.1.58 server to 5.1.60 or 5.1.61 server
Thanks for the reply!
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template ->|
--
MySQL General
will be able to try out some of these
concepts. I do, however, plan to "have fun" this weekend... ;^)
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template ->|
--
MySQL General Mailing List
On 4/16/2012 3:04 PM, Haluk Karamete wrote:
What's the right built in php date function formatting would be to take a
simple date, that's in a format like 05/16/1960 and turn it into a mysql
datetime datatype friendly format?
I don't mind H M S to be as 00:00:00/
wrote my own:
function US2ISODa
I have a table ("tasks") with:
task_id mediumint(9)
status char(1)
priority char(1)
and more fields
when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it d
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the
ug 19, 2012 11:19 AM, "william drescher"
wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'
On 8/19/2012 5:56 PM, william drescher wrote:
mysql> select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
mysql> update tasks set status= 'H';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysq
On 8/20/2012 10:09 AM, Mogens Melander wrote:
On Sun, August 19, 2012 18:19, william drescher wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more w
I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned NOT NULL,
`standing_script` mediumint(9) DEFAULT NULL,
On 3/31/2013 7:32 AM, william drescher wrote:
I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned NOT
of course, "Group By"
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 7/26/2013 6:58 PM, Chris Knipe wrote:
The issue that we have identified is caused by seek time - hundreds of
clients simultaneously searching for a single file. The only real way
to explain this is to run 100 concurrent instances of bonnie++ doing
random read/writes... Your disk utilization a
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`icd10` char(6) NOT NULL,
PRIMARY KEY (`id`),
U
On 3/29/2014 2:26 PM, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL
On 8/29/2014 5:51 AM, Johan De Meersman wrote:
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
yes.
I welcome help from anyone willing. Expertise and willingness
both are important.
--bill
--
MySQL General Mailing Li
Replication novice
I have a master server at the office and a replication server at
home. This setup has been working for a couple of years.
Occasionally the replication server gets out of sync (usually
following a internet problem and the vpn going down.)
I just stop the slave, make sure th
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master,
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
+--+--+--+---
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
| File
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql> show global variables like 'log_bin%';
+-+---+
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slav
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the "last error"
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equ
On 9/19/2014 10:59 AM, Don Wieland wrote:
On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
the target folder don't matter
that is clearly a *MySQL error* that your *MYSQL user* lack the needed
permissions
Yes i figured that - so the question is, how do I give full permissions to that
user?
Ubuntu 14.04 LTS, MySQL 5.5.38
I have a setup with multiple tables in one database. One is a
memory table. I have replication running to a remote computer
for a hot backup.
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in
On 10/15/2014 11:30 AM, a.sm...@ukgrid.net wrote:
Quoting william drescher :
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in memory
table.
Is this what you are after?
http://dev.mysql.com/doc/refman/5.5/en/replic
On 6/18/2015 1:25 PM, AZ 9901 wrote:
Hello,
I only get SPAM answers when I try to post to this list so here is a simple
message…
Sorry…
Marc.
your message came through on gmane.comp.db.mysql.general just fine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
T
/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
END OF INNODB MONITOR OUTPUT
====
Does any one know whats going on? Is this expected behavior?
Thanks in advance,
William
___
ssage
From: Baron Schwartz <[EMAIL PROTECTED]>
To: William Newton <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, October 2, 2007 12:05:41 PM
Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.
Hi William,
William Newton wrote:
> Hello List,
>
&g
** WE ROLL BACK TRANSACTION (2)
Can
anyone explain whats going on? Is there a limit for the number of
concurrent transactions, before looking at the lock graph becomes too
expensive? Is that documented somewhere?
Thanks,
If you are going to rely on obfuscation to protect valuable data, you might
want to consider not posting the particular method you will use on a public
mailing list.
I think any method you implement will lower the overall security of the system.
But, if you must search for encrypted text, you
Use smaller transactions that don't have 140 million rows. When attempting an
action with important data, make sure you can survive the actions failure. If
you can't, then you need to think of a different way of doing it that will
allow a recoverable failure.
- Original Message
From:
I'm guessing you are adding a semi-colon (;) to the end of the statement. Its
unnecessary with the \G
- Original Message
From: Jeff Mckeon <[EMAIL PROTECTED]>
To: MySql
Sent: Thursday, December 6, 2007 12:19:22 PM
Subject: Error: No query specified
When I run a "Show slave status \
Well, if your particular problem has a well defined maximum minimum and minimum
maximum (Ie the max(q) < 4294967296, because q is a 32 bit unsigned int, and
min(q)> -1) then you can do it without any extra joins or sub selects.
select
a,
b,
min(IF(date <100, q, 4294967296)) as min_q,
max(IF
MATCH (title, description) AGAINST ('chev* \"malibu\"' IN BOOLEAN MODE)
vs
... AND MATCH (title, description) AGAINST ('chev* "malibu"' IN BOOLEAN MODE)
They both seem to be Ok, but I just want to make sure now, before
wierd problems come up later...
thanks
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list dedicated to replication, but when
you have a look in the archive it's nearly complete empty. Really
not busy.
So i hope it's ok if i
On 3/22/2016 7:49 AM, Lentes, Bernd wrote:
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up the programms on the slave by hand and then they ar
On 4/30/2016 3:22 AM, Thomas wrote:
Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher:
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the
On 7/8/2016 9:15 AM, Johan De Meersman wrote:
As a clear example of what it is useful for, imagine a situation where you're
performing an inventory on an existing warehouse. You have the
list of all the
products they've ever sold, but you need to differentiate between
'this product is
not in s
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How can I see the warnings earlier in the load ?
-bill
--
MySQL General Mailing List
On 3/25/2017 10:03 AM, Hal.sz S.ndor wrote:
2017/03/24 15:19 ... william drescher:
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed
ANNOUNCEMENT:
A RFD (REQUEST FOR DISCUSSION) has been posted for the creation of a
new Usenet newsgroup: comp.databases.mysql
The proposal and related discussion can be read in the Usenet group
news.groups ... feel free to weigh in and make any suggestions you
may have.
Message-ID: <[EMAI
I'm all for using what works and do not try to avoid MS (as long as it fits
the requirements).
However, I found out that MySQL does not work very well under load under
Windows 2000. It is considerably slower than a similar configured Linux
system. It may be how MySQL AB compiled the Windows binari
I wonder why even I already sey NOT NULL in Mysql field but Delphi (with
MyODBC 3.51.06) still enable to save to the Table!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does replication in 5.0 support stored procedure?
When I create a procedure on the master, it isn't
replicated to the slaves. I then manually create
the same procedure on the slaves. Then when I
call the procedure on the master, all the slaves
crashes. Is this not supported or am I doing somethi
I can dupicate this everytime. I have just opened a bug.
Bill
Andrew Braithwaite wrote:
Hi,
5.0 is "sub-alpha" at the moment. If you think there is a problem, go to
http://bugs.mysql.com/
Cheers,
Andrew
-Original Message-----
From: William Au [mailto:[EMAIL PROTECTED]
Sent:
Sergei, but this is a phrase search. The original query is:
match (keywords) against ('"16-bit Touch"' IN BOOLEAN MODE)
So shouldn't all words that are actually searched on be present
in a particular order?
Bill
Sergei Golubchik wrote:
Hi!
On Feb 27, Haitao Jiang wrote:
Thanks! That was wh
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to
enable this?
I just migeate from MS SQL to MySQL but have problem on "Cascade Update".
Suppose I have BOOK and LIST_TYPE tables like this:
BOOK, field: Book_Name, Book_Type
LIST_TYPE, field: Book_Type
If I already define Cascade Update between BOOK and LIST_TYPE, then when I update the
content of Book_Type (
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Hi there
Quick and simple question. Does the windows version of Connector/J
run under Windows NT, the documentation implies only 9X and ME
Regards
Will S.
NOTICE AND DISCLAIMER:
This email (including attachments) is confidential. If you have received
this email in e
The following php code was working to upload files to my mysql db until I
upgraded to mysql 4.0. Now, the files I try to upload do not get put into
the folder. There is no error, the file just does not get posted. Any ideas?
Uploading File...
';
$destination = 'uploads/' . $HTTP_POST_FILES['
prompt, MySQL responds with
rows. So I know MySQL works and is there, but I can't connect interactively.
Could someone please help me with this. Does anyone know how I can troubleshoot either
MySQL or Cygwin to see what the problem is...
Thanks In Advance.
William Martell
Dallas Texas
--
Does anyone know how to set up a function to automatically generate reports
from a MySQL database? For example, I have a table that gets populated with
users when they register. I want to be able to have it automaticaly create a
report every 12 hours (or however long) that will generate specific
in
This may be a weird question, but we were wondering if there was some sort
of way to encrypt or protect the database just in case of someone hacking
into the server it resides on. Since there might be some sensitive info in
the database, we'd like to go to as great a lengths as possible (only
usern
Will be any problem if I install MySQL 4.0.15 for Win on the Server that
already has MS SQL 2K under W2K Server?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I try convert this MS SQL Statement but an error occurs:
UPDATE a SET a.ACCOUNT_CODE=b.ACCOUNT_CODE
FROM a,b
WHERE a.ACCODE=b.ACCOUNT_OLD
Is there any syntax doing same as above?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Does MySQL support update from other table?
I run this query and get error:
UPDATE TableA SET Division=TableB.Division
FROM TableB
WHERE TableA.Code=TableB.Code
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
I am doing transfer from MS SQL.
In MS SQL while I connect as "USER1" my table will be create as User1.TableName.
This will avoid conlict with other user.
Now, how do I do that in Mysql? Or, maybe there is such system in Mysql. Is there any
Mysql reference talk about this matter?
to upgrade:
rpm -U rpm_package_name
but you must read mysql upgrading topic in mysql manual reference to avoid
any problem.
- Original Message -
From: "Robert Morgan" <[EMAIL PROTECTED]>
To: "mysqllist" <[EMAIL PROTECTED]>
Sent: Friday, October 31, 2003 5:45 AM
Subject: upgrading
Hi, a
Dear All,
How do I know that User "USER1" already login to Mysql?
I am creating multiuser program and need to set only one User Name uses at
same time. If there is 3 users that my login as User1, User2 and User3.
William
--
MySQL General Mailing List
For list archives: http://lists
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3 controller which shows 40MHz bus connecting the 10K-RPM
disks. (Fairly new, fairly capable, low-end server grade.)
I have a 2GB datafile with 10 indexe
n, though I suspect it is something else. I forgot to mention file
system is ext2.
bbaker
On Mon, Nov 03, 2003 at 11:18:55AM -0600, William Baker wrote:
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScs
Now why didn't I think of a single alter tablethat should certainly
improve things. I'll give it a try.
bbaker
William Baker wrote:
I am using a pentium4-2GHz machine with Linux-RH9 installed and 1GB
RAM. The database is on a dedicated SCSI drive with an Adaptec
UltraScsi3
If you insert records directly into the tables in mysql, then they only
have the rights you specifically specify. GRANT is smart enough to
handle a lot of the dirty-work for you. In particular, I like the:
GRANT SELECT on *.* to readonly@'%' identified by 'readonly';
This will create the user
I am using Delphi 7 and MySql 4.0.16, since MS release .Net technology and
also Delphi 8 .Net to provide web services application, I want to know how
to make a web services application using Mysql? Or is there similiar
technology like .Net but using Mysql?
--
MySQL General Mailing List
For list
> Briefly:
> The project connects with TADOConnection, TADOTable and TDataSource, and
> consists of two tab sheets, one with a DBGrid and DBNavigator1 (Read
only),
> and the other with an assortment of DBEdits, a DBMemo and a DbNavigator2,
> this with full read/write options.
>
> Attempts to write
to souce code and using strace, I'm clueless as to how to
improve this situation. I think it's still way too high. I've tried
variations of all the system variables that appear to be relevant.
bbaker
On Mon, Nov 03, 2003 at 01:35:26PM -0600, William Baker wrote:
It's
Is that better?
On Fri, Nov 07, 2003 at 05:03:43PM -0600, William Baker wrote:
Sorry for the slow reply. I was battling SCSI controller bugs as well
as database issues. I have given up on the software raid for now
because it is unstable.
Really? I've run Linux software RAID qui
Did we already talk about the log flush method you're using with
InnoDB? I don't recall...
Log flush method? As described by Mysql documentation:
If you can afford the loss of some latest committed transactions, you
can set the `my.cnf' parameter |innodb_flush_log_at_trx_commit| to 0.
|In
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I am currently getting the following error on one of the mysql servers
im looking after and wonder if anybody knows what specifically it
relates to.
Error in accept: Too many open files
Im currently running MySQL version '4.0.14' under FreeBSD
1 - 100 of 437 matches
Mail list logo
