http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
I recommend "LEFT( )".
If you are looking to do it in PHP then this is the wrong email list.
Good luck.
b.
CodeHeads wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello all,
Have a question:
I would like to limit the amou
UPDATE table SET field_a=field_b;
b.
Ravi Malghan wrote:
Hi: is there a way to copy all field values from one
field to another from the mysql prompt?
Thanks
Ravi
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are
not sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
does need a logfile even when all transactions are committ
Marten Lehmann wrote:
I had a lot of trouble today because the InnoDB integration in MySQL
is lousy. I read the manual and worked with innodb_per_file_table. So
when I shutdown mysql I should be able to delete ib_logfile0,
ib_logfile1 and ibdata1, because all table-data should be stored in
th
I am having a problem where I cannot seem to increase the max_join_size
of 4.1.18 above a hard limit that is way too low for my use. Has anyone
run into this and know of a solution that does not involve upgrading to
5.x.x? (That is presently not an option for another month or so.) I also
want t
Shawn,
That's a very reasonable answer. Thanks for pointing me to the
examples. This one addresses the second question:
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.
html . There is no example answering both questions in one query.
Regards,
Bill
__
All,
In the following query, some of the values are averaged over several
rows, but some are not:
SELECT hostname, volname, qtreename, round(avg(used/allocated*100),0),
round(avg(used)), allocated, available
FROM quota_entries
WHERE date_sub(now(), interval 1 day) < time
.patch
--- ../myodbc-3.51.orig/execute.c Fri Feb 22 10:55:35 2002
+++ execute.c Fri Feb 22 10:53:48 2002
@@ -72,7 +72,26 @@
query=tmp_buffer;
}
}
- }
+ }
+ /* Terrible hack by Bill Adams */
+ else if(
+ !my_casecmp(query, "select", 6) &&
+
Spoiler: Venu's Suggestion about "Dynamic Cursor" is the answer
On Thu, 2002-02-14 at 20:34, Venu wrote:
> > MyODBC, as compiled today, uses mysql_store_result to get records. This
> > is fine for reasonably sized tables. However, if the table has millions
> > of records, writing the resul
Monty, Venu, I hope you read this... :)
I really, really want to use MySQL as the database backend for my
datawarehouse. Mind you I have played around with merge tables quite a
bit and know that MySQL is more than up to the task. There are numerous
(not necessarily cost related) reasons as to
rick herbel wrote:
> Question - Why is key len,ref null ?? Is it not using my key? Why does it
> say type range
> here and below it says type ref the table has 134000 records in it so it
> should be using key.
Have you run myisamchk -a on the table? (Or ANALYZE TABLE from the sql prompt?)
b.
Cindy wrote:
> I tried checking for error codes in the documentation, but didn't find
> anything particularly useful.
>
> I'm getting this:
> mysql> load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex
>(aid, wid, wordform, start, length);
> ERROR 1030: Got error 28 from ta
Etienne Marcotte wrote:
> What is the exact difference between
> this
> index(col1,col2).
Create a single index on col1 and col2.
>
> that
> index(col1),index(col2).
Creat two indexes, one on col1, one on col2.
>
> and this
> index(col1),index(col2),index(col1,col2).
Do all three. Note that
Thu, Nov 15, 2001 at 02:01:44PM -0800, Bill Adams wrote:
> > "Anthony R. J. Ball" wrote:
> >
> > > I was just reading DOCS for MERGE tables... and they
> > > look like exactly what I want.
> > >
> > > I have a large lookup table that I use
"Anthony R. J. Ball" wrote:
> I was just reading DOCS for MERGE tables... and they
> look like exactly what I want.
>
> I have a large lookup table that I use to track down
> where I want to find my data, which gets loaded into
> different tables at different times of the day
> (financial dat
---
> 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 unsubscribe, e-mail <[EMAIL PROTECTED]>
> Tro
... Then if you want
to move the data to a different db you can move either the .MYI, .MYD, and .frm
to the right place OR you can use mysqldump.
b.
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams
> Sent: Wednesday,
Won Lee wrote:
> I have an slew of Access DBs that I need to port some of the info into a
> MySQL DB.
> I guess my main problem is my I have no idea in what format to export my
> data from the Access DB.
> In general I export it as a tab delimited file with no text qualifiers.
> Unfortunately, mu
Jeremy Zawodny wrote:
> On Wed, Nov 14, 2001 at 12:07:04PM -0800, Bill Adams wrote:
> > The most important exception is the mysql_use_result attribute: This
> > forces the driver to use mysql_use_result rather than
> > mysql_store_result. The former is faster and less memo
Man I just cannot stop replying to myself...
Bill Adams wrote:
> Bill Adams wrote:
>
> > Rick Emery wrote:
> >
> > > If you use PHP, the answer is:mysql_unbuffered_query()
> >
> > Well, I get the delay if I query with perl DBI or enter the query direc
Bill Adams wrote:
> Rick Emery wrote:
>
> > If you use PHP, the answer is:mysql_unbuffered_query()
>
> Well, I get the delay if I query with perl DBI or enter the query directly in
> the mysql client. perl DBI + Informix does not buffer so I know that it is
> not
ile the query is running w/o any results being returned yet, the process
list shows "sending data".
b.
>
>
> -Original Message-----
> From: Bill Adams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 14, 2001 11:38 AM
> To: Mysql List
> Subject: Non-Bu
n/rm -fv $TMP
if [ $? != 0 ]; then
echo "Could not remove temp file?"
exit
fi
done
done
>
>
> Or I could be completely off base. It wouldn't
> be the first time. :-)
>
> Jon Gardiner.
>
> > -Original Message-
> >
orked like a charm, yet MySQL doesn't seem to accept that. Any
> > > solutions or advice?
> > >
> > > --
> > > Ian Evans
> > > Digital Hit Entertainment
> > > http://www.digitalhit.com
> > >
> > >
> >
>
> -
MySQL 4.0
Is there a way to prevent mysql(d) from buffering
the output ala 'mysqldump -q'?
The specific case I am thinking of is a simple
SELECT ... FROM ... WHERE (with no ORDER BY, no
GROUP BY, etc.). In this case there is no reason
[that I can think of] why mysqld cannot start
returning reco
>
> PS: If I run the mysqladmin shutdown command, then check "top" in
> another console, both the daemon and the mysqladmin command continue to
> run indefinitely -- and I have waited an hour to see if it's just slow.
> That doesn't seem to be the case.
>
This seems like an OS bug to me. All o
Erik Price wrote:
> All,
>
> Well, I solved the mystery of the missing Unix socket. It needs to be
> defined at the time the daemon is started with:
> --socket=/path/to/socket. Well, at least in my installation it does.
>
> But now I'm having the OPPOSITE problem -- shutting down the server
>
"Karl J. Stubsjoen" wrote:
> Hello,
>
> I need to create a search engine out of a few MySQL tables I should
> say: I need to search MySQL records like a search engin might. However, my
> first go ended up as a complete failure because it is highly un-optimized to
> search for (as an exampl
Auri Net SAC wrote:
> Hi,
>
> I have a query result with 50 register and i want to show them in 5 pages,
> every page show 10 register.
LIMIT (see the manual) will help you.
b.
mysql
-
Before posting, please check:
http:/
Sinisa Milivojevic wrote:
> Nick de Voil writes:
> > I am running MySQL 3.23 on Windows 2000.
> >
> > I have a SQL statement which looks fine to me, although it does reference
> > the same table twice.
> >
> > Here it is:
> >
> > SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users
Jeremy Wilson wrote:
> At 01:07 PM 11/13/01 -0600, Gerald Clark wrote:
> >Start the server with the desired TZ set.
>
> That's all fine and good, but difficult switch back and forth every 10
> minutes while that query runs for local data, then for the remote data.
The way I deal with it (and I d
Riccardo Cohen wrote:
> Hi,
> Sorry to disturb, but I cannot find any answer in online doc and web archive.
>
> >Description:
> I insert 34000 rows in a simple table with all text fields, and myisamchk
>tells the table is corrupted, while a select into outfile does not give any error
>c
otal Time: 31 seconds (18251 rows, 588 rows/sec)
Shutdown MySQL
Set key buffer size to 0
start mysql
Time to start getting results: 10 seconds.
Total Time: 29 seconds (18251 rows, 629 rows/sec)
myisamchk -a
Time to start getting results: 145 seconds.
Total Time: 164 seconds (18251 rows, 1
---
> 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 unsubscribe, e-mail <[EMAIL PROTECTED]>
> Tr
The MySQL manual
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#MySQL_indexes
states "All MySQL indexes (PRIMARY, UNIQUE, and
INDEX) are stored in B-trees. Strings are
automatically prefix- and end-space compressed.".
Other RDBMSes out there state in the their
he manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Bill Adams
TriQuint Semiconduc
"Wells, Kenneth L" wrote:
> Please help
>
> I'm at the end of my rope...
>
> I just ran a script to create databases in my SQl server, it runs fine
>
> When it completes it says remember to set a password for the mysql root
> user!
>
> I entered this?
>
> /usr/local/mysql/bin/mysqladmin -u ro
[EMAIL PROTECTED] wrote:
> I'm switching over to a bigger better faster server. My old server is running
> version 3.23.22-6 mysql on RH and I need to move all the db's to my new box
> using 3.23.41 installed on RH7.2. So do I just simply move all of the db
> directories from /var/lib/mysql from
(Sorry for the double email Simon, forgot to
switch the email to text...)
Simon Windsor wrote:
> Hi
>
> The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
> the standard RedHat version.
>
> The machine is running two databases, one is a full archive while the other
> on
Simon Windsor wrote:
> Hi
>
> The OS is Redhat 7.1 on a dual processor Pentium box, running MySQL 3.23.36,
> the standard RedHat version.
>
> The machine is running two databases, one is a full archive while the other
> ones holds current data. The same five records are unavailable using SQL in
>
[EMAIL PROTECTED] wrote:
> I changed the script and now all is well. However I have two concerns:
> 1) Paranoid about the password being in this script. Is there a way around this.
chown root:root /etc/rc.d/init.d/mysqld
chmod go-rx /etc/rc.d/init.d/mysqld
> 2) Since I had to change the script
Brendin wrote:
> I would like to have a table that has a primary key defined on a
> combination of two columns in the table. In other words a unique key
> based upon the values in two columns.
>
> I don't think I am able to do this in mysql. I think you can only have
> a primary key on one colu
[EMAIL PROTECTED] wrote:
> The only reference to mysqladmin is for the reload at the end. I think this
> whole thing started after doing the mysql_install_db and then creating the root
> password - but it may be a coincidence.
>
> Any and all help is welcome as to why /etc/init.d/mysqld stop fail
[EMAIL PROTECTED] wrote:
> I'll agree with you but - when I shutdown my linux box or restart it, it tries
> to stop the mysql server and it can't. The command /etc/init.d/mysqld stop
> should work and it isn't. The question is why can't I stop the mysql server with
> this command. As a matter of
Simon Windsor wrote:
> Hi
>
> I appear to have lost several records, but on doing mysqldump the
> records are there.
>
> I have tried optimize|repair and the data hasn't re-appeared.
>
> Any ideas ?
Not with this level of information.
(Try including some sql, what you are trying to match, etc.
Craig Issod wrote:
> >Craig Issod wrote:
> >
> >> Using 3.23.32 on FreeBsd 3.2
> >>
> >> Have gotten a sample fulltext search going, but cannot figure out how
> >> to shorten the word length to 2 o3 3, from the default 4.
> >>
> > > Yes, I've read the docs, and tried the following:
> >> Sett
[EMAIL PROTECTED] wrote:
> Howdy,
> I'm running version 3.23.41 on RH7.2. For the life of me I can't figure out why
> I can't stop mysqld. Linuxconf was where I first noticed this where mysqld would
> not respond to the stop request. I then tried to reboot the box and watched the
> shutdown proce
Craig Issod wrote:
> Using 3.23.32 on FreeBsd 3.2
>
> Have gotten a sample fulltext search going, but cannot figure out how
> to shorten the word length to 2 o3 3, from the default 4.
>
> Yes, I've read the docs, and tried the following:
> Setting variable using mysqld on command line...it won't
Fulko Hew wrote:
> I am using mySQL 3.22.4a-beta
> yes, I know its old :-(
>
> I have just stumbled across a problem with how it
> treats 'uniqueness' in table contents.
>
> I have a table with a column defined as:
>
> create table test (name varchar(80) not null);
> alter table test ADD UNIQ
BC is on the *nix.
b.
mysql
>
>
> mweb
>
> On Fri, Nov 09, 2001 15:22:11 at 03:22:11PM -0800, Bill Adams wrote:
> > mweb wrote:
> >
> > > >mweb,
> > > > To make sure I understand you correctly, you want to create
> > >
mweb wrote:
> >mweb,
> > To make sure I understand you correctly, you want to create
> >and
> >test your PHP/MySQL database on your Linux/Apache box, then upload it
> >to
> >your ISP server that is running PHP/Access? I'm sorry but that's not
> >going
> >to work. You can't transparently s
into the grant tables, as it were, you need to get into the mysql db:
'mysql -u root -pyour?new.password mysql'. Note that there is NO space between
the '-p' and the password.
b.
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROT
Dan Tappin wrote:
> I tried that but it came back with a 'mysqld is running already' error.
Actually your command is wrong. If you never set the password before it should
be (without the -p):
mysqladmin -u root password your?new.password
note that 'password' IS the command.
> Side Question:
Dan Tappin wrote:
> I have some experience with MySQL on MacOS X but that was with a pretty GUI
> installer.
>
> I am now trying to get MySQL installed on Redhat 7.0. I download the client
> and server versions and followed the install procedures.
>
> The problem I am having is with mysqladmin.
Stuart Scamman wrote:
> How do I show processlist from a specific computer, not everything ?
> Thanks.
mysqladmin processlist |grep 'the.host.you.care.about'
--
Bill Adams
TriQuint Semiconductor
-
Before
Aaron Williams wrote:
> The tables run upwards of around 13-15 gigs each. The nature of the
> data forces me to search the entire contents (looking for unique
> values) around 3000 times a day. The server is running Solaris 2.8,
Do you have an index on the columns you are querying for unique val
Rui Barreiros wrote:
> Hi,
>
> We have several mysql server in production evironment, and most of them
> when they have millions of rows, they all get MyIsam tables corrupted.
>
> One of the servers has ext2 filesystem with scsi harddrives, after the
> myisamchk -r it repairs the table, but after
Christian Stromberger wrote:
> Disclaimer: SQL/database newbie here.
>
> Let's say I have a table of authors with columns for last name and first
> name. Is there any general guideline re using a separate integer for the
> primary key as opposed to a combination of the last and first names as th
Paul DuBois wrote:
> [snip]
>
> >Of all the methods suggested I like the look of the one above and will
> >try that one first.
> >
> >$count = $sth->fetchrow_array();
> >
> >$rows = $sth->rows()
>
> Note that use of rows() to get the row count for a SELECT is deprecated
> in the DBI docs, which s
Federico Schwindt wrote:
> hi,
>
> i'm not sure if this belongs here, but i cannot seem to find the
> answer anywhere else.
> first, what's the difference between:
>
> PRIMARY KEY (key1, key2)
> PRIMARY KEY (key1), KEY (key2)
The first line creates a single, unique key on the columns key
tbl1 T2
WHERE T1.a=T2.a AND T1.c='R' AND T2.c='T';
My real query is much worse than this.
Any suggestions?
--Bill
>
>
> -Original Message-
> From: Bill Adams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 31, 2001 12:21 PM
> To: Mysql List
>
Harpreet wrote:
> I had a view on sqlserver which i am trying to convert to work with mysql.
> It uses a union which i believe does not work with mysql. What is another
> alternative for union.
>
> Sql with union:
>
> select a.asset_id,a.material_id,b.material_id as parent_material_id from
> lib_
My mind is not working with me this morning...
According to the manual about join syntax:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN
One should be able to do a LEFT JOIN without a
join_condition, eg. an "ON" or a "USING":
> table_reference LEFT [OUTER] JOIN
tab
>
> > 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 unsubs
alexus wrote:
> Hello
>
> I have a very busy site (www site) w/ a lot of hits
>
> my site is very heavily integrated w/ mysql
>
> and when i do top it shows me like over 80% of cpu
>
> even though i have dual p3 850mhz w/ 1.5 gig of ram
>
> any ideas what to do about it so it'll drop down?
Have
-
> -+---+-+-+-+---
>
> --+----+
> 4 rows in set (0.00 sec)
>
> It's just simply not using the index on users..
> Did I miss something?
>
> David
>
> --
> -- Original Message -
> From: "Bi
; > >
> > > David
> > >
> > >
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php (the manual)
> > &
Kyle Hayes wrote:
> On Friday 26 October 2001 10:00, Dana Holt wrote:
> > Can I automatically generate a random, unique, integer value in a certain
> > range when inserting data into a column using SQL?
> >
> > If so, how?
>
> Random is easy. Just find a good RNG (random number generator) somewh
Bill Adams wrote:
> Demirchyan Oganes-AOD098 wrote:
>
> > Hello everyone,
> >
> > I wanted to ask you 2 questions.
> >
> > 1. I have a table that has 2 columns, user_id,
> user_name.
> > User_id has been setup to a default value 1000
> and t
Demirchyan Oganes-AOD098 wrote:
> Hello everyone,
>
> I wanted to ask you 2 questions.
>
> 1. I have a table that has 2 columns, user_id, user_name.
> User_id has been setup to a default value 1000 and to AUTO_INCREMENT.
>
> When I insert a record, Insert Into User_Table (user_id,user_name) Value
[EMAIL PROTECTED] wrote:
> Hi. I've been reading for several hours on this one. I've tried everything
> I've read. I'm either doing something really stupid or I've missed the
> point completely.
>
> I have a db on a linux server. I used phpAdmin to create a dump file
> (pe.sql) and retrieved it o
jim barchuk wrote:
> Hi Ryan!
>
> > Today after my server got a real traffic hit for the first time since I
> > installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
> > it happened: watching the "top" load levels, I saw it slow creep up about to
> > 3, then rockets quickly
Rob Vonsee wrote:
> Dear developer,
>
> In the past several years, we have developed a database application in
> MicroSoft's Access '97.
> With our user base growing, we're encountering more and more limitations in
> the Microsoft development environment, especially in the stability and
> number
Elm Gysel wrote:
>/* perform query */
>query.execute(nr, Date.str(), Op, Hi, Lo, Cl, Vo);
> The problem is in the above line I think. If I comment it out the memory
> usage doesn't explode.
> I get around 1.5MB more mem usage each time I insert 2000 records.
> I have no clue what
u [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 24, 2001 9:42 AM
> To: 'Bill Adams'
> Subject: RE: pls help for index problem
>
> Thanks yr promptly reply !!
>
> It seems no any change(improvement) by running explain again after erase
> quotes. I also ran
Jason Whitlow wrote:
> Sorry for for the dumb question buuut.
>
> I have been connecting to a database on my localhost using perl's DBI.pm
>
> This is how I currently do it.
>
> use DBI;
> $data = "databasename";
> $driver = "DBI:mysql";
> my $dbh = DBI->connect("$driver:database=$data", "use
"Ing. Gustavo Edelstein" wrote:
> Thanks for your answer, but I need to know the names of the users currently
> logged in the database.
> Regards,
SHOW will do that as will 'mysqladmin processlist'.
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
b.
--
Tom Hicks wrote:
> I am thinking of running MySQL on my box for some work with PHP. I am
> concerned about the mods to the directory structure. I can't seem to
> find a list for mods it will make on RedHat7.1
> Could you please help me out with that?
Not sure what you mean by 'mod', but you can
"Oscar Castaneda V." wrote:
> Hi,
>
> i ran into a pretty boxy problem this morning, as I tried to login as mysql manager
> with
> #mysql -u root -p
> # (i forgot the password)
>
> its either this, or the other administrator, whom i cannot contact right now,
>changed the password without my know
Michael Blood wrote:
> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram.
>
> I have been getting an table handler returns error 127 error
>
> If I fix the table with myisamchk -r or -o it will work for a while and then
> I will get the same error again.
Try dumping and restroing the
Harpreet wrote:
> I am using concat in my sql and it runs fine on mysql client. But when use
> din php it gives me an error:
> Supplied argument is not a valid MySQL result resource in
> /var/www/html/scripts/cfg_code_delete.php on line <
>
> $ssql="select concat(category, "-", code) as fill_colu
"Wix,Christian XCW" wrote:
> Hi!
>
> How print the result from a query on my printer? I'm using the command line
> on linux.
> Lets say that I want to print everything from the table "Mercedes" in the
> database "Cars".
Pipes.
> How do I adjust the lenght of the lines?
man nenscript
Basically
Sommai Fongnamthip wrote:
> Hi,
> If I install mysql-4.0 to upgrade in mysql-3.23.xx with old setting value
> (use myisam type), Could I need to change or re-load my old db?
AFAIK, If you are keeping the table type, you can just copy the .MYI, .MYD, and .frm
files to the new location. O
Steve Meyers wrote:
> > > At a previous job, we tested a 32-bit hash function by running it
> > > against hundreds of thousands of unique URL's stored in our
> > > database. We found one collision. A 64-bit hash is billions of
> > > times better (4 billion, to be exact).
> >
> > Good to know.
Rafal Jank wrote:
> Hi!
> Is there a possibility to rotate mysql error log without stoping the server?
I was waiting for someone else to respond. But some possibilities are 1: use
the apache program 'rotatelog'. Not sure how you would do this.
In Linux you can rename the file while the server
TOMASSONI Dominique wrote:
> I stored a sql string in a file and when I launch it, it doesn't perform
> because the string is truncated before the end.
>
> Does mysql limit the length of an sql string ?
Not that I have ever run into. But ODBC does.
What command are you running? E.g. on linux
Martyn Wendon wrote:
> Hi,
>
> I'm new to MySQL and indeed SQL in general (coming from an MS Access and
> Flat Text File background).
>
> I have data in text form at the moment of the following fields:
>
> ID (Auto increment)
> ARTIST (Text up to 255 characters long)
> DESCRIPTION (Text up to 255
[EMAIL PROTECTED] wrote:
> Hi all,
> Is it possible to have an external file as an attachment in MySQL?
> An example would be a .gif, .doc, .ppt, .ram etc.
> If there is no way directly have MySQL table to store an attachment, is there
> any work around?
> Any guidance will be appreciated.
To st
kmlau wrote:
> I encountered a problem about indexing. I want to add index on timerecord
> field in table gw (shown as below) to speed up query relating with time.
> However, I use explain command (explain select * from gw where timerecord =
> '010902') to analyze the performace. As a resul
"M. Alageswaran" wrote:
> Thanks man, I tried that but still no hope..
> when I did a ps -ef | grep mysqld there is nothing in my output!
-ef is for HP-UX (I think). For Linux you want 'ps ax |grep mysqld' note
there is no dash in front of the ax.
b.
Carl Troein wrote:
> Bill Adams writes:
>
> > > This is odd. The only machine in cricalix.net (which I own/run) is a
> > > linux box. Who has a badly configured server out there?
> > Even more odd is that the 'from' address I saw was [EMAIL PROTECT
[EMAIL PROTECTED] wrote:
> >Description:
>The following is the error message:
> #scripts/mysql_install_db
> Could not load program ./bin/my_print_defaults:
> Dependent module libz.a(shr.o) could not be loaded.
> Could not load module libz.a(shr.o).
> Error was: No such file or directo
I realized that I was using an older version of libmysqlclient. So I recompiled and
linked the msql-mysql-modules against mysql-3.23.41...
Bill Adams wrote:
> o If there is no call to 'flush tables', even a small data load will cause
> myisamcheck to report "warning:
Duncan Hill wrote:
> On 22 Oct 2001 [EMAIL PROTECTED] wrote:
>
> > Antigen for Exchange found Unknown infected with
> > [EMAIL PROTECTED] (Norman) virus. The file is currently
> > Removed. The message, "SV: Here you have, ;o)", was sent from Pål
> > Wester and was discovered in Public Folders\Ma
Bill Adams wrote:
> Spoiler: You may be right about the bad libs...
[snip]
> *** OMG ***
> But haha I cannot believe this, I was just looking at the libraries linked by
> mysqld with ldd and it is using the informix libpthread.so. Hmm, crap. *me
> slaps head*
Small Update:
o
cedric wrote:
> /usr/bin/mysql start returns the error message:
> Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock.
> It was there, but now it's not.
That is the wrong command, use either safe_mysqld or mysqld_safe. Or possibly
/etc/rc.d/init.d/mysql start
> Also,
Mark Coldheart wrote:
> I've a little bit problem about running mysqld
> server. I've run "/etc/rc.d/init.d/mysqld start" it
> will appear "mysqld dead but subsys locked". But if i
> stop the service, it will fail. It is also happened
> when i kill the service.
Mm, redhat question.
Make sur
JohnHomer wrote:
> can mysql allow table joins when using UPDATE query? like
The manual answers these questions.
> update tranfer left join transferdetails
> on transfer.docno = transferdetails.docno
> set transferdetails.docno = concat('SJ',transferdetails.DocNo)
> where
> transferdetails.docn
Spoiler: You may be right about the bad libs...
Kyle Hayes wrote:
> On Thursday 18 October 2001 12:31, Bill Adams wrote:
> Hmm, 2.2 doesn't do SMP really well. However, its drawbacks are limited to
> underuse of the CPUs rather than any kind of corruption or other issue. You
&g
Kyle Hayes wrote:
> > I found yesterday (at the advice of this list) that adding an occasional
> > call to "FLUSH TABLES" fixed my corruption problems. I would do that right
> > before the disconnect or program exit.
>
> What kernel are you using? Some of the 2.4 series have... odd... behavior
1 - 100 of 106 matches
Mail list logo
