"Peter R. Wood - Mailing Lists" wrote:
> When he deletes an assignment from the class, it deletes it from both tables.
>
> However, after this, if he adds an assignment again, the unique ID generated
> by insertion into the assignment table is one greater than it should be -
> i.e., it auto incr
I want to use mysql_affected_rows to determine whether the sql statement is
executed or not found.
If mysql_affected_rows return 0,I take it as not found.
But If I update a value to the value it already was,
(It means if some value is 'test', and in my sql statement I update this
value to 'test')
Van wrote:
> Simple question:
> Where do I put the my.cnf file? It's nowhere on any of the servers except the
> user directories who use it.
>
Disregard above. I've been using mysqld to start the server since 1998. Hadn't
looked into safe_mysqld since I've only noted that mechanism on RedHat
Hi,
I'm a bit desperate and have some questions to ask.
I'm working with my own compiled server 3.23.33 on SuSe 7.0
I have table:
mysql> desc test.http_refer;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra
Kyzen Computers wrote:
>
> I was wondering if someone can help me, I am new to the list and was looking for
>some help on how I can use mysql with my website to keep track of who comes in and
>giving them logins
>
> I have just read mysql and don't know anything PHP or CGI but if some one tell
"J.C. Ting" wrote:
> I use Mysql for half year. At this moment, I encounter a big problem
> that I can not query any data from my server.
> The following is my configuration.
>
> Platform: Solaris 2.7 on Sun Ultra2
> Mysql version: 3.22.29
> Table Name: mailhead;
> mysql> select * from mailhead
This one's great:
/usr/local/libexec/mysqld: ready for connections
010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication
started in log 'FIRST' at position 4
010319 1:51:41 Error reading packet from server: Binlog has bad magic number,
fire your magician (read_errno 0,
The conflict was due to the version reason only. I installed the correct
version of those rpms and evrything is working fine. This is something new
and exciting for me. The conflict was due to the incorrect and mismathced
version of mysql.sock file which was being used to connect with the mysql
I sent this once before, but got no answer, so I thought I'd try one
more time...
When I fill a table with a "LOAD DATA LOCAL INFILE..." file, it says
there are some warnings... where can I find these warnings? Are they in
a log file? Or is there a command to display them. Thanks.
Additional in
Van wrote:
>
> This one's great:
> /usr/local/libexec/mysqld: ready for connections
> 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication
> started in log 'FIRST' at position 4
> 010319 1:51:41 Error reading packet from server: Binlog has bad magic number,
> fire yo
According to mysql manual:
...
The warnings are not stored anywhere; the number of warnings can only be
used as an indication if everything went well. If you get warnings and want
to know exactly why you got them, one way to do this is to use SELECT ...
INTO OUTFILE into another file and compar
More interesting rezults, after runnig some check/repair/analyze commands
in sequence on the same table:
mysql> repair table http_refer extended;
+-++--+--+
| Table | Op | Msg_type | Msg_text |
+-++--+--
Hi all,
I use Mysql to store session's information.
My problematic is to be very performant...
So, I'm thinking about solutions to make the accesses faster.
I would like to try to cache my database ("load it in memory").
I found some interesting information in the documentation :
- HEAP table
Hello everybody!
I've just switched from version 3.23.29a-gamma to 3.23.35 and noticed
a very high system load increase. As I switched back, everything worked
fine again.
Can anyone agree with this?
As I'm using the replication feature I like to use always
a recent version. This host is a maste
Hello, I wondered if MySQL is capable of being accesed by an ASP script?
tnx!
Hello Jason:
Thanks for your input.
I did think of this possibility; those hash tables MySQL has
available are certainly going to speed things up (if you
have the memory).
My mutlilanguage system could encorporate your idea; I will
give you a run down of how it works.
First you keep separate f
Hi there..
I am not understanding something how the mysql priviege system works:
I want to do the following:
Give a user access to all tables in an database (also tables which will be added in
the future) except a
few private tables like the mysql table itself
This is the way I thought it sh
Hi,
On Mon, Mar 19, 2001 at 01:23:56AM -0600, Jason Landry wrote:
> I know that this response was directly related to a question about
> subqueries, but I think it's important to point this out, because I almost
> didn't pursue this avenue as a result.
>
> As Fred pointed out, MySQL does not sup
Hi!
I have a problem. I would like copy one row from table1 to
another table2. How could I do?
I tried something like this:
insert into table2 values (select * from table1 where username = '$uname')
both (table1 and table2) have the same structure.
Every time when I try do this sql command i g
On Mon, Mar 19, 2001 at 12:22:09PM +0100, - = k o l i s k o = - wrote:
> Hi!
>
> I have a problem. I would like copy one row from table1 to
> another table2. How could I do?
>
> I tried something like this:
>
> insert into table2 values (select * from table1 where username = '$uname')
>
> both
Hi!
> On Mon, Mar 19, 2001 at 12:22:09PM +0100, - = k o l i s k o = - wrote:
> > Hi!
> >
> > I have a problem. I would like copy one row from table1 to
> > another table2. How could I do?
> >
> > I tried something like this:
> >
> > insert into table2 values (select * from table1 where username =
Hello, I'm testing MYSQL client with MSWIN2K adv. server and I wonder how the edit
table function works.
Hi!
i try one little question.
when the table2 have one more row then table1.. is possible try something
like this:
insert into table2 ($date, select * from table1 where username = '$uname')
where $date -> system time and date generated from php.
If you understand.. table2 is backup of table1
In mySQL, it does nothing. Constraints are not implemented. The syntax is
there for compatibility with other dialects of SQL.
You are almost correct, if constraints were implemented then it would be:
CONSTRAINT fk_authorsofdoc FOREIGN KEY(authorid)
(I think, I don't often write them by hand
On Mon, Mar 19, 2001 at 12:51:27PM +0100, - = k o l i s k o = - wrote:
> Hi!
>
> i try one little question.
>
> when the table2 have one more row then table1.. is possible try something
> like this:
>
> insert into table2 ($date, select * from table1 where username = '$uname')
One more 'column
Heikki,
When you write your documentation, please include more info on my.cnf
settings. What I would like to see are some settings documented for
different machines (i.e. machines with 64M, 128M, etc. of memory and also
disk space numbers and how they relate.)
Thanks,
Rick
-Original Messag
If you mean, can you use MySQL when programming Microsoft ASP pages then,
yes.
You need to download and install the MySQL ODBC drivers first then you can
setup your DSN.
Cal
http://www.calevans.com
-Original Message-
From: Gaurav Rishiraj Ahuja [mailto:[EMAIL PROTECTED]]
Sent: Sunday,
Hi!
I tested your test case and you are right !
Thank you for a reproducible test case.
We will fix it shortly.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mail
However, its just strange,
Using the Myslq-front , front end I can sucessfully execute a load data from infile
this is actual command
LOAD DATA LOCAL INFILE 'D:/cmremote/mysqldata/PROJ.csv' INTO TABLE cmremote.CURRENT
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n
Hi I have a task to import a oracel database into our mySql database. Is
there an easy way to do this?
please i need help !!
/*Niklas Adlerberth*/
// +46 8 736 5848 (o)- -(o)
(/ )_ _( \)
-
Before posting, pleas
"Nyström, Rasmus" writes:
> How come the query
>
> SELECT
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif
> ied,bugstatus,submitter), '"') FROM tbl_bug;
>
> returns something like
> "4","4","4"
> "10","10","10"
>
> while only
>
> SELECT
> CONCAT_WS(
David Bouw writes:
> Hi there..
>
> I am not understanding something how the mysql priviege system works:
>
> I want to do the following:
>
> Give a user access to all tables in an database (also tables which will be added in
>the future) except a
> few private tables like the mysql
Roy Wasse writes:
> Hello, I'm testing MYSQL client with MSWIN2K adv. server and I wonder how the edit
>table function works.
It is in the works ;o)
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
hi,
i'm triying to install MySQL/3.23.35 on a sparc running Solaris 7
Here are the steps I follow :
# cd mysql-3.23.35
# CC=gcc CFLAGS="-O6 -mcpu=v8 -Wa,-xarch=v8plusa"
# CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti
-mcpu=v8 -Wa,-xarch=v8plusa"
# ./configure --prefix=/usr
super!
it work fine.
Thank You!
S pozdravem,
Michal Kolesar
+420 608 225025
[EMAIL PROTECTED]
http://www.egarden.cz
server of free unix services
- Original Message -
From: "Peter Pentchev" <[EMAIL PROTECTED]>
To: "- = k o l i s k o = -" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent:
It won't work in FoxPro because it's a MySQL command, not a FoxPro command.
The FoxPro command line will only accept FoxPro commands, it's not a
replacement for the mysql client.
Being an old Fox-Jockey, I use VFP 6 to move data in and out of MySQL
databases and have not had a problem.
Try using
Hello!
There's a need to design a system (something like online forum) that will be
storing huge amount of small messages in database.
There must be fast access only to messages for the last 3 days (guess this means
that main table with indexes on it must be kept small?), while other messages
ca
Hi!
I have installed many of mysql servers and phpMyAdmin clients.
And every time it worked together fine.
Now i have problem on RH70 with mysql and phpMyAdmin:
Database pokus
Error
SQL-query:
Content-Type: application/octet-stream
MySQL said: Unknown database ' pokus'
Back
--
Pascal THIVENT writes:
> hi,
>
> i'm triying to install MySQL/3.23.35 on a sparc running Solaris 7
> Here are the steps I follow :
>
> # cd mysql-3.23.35
> # CC=gcc CFLAGS="-O6 -mcpu=v8 -Wa,-xarch=v8plusa"
> # CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti
> -mcpu=
Hi,
I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
when trying, to see if the servers are up or down , makes mysql to fork ,
till it dies..
The connection port we are using is 3306 .
Does anyone have any idea?
Thanks in advance
Best Regards
Pedro
Jazztel Portugal - Se
Hi Peter and Christian!
>>If you are going to be committing on every record, you'll want your
>>tablespace and logfile directories on separate disks to avoid
>>thrashing. If you only have one disk and don't care if you lose the
>>last few transactions if your system crashes, try setting
>>innoba
Hi I am running the latest versions of MySQL and MyODBC on my windows
200 webserver.
I am trying to connect to my database and pull out some simple data with
asp.
The code i am using is:
<%
dim db
dim strConn
dim rs
dim QueryStr
QueryStr = "SELECT * FROM imagedata"
strConn = "mediaSafe"
Set
Make sure all directories in the path to your mysql.sock file
are world readable and searchable.
Abid Ghufran wrote:
>
> Dear All,
>
> I am trying to setup a web based email setup on RedHat Linux 7 platform. I
> am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms
> requi
I'm a newbie to the Linux-Apache+MySQL world.
1 - Will MySQL handle a data base as large as a Yahoo
or Google or E-Bay ?
2 - Will MySQL running on a Linux/Apache system handle
traffic that approaches that of a Yahoo, Google or
E-Bay?
3 - Does MySQL have an equilivant to "stored
proceedures?
Th
> "Nyström, Rasmus" writes:
> > How come the query
> >
> > SELECT
> >
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc
> ,created,modif
> > ied,bugstatus,submitter), '"') FROM tbl_bug;
> >
> > returns something like
> > "4","4","4"
> > "10","10","10"
> >
> > while on
Welcome!
1: You'll have to be more specific than that. How many tables/records per
table are you looking to store? Are you wanting to optimize it for querying
or is it going to be an active database with heavy inserting/updating?
2: That depends on the hardware you run it on. Technically, yes,
You don't.
You can use telnet to connect and run mysql on that machine, displaying
on yours.
You can use mysql on your machine to connect to mysqld on the remote
machine using the -h
option to mysql. This requires that the grant command has been run on
the server to allow you to connect, and tha
Read chapter 6 of the MySQL manual.
It is explained there.
Nyon wrote:
>
> Hi,
>
> I am a newbie in Mysql and is confused about setting login/passwords. Just
> want a simple security measure as I am the only user.
>
> Here's the scenario:
> I managed to connect using PHP to mysql via the mysql
Hi Craig,
You can give the following a try which does give you direct access to MySQL
from ASP skipping the slower ODBC and is almost code compatible with your
code:
http://www.scibit.com/MySQLX
or
MyVBQL on the mysql API/contrib pages
Regards
Jacques
http://www.scibit.com
http://www.scibit.com/
Hallo MySQLers
I have posted this problem already, but i have still problems installing MySQL
Version 3.23.33 on RS/6000 AIX4.3.3
>Description:
exec(): 0509-036 Cannot load program ../bin/mysqld because of the
following errors:
0509-150 Dependent module /usr/local/lib/libz.a(
You clibs are too old. You are probably running a very old
version of Linux.
john1 wrote:
>
> Dear Sir :
>
> MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
> a simple C API program which catched from MySQL tutorial, it
> chokes at the end of compile process . The program is
"Nyström, Rasmus" writes:
> I tried it now.
>
> Not on the 2000 Server, but on my NT4 SP6
>
> The problem still occures, let's me describe the tests.
>
> The table looks like this:
> id| int(10) unsigned | | PRI | NULL| auto_increment
> title | varchar(255) | Y
Install your curses from your installation CD.
Ali Muhhanmad wrote:
>
> Dear Mysql:
>
> when i execute the configure , it always display:
>
> checking for tgetent in -lncurses... no
> checking for tgetent in -lcurses... no
> checking for tgetent in -ltermcap... no
> checking for termcap f
Updates may reference only one table in MySQL.
Phil Tardif wrote:
>
> here is what happens with my update command:
>
> update GGProfiles set GGProfiles.city = USzipcodes.city where
> GGProfiles.zipcode = USzipcodes.zipcode;
> ERROR 1109: Unknown table 'USzipcodes' in field list
>
> the USzipco
Hi,
I got the following error from mysql (client):
ERROR at line 1: Failed to open file 'varchar(255),', error: 2
The .sql file I were sending to stdin of mysql has the following content:
CREATE TABLE IDENTITY (
id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment,
company_id bigint(20
I want to be able to add a number field to a table and limit the values that the user
can enter. For example if it is an integer filed I may want the user to only enter
the value from 1 to 10. Can I do this within the definition of the field/table or do
I have to do this level of validity che
You have mysqld set for 2000 connections.
How many threads do you have Linux configured for, and how many are open
when
Mysqld crashs?
vinod p wrote:
>
> hi,
>thanks for the interest. The error log just prints
> an incomplete backtrace that is exactly the same after
> every crash. I ran
This does not answer your problem, but 'timestamp' is a reserved word.
Jan Legenhausen wrote:
>
> Hi,
>
> i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
> mine which simply modifys a table went mad completly.
> I figured out a testcase which shows at least one of the
I have a database that I am manipulating with Access through an MyODBC reference. All
is well except for tables that contain any date/time fields. When I click the
(standard) delete record button on forms that use these tables, I get prompted asking
if I want to delete the form from my Access
Source is now a reserved word used to 'source' a text file full of SQL
commands
in the mysql client.
Johan Andersson wrote:
>
> Hi,
>
> I got the following error from mysql (client):
> ERROR at line 1: Failed to open file 'varchar(255),', error: 2
>
> The .sql file I were sending to stdin of m
Hello,
I am using MySQL for the first time and have it installed on a Windows98
machine. I also am running MySQL Maker by presult and a couple of other
GUIs.
Unfortunatley, it seems like any time I make a table that has fields
which aren't varchar or integer, I can not insert any information in
Hi!
I want provide access to my MySQL Server to several customers.
How can I count IO traffic per user, and any user accesses (I don't want
a full log, only log ins)?
Thanks
--
Dipl.-Ing. Gernot Hueber
Institut für Integrierte Schaltungen
Freistädter Strasse 315/2
A-4040 Linz
Tel: +43 732 2468
Hi,
I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
when trying, to see if the servers are up or down , makes mysql to fork ,
till it dies..
The connection port we are using is 3306 .
Does anyone have any idea?
Thanks in advance
Best Regards
Pedro
Jazztel Portugal
I have no problem doing this with server variables ... here is an example that
I tried on the acc (account) table in our db ...
SET @a:=0;
SELECT @a:=@a+1 AS MyRowNum, acc.* FROM acc;
This gives me the result that you are looking for ...
Eric
Peter Holm wrote:
> Hi,
> how do I get something
Hi,
Can you guys confirm that "create database" statements are not logged in
the log-update log? The version I am using is 3.22.32.
Regards,
Jerry.
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
ACABEI DE RECEBER. NÃO TEMOS NADA A PEDER.
Prezados e queridos amigos,
Leiam esta carta e ajam rapidamente. Estou enviando esta carta para
vocês porque recebi informação por parte de um profissional e amigo.
A MICROSOFT e a AOL (America On Line), atualmente as duas maiores
empresas da Internet,
Actually I have 2.23.20-gamma and I get 'create dabase blabla' in my update log.
cheers,
thalis
On Mon, 19 Mar 2001 [EMAIL PROTECTED] wrote:
> Hi,
>
> Can you guys confirm that "create database" statements are not logged in
> the log-update log? The version I am using is 3.22.32.
>
>
> Rega
Hi,
I am trying to upgrade my MySQL server to 3.23.35 from 3.23.33. The
following command is used. I got the following error messages. Any Ideas
!!
rpm -Fvh MySQL-client-3.23.35-1.i386.rpm MySQL-devel-3.23.35-1.i386.rpm
MySQL-client-3.23.35-1.i386.rpm
MySQL-client
FYI
Just noticed that statements like
"LOAD DATA LOCAL INFILE 'testload.data' INTO TABLE testload ;"
won't work via replication(3.23.33) or log-update(3.22.32) unless the data
files are copied to remote slave servers in advance. Better implementation?
Workarounds?
Regards,
Jerry.
Hello everyone, It seems as though I am unable to perform an order by with a
DATETIME field when the column is named as an alias. For example...
SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents
ORDER by 'Serv. Date' DESC LIMIT 0,10;
Can anyone give me an explanation?
Hello
On Sat, 17 Mar 2001, Bård Farstad wrote:
> I have a query in my program which is taking to long when I get data
> in the database. I'm currently testing with ~40.000 articles in the
> system. [...] Is it possible to optimize this query further?
Have you played with EXPLAIN SELECT and fri
Hello,
Sorry, Im don't very good speak english. :(
I have connet to server MySQL from delphi 5
please send mi driver(s) for delphi, or please tell mi how connect.
Fantik
[EMAIL PROTECTED]
-
Before posting, please check:
ht
Periods are not allowed in field names.
Dave Juntgen wrote:
>
> Hello everyone, It seems as though I am unable to perform an order by with a
> DATETIME field when the column is named as an alias. For example...
>
> SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents
> OR
I need to do some tests for a client involving japanese text. I've
recompiled the server with extra charsets = complex to have multi-byte
support.
I see how I can select the default charset upon startup. How can I
tell mysql that a particular set of tables (or the whole DB) should
use the japan
Hi all,
I'm new to MySQL and am puzzled by a curious problem. This join syntax has
always worked fine for me on SQLServer but it seems to work like an inner
join on MySQL:
SELECT d.doccat_ID, d.doccatname
FROM doccats d LEFT OUTER JOIN doccat_group dg ON d.doccat_ID = dg.doccat_ID
WHERE dg.group
after upgrading to 3.23.35 (from 3.22.32) i've got several times:
010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin'
host: `localhost' (Got an error reading communication packets)
it's running on a productive server, but it's not working correctly.
some infos: apache 1.3.19
Hello,
Just starting out with MySQL. I like to put images or links to images in a database,
Is this possible? If so what would be the column type be?
Thanks for the help
Mike
Hi,
I'm sure this has been covered before, so I'm sorry for repeating the
question. A search of the list archives yielded nothing.
What I need to do is grab one random row from a table. What I would do in
MySQL 3.23 is:
SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1
How
Hi.
If you want to store the binary images in the database, the column type will
most likely be a BLOB assuming the images are not bigger that 60k.
If you want to store just url or file paths (http://www.myhost.com/pict.jpg
or /home/bob/image.gif) use a VARCHAR(XX) where XX is a reasonable length
Hi.
for mysql < 3.23 you can do something like this.
select ID, ID*0+rand() as rand from partner order by rand limit 1
have fun.
-ravi.
-Original Message-
From: Chris Boot [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 3:16 PM
To: MySQL Mailing List
Subject: Selecting random
Got any suggestions on how these could be implemented? particular table
types/setups/etc?
I basically have a situation where 300,000+ rows are being inserted into a
log table daily, and also needing to be cleared out based on a tstamp. What
I've found is that the inserts work fantastic, but when
It has been. Check the archives for 2-3 weeks ago.
Cal
http://www.calevans.com
-Original Message-
From: Chris Boot [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:16 PM
To: MySQL Mailing List
Subject: Selecting random rows with MySQL 3.22?
Hi,
I'm sure this has been cover
Hi,
> for mysql < 3.23 you can do something like this.
>
> select ID, ID*0+rand() as rand from partner order by rand limit 1
Thanks a million for the speedy response! It works like a charm!
I don't quite understand how it works though... Could anyone explain? I
really don't like knowing som
I have suse linux 7.1, I installed mysql and php, I tyr to connect to
the database and I get a socket error why? is there any kind of
special confg? I type mysql on a terminal window and get the error msg,
cheers
-
Before
I've created the databases on the new server, but when I do:
mysqldump --quick --add-drop-table --add-locks --extended-insert
--lock-tables TestDatabase | mysql -h newserver TestDatabase
I get the error message:
ERROR 1063 at line 30: Incorrect column specifier for column 'ID'
The originating
You're selecting your index column [ID] for every record and generating a
column containing a random number [ID*0+RAND()], ordering by the random
column [ORDER BY rand], and then just grabbing the first record [LIMIT 1].
the RAND() function generates random numbers.
In my version of mysql (most
Hello,
I would like to ask those of you who have used temporary hash tables in
MySQL version 2.23.x if you have encountered any problems, concurs or known
issues. I have been testing it myself and everything sees to working just
fine. Please list your thoughts and comments on temporary hash
Can you put any warning that you plan to release new version few days
before release ? I have downloaded 3.23.34, and when i visited mySQL.com
on the next day, 3.23.35 was released.
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
--
Yes, you are right, periods are not allowed, but I am still not getting a
successfully ORDER BY on the field. I tried remove the DATE_FORMAT()
function and everything worked fine. Am'I not allowed to alias function
returns?
- Original Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]
Am 22:21 19.03.2001 schrieb Dave Juntgen:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Hello,
> I would like to ask those of you who have used temporary hash tables in
>MySQL version 2.23.x if you have encountered any problems, concurs or known
>issues. I have
> I basically have a situation where 300,000+ rows are being inserted into a
> log table daily, and also needing to be cleared out based on a
> tstamp. What
> I've found is that the inserts work fantastic, but when I got to do the
> delete, even if it doesn't do anything, it sits there and blocks
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote:
>
> Got any suggestions on how these could be implemented? particular
> table types/setups/etc?
>
> I basically have a situation where 300,000+ rows are being inserted
> into a log table daily, and also needing to be cleared ou
Ok. The second one below sounds semi reasonable - it does mean that the
table will be somewhat useless for queries during the delete, but that's not
tragic. Is there any way to drop all the indexes on a table with a single
statement?
Third one sounds good as well, but unfortunately, there is a st
Unfortunately, the deletion criteria are based both on the host it's coming
from, and the date of the records. If I start to break it up along too many
lines, the management starts to outweight the benefits of it being in the
database.
Sounds like looking at innobase is definately a good way to g
On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote:
> I'm a newbie to the Linux-Apache+MySQL world.
>
> 1 - Will MySQL handle a data base as large as a Yahoo or Google or
> E-Bay ?
Done properly, yes.
> 2 - Will MySQL running on a Linux/Apache system handle traffic that
> approaches that of a
#
# Table structure for table 'bus_info'
#
CREATE TABLE bus_info (
info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment,
bus_name varchar(100) DEFAULT '' NOT NULL ,
contact_fname varchar(20) DEFAULT '' NOT NULL ,
contact_lname varchar(20) DEFAULT '' NOT NULL ,
refer_by int(8))
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people s
Dear MySQL Sirs,
I have been trying to run a simple client program using the C API and
unfortunatelly I am still getting the same error over and over again:
./client1: error in loading shared libraries: libmysqlclient.so.10:
cannot open shared object file: No such file or directory
Attached is
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people s
make sure you have -L/usr/local/mysql/lib/mysql/ in your compile
and make sure that /usr/local/mysql/lib/mysql/ is in your shared object
cache.
ldconfig -r will list your current cache entries.
if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add
the path:
/sbin/ldconfi
1 - 100 of 133 matches
Mail list logo
