Re: database slow down

Hi! >This is a followup to my previous messages indicating database slow down. >After noticing the queries start to slow down earlier i decided to try and >get some debug info. a show table status had one interesting thing. > >| raw| InnoDB | Fixed | 169681 | 1030 | >17

Ayez pitié....

Bonjour, Je débute et cherche désespérement à envoyer à partir d'un client MySQL deux instructions à ma base. Que dois-je utiliser comme séparateur entre ces deux instructions pour les lancer en même temps? Merci d'avance. - B

strange behaviour

Hello, started a new compiled MysqlDataBase on my local Machine everything okay sofar. added a ./bin/mysqladmin -u root password '' (password omitted) no problem I tried it several times to log in to create a database but only getting this: >behrens@ws8:/home/behrens/behrens_local/mysql-3

Re: Ayez pitié....

[EMAIL PROTECTED] wrote: >Bonjour, >Je débute et cherche désespérement à envoyer à partir d'un client MySQL deux >instructions à ma base. >Que dois-je utiliser comme séparateur entre ces deux instructions pour les >lancer en même temps? > ; >Merci d'avance. > De rien. -

Procedure and Funcion

Hello, I am facing a big problem related to some queries. Is i use store procedure or function in My SQL. If yes , Please tells me the syntax. Thanks Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please c

how to fasten the insert sql execute

Hi, I want to insert 5M text into a table, and I execute the statement 10 times at one time. And then it execute very slowly, it use 27 minutes to insert all the 10 sql statements. Can anyone tell me how to optimize it, let it faster ? And Is the mysql locked on table or on the row?

Corrupted table

I wonder if anyone can assist me with this one. I appear to be getting sporadic corruption of a table that is then unrecoverable. The error I get is as follows: Incorrect information in file: 'user_admin_table.frm' This is a longshot but Has anyone seen this error before? -

Re: Inserting Data on top

Hi, thanks for your suggestion but I already have an update query in my code... Let me repeat the scenario.. I have 4 scroll boxes on my front page corresponding to SEC_ID1,2 3 & 4 respectively.. Everytime I feed data thru a backoffice into a db, it updates the existing first four fields in t

Re: mysql++ linker errors with VC++ ver6

Any clues on : "LINK : warning LNK4098: defaultlib "MSVCRT" conflicts with use of other libs; use /NODEFAULTLIB:library" when attempting to link an MFC program using Mysql++ tweaked for MSVC? Thanks, Pat... [EMAIL PROTECTED] --

How to compare a string with array-elements in a WHERE-clause?

How to compare a string with array-elements in a WHERE-clause? Hi! I do have a string in a table and i do have an array from a muliselect-field out of an html-site. The string of the table is one of about 20 possible strings, the array could contain no, one or more of these strings. I have tri

max size of index file

I'm running MySQL 3.23.21 on Windows98. I initialized a MYISAM table as follows: create table test1_i (id char(10) not null primary key,pwd char(17)) raid_type = 1; If a lot of data are inserted on it, the index file (MYI) cannot exceed 65536*1024-16 bytes, and comes to return the erro

Re: "full text search" of Mysql support Korean language ?

Hi! Unfortunately, I get too many e-mails to handle help requests which are sent directly to me. If you have purchased MySQL support, you may write to [EMAIL PROTECTED], and will get an answer quickly. If you would like to purchase support, please see the Support section of our web site: h

mysql_select_db() returns CR_COMMANDS_OUT_OF_SYNC

Hi all, I am trying to optimize my database tables at midnight, using winnt, delphi, and libmysql.dll. I want to execute a sequence like: mysql_select_db(sql, some_database); mysql_query(sql, 'OPTIMIZE TABLE MyTable'); mysql_select_db(sql, another_database);// error mysql_query(sql,

Re: HANDLER strange behaviour

Ian Collins writes: > If you open a table using HANDLER, > > e.g, HANDLER MYTABLE OPEN; > > then during the course of your application truncate that table, > > e.g, TRUNCATE TABLE MYTABLE; > > then you get some really wierd behaviour (my wierd behaviour was the > application rolling on a

Re: shutdown still a problem on Darwin

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Erik Price writes: >> Sinisa, everyone, >> >> That's great news! I'm excited to hear that. Which version would that >> be... 4.0? Or perhaps another 3.x version? >> >> In the meantime, my boss is going to wonder w

Re: strange behaviour

On Monday 19 November 2001 09:51, you wrote: > Hello, > started a new compiled MysqlDataBase on my local Machine > everything okay sofar. > added a ./bin/mysqladmin -u root password '' (password omitted) > no problem > I tried it several times to log in to create a database but only gettin

Re: mysql++ linker errors with VC++ ver6

Patrick Sherrill writes: > Any clues on : > > "LINK : warning LNK4098: defaultlib "MSVCRT" conflicts with use of other > libs; use /NODEFAULTLIB:library" > > when attempting to link an MFC program using Mysql++ tweaked for MSVC? > > Thanks, > > Pat... > [EMAIL PROTECTED] Hi! The latest VC++

Privileges question.

Hi All, I have some database named DB1 and one table in it named TBL1. In TBL1 there is 3 columns: name, address, id. There is mysql user named dbuser. Now, I want to give to 'dbuser' privileges to read ONLY 'name' and 'address' columns from table 'TBL1'. So, I added record to mysql.user table

Re: database slow down

There is definitly something to do with this row count that is causing a problem. My table uses no blobs. CREATE TABLE `raw` ( `cid` int(11) default NULL, `agent` char(255) default NULL, `referer` char(255) default NULL, `addr` char(15) default NULL, `via` char(255) default NULL, `forw

Re: Problem: myisamchk: error: Checksum for key....

On Thu, Nov 15, 2001 at 10:13:34AM +0200, Michael Widenius wrote: > There could also be a bug in the checksum handling in MyISAM. > > I did fix something with checksum handling in 3.23.43; Could you > please try 3.23.44 and see if this helps. > I've escalated problem to linux-kernel becouse my

RE: Privileges question.

> Hi All, > Now, I want to give to 'dbuser' privileges to read ONLY 'name' and > 'address' columns from table 'TBL1'. > So, I added record to mysql.user table (with no global privileges) - > thans to thar 'dbuser' is able to connect to MySQL server, and it > works OK. Further I added records to

[Solaris 2.7] Problem: MySQL lockup

I'm using MySQL 3.23.39 on Sun UltraSparc with Solaris 2.7. MySQL is started with bin/safe_mysqld When executing many SELECT in a short time (i.e. near 200 SELECT in 1 second), the mysqld process uses more an more CPU (96%) and seems to be locked : requests (SELECT) don't receive answers and are

Re: database slow down

Richard, are you sure you do not have open transactions in your system? How do you update the table raw or insert to it? Note that also an ordinary SELECT starts a transaction. The problem could be caused by old versions of rows in table raw. InnoDB cannot purge them if there is a transaction

How I can make an sql++ file under kdevelop

Somebody help me! I have an sqlpluplus file and I want compile and make it . I work with kdevelop. I set the following project options: COMPILER : -I/usr/local/include/mysql -I/usr/local/include/sqlplusint LINKER: -L/usr/lib/mysql -L/usr/lib/sqlplusint When I compile that file I don't have any e

how to login to dbases under mysql

first a thank to Ian Barwick,his tip saved my day. But now the next newbie Question! I want to insert users into the usertable of the mysql Tables how do i login? haven't found an answer sofar. Does anyone knows where such questions were already answered, so that i have not to put my nescience

segfault in mysql client

hi, just for information: i know the following line is bugous but, if i execute it in shell then i get a segfault. mysqldump -uCHANGED -pCHANGED --add-drop-table CHANGED Acc9200101Users,Acc9200101BonusCollectors,Acc9200101BonusFlow,Acc9200101Bonu sFlowLogs,Acc9200101CumulativeBonusCollectors,Ac

Re: how to login to dbases under mysql

On Monday 19 November 2001 16:25, behrens wrote: > first a thank to Ian Barwick,his tip saved my day. > But now the next newbie Question! I want to insert users into the > usertable of the mysql Tables > how do i login? > haven't found an answer sofar. > Does anyone knows where such questions wer

Problems running mysql_install_db

mysql-32.23.44 under RedHat 7.2 running scripts/mysql_install_db I've got the following " mkdir: cannot create directory `/data/mysql': Aucun fichier ou répertoire de ce type chmod: getting attributes of `/data/mysql': Aucun fichier ou répertoire de ce type mkdir: cannot create directory `/da

innodb locks

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm a regular mysql user, and a very newbie to innodb. :) I would like to use innodb because of its row-level locking feature. Presently I have to use table locks, and they're causing lots of speed problems. (I've tried Gemini tables, but mysql

undelete records ?

I've had a dig around the mysql website / google & can't find an answer so maybe someone here can help... we've noticed data/records deleted from mysql databases still appear to exist in the /var/lib/mysql/database/ files ? I presume they are flagged for deletion at a later date, if this is t

RE: Benchmarking

Hi, > -Original Message- > From: Rachman M.H [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 18, 2001 11:02 PM > To: [EMAIL PROTECTED] > Subject: Benchmarking > > > Dear all, > > I've been trying benchmark MySQL, SQL Server 7, and M$ Access 97. > But, SQL Server 7 and M$ Access is

Re: undelete records ?

the deleted rows will get re-used by inserts. however, you can always run OPTIMIZE TABLE XXX and that will clear the deleted rows thanks, -- Andrew - Original Message - From: "Steve Wright" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 12:03 PM Subject:

Re: Any suggestions on how to improve this SELECT query?

Hi. On Fri, Nov 16, 2001 at 01:58:54PM -0700, [EMAIL PROTECTED] wrote: > > Hi there, > > I'm wondering if someone can help me figure out how the following SELECT can > be improved. > > SELECT count(*) > FROM mm_ind_intrst mm0 STRAIGHT_JOIN ind > STRAIGHT_JOIN mm_ind_

Re: HANDLER strange behaviour

Hi! On Nov 19, Ian Collins wrote: > If you open a table using HANDLER, > > e.g, HANDLER MYTABLE OPEN; > > then during the course of your application truncate that table, > > e.g, TRUNCATE TABLE MYTABLE; > > then you get some really wierd behaviour (my wierd behaviour was the > applicatio

multithreaded application core dumps

Hi All, I have a multithreaded application using pthread library on solaris2.6. Application also uses mysql library to deal with mysql server. The version that I am using is 3.23.33. I am using the following libraries mysqlclient_r and z. But the application core dumps after running for sometime.

dec is treated as a reserved word.

>Description: The name dec does not work as an unqualified name when creating tables on inside queries. A syntax error is given. If escaped as `dec`, no error is given. dec is not on the list of reserved words. Thus this could be either a documentation or

question!!!

Hi All: I have Mysql,Php and apache webserver running on Freebsd 4.3 RELEASE, I need to connect via Web to an application done in php but that requests me user and password. - Before posting, please check:

Get a table of db and tables

Does anyone know how to create a table that has two columns: databasename, tablename that would list the databases and the tables in the databases? I need to do this in a sql statement to create a reference table similar to that of sysobjects in SQL Server or similar to the user_tables in Oracle

Re: What else

On Fri, 16 Nov 2001, Harvey Hou wrote: > I've downloaded MySQL 3.23.44 and compiled on a Sparc Solaris 2.6 > machine using gcc 2.95.3 and installed and started it all fine. But when > I goto try to use the MySQL client I receive an error that it cannot > find libstdc++.so.2.10.0. I've checke

Database help.

Hello, I am using a MySql DB for my Snort Intrusion detection system (Version 3.23.42). Four of my DB tables mysteriously got corrupted on Saturday evening. So this morning I ran the following commands to fix the tables. ./myisamchk --safe-recover /data/mysql/var/snort/event.MYI ./myisamchk --

Re: ??Sourcing in sections of a database create file

Hi. On Fri, Nov 09, 2001 at 08:21:34AM -0500, [EMAIL PROTECTED] wrote: > Years ago I worked on an RDBMS that had a feature to allow execution of > 'sections' of a command file, avoiding others. I am still ign scanning the > docs, but have not found anything similar in MySQL. > > For example

Re: Getting alll Tables from all Databases/catalogs

Hi. On Tue, Oct 09, 2001 at 07:18:53PM +0530, [EMAIL PROTECTED] wrote: > Hi, > > I am developing a application by using MySql database server. I have > requierment in my application, that i need to know/show all the tables > available in all the databases/catalogs of MySql. By using "show tables

Make $46,000 in 90 Days!

WORK AT HOME USING YOUR COMPUTER!!! _ Dear Friend, You can earn $46,000 or more in next the 90 days sending e-mail. Seem impossible? Read on for details (no, there is no "catch")...

Re: ??Sourcing in sections of a database create file

Benjamin Pflugmann wrote: > > Hi. > > On Fri, Nov 09, 2001 at 08:21:34AM -0500, [EMAIL PROTECTED] wrote: > > Years ago I worked on an RDBMS that had a feature to allow execution of > > 'sections' of a command file, avoiding others. I am still ign scanning the > > docs, but have not found anythi

help adding /rempoving users

We had a student setup the MySQL program and had written instructions on how to add users. Somehow those instructions got lost. I tried a grant command and an insert command but neither gave me a line in db that looked like the ones previous. How do I remove those lines to try again? Also d

Query speed seems wrong...

3.23.41 on Solaris I have an indexed table of cusips (9 character identifiers) which I am comparing against a lookup tables of over 1,000,000 securities, also keyed by cusip, both fields are char(9) fields. My query is taking over 3 seconds, which may be the best I can do, but I'm hoping I

Re: Sub Count

Hi. On Mon, Nov 12, 2001 at 01:26:01PM -0800, [EMAIL PROTECTED] wrote: > Howdy, > > I'm trying to write a select statement that produces a SUB COUNT of column > PORT_STATUS where (A) PORT_STATUS = 'up' and (B) PORT_STATUS = 'down'. I'd > like to do this in one statment with GROUP by LOCATION_T.A

No curses/termcap library found

I'm trying to compile MySQL from source, the above subject is the error I get after ./configure --prefix=/usr/local/mysql Help is sincerely appreciated! Gabe - Ender Technology Websites, Database Applications, Hosting (310) 516-7411 [EMAIL PROTECTED] http://www.endertechnology.com/ -

Re: No curses/termcap library found

Make sure you have an ncurses library installed and is in your ld path ldconfig -r | grep curses Gabriel Richards wrote: > > I'm trying to compile MySQL from source, the above subject is the error I > get after ./configure --prefix=/usr/local/mysql > > Help is sincerely appreciated! > > Gabe

Re: help adding /rempoving users

Please disregard this help request. I have found the notes I needed to add more students. Thank you, Diana >>> "DIANA CLEVELAND" <[EMAIL PROTECTED]> 11/19/01 2:57:05 PM >>> We had a student setup the MySQL program and had written instructions on how to add users. Somehow those instructions

RE: No curses/termcap library found

Thanks for the quick reply! Running ldconfig -r | grep curses gives me an error saying option requires an argument -- r What is ncurses library and an ld path? If I find / -type f -name "termcap" the file is found at /etc/termcap. Thank you for your help! Gabe -Original Message- From:

Re: No curses/termcap library found

Sorry; you'll have to check your local man page for the syntax to match your machine. "ncurses - CRT screen handling and optimization package" http://www.gnu.org/software/ncurses/ncurses.html If this is a solaris machine you can probably find a pre-built package at sunfreeware.com Gabriel Ric

Re: help adding /rempoving users

Diana, in regard to adding and removing users. What I do is just login to the database 'mysql' which holds the actual mysql information: connect mysql; Then, you can insert directly into the user table. Do you know enough about SQL to understand how the insert statement works? Basicall

Re: SSL Support

Hi. AFAIK, MySQL-Max is MySQL with different configure options (and therefore different components compiled in by default). The source tarball you found should contain everything you need to create your own "MySQL-Max" binary. Bye, Benjamin. On Wed, Nov 14, 2001 at 01:46:36PM +0200,

RE: dec is treated as a reserved word.

> >Description: > The name dec does not work as an unqualified name > when creating tables on inside queries. A syntax error is > given. If > escaped as `dec`, no error is given. dec is not on > the list of reserved words. Thus this could be > either a doc

Re: Zip Code proximity search

Hi. On Wed, Nov 14, 2001 at 10:02:54AM -0500, [EMAIL PROTECTED] wrote: > Currently, I am using the following query: > > SELECT DISTINCT o.szZipCode FROM tblZips z,tblZips o WHERE > z.szZipCode=$szZip AND (3956 * (2 * > ASIN(SQRT(POWER(SIN(((z.dblLat-o.dblLat)*0.017453293)/2),2) + > COS(z.dblLat*

Re: Zip Code proximity search

Benjamin Pflugmann wrote: > > Hi. > > On Wed, Nov 14, 2001 at 10:02:54AM -0500, [EMAIL PROTECTED] wrote: > > Currently, I am using the following query: > > > > SELECT DISTINCT o.szZipCode FROM tblZips z,tblZips o WHERE > > z.szZipCode=$szZip AND (3956 * (2 * > > ASIN(SQRT(POWER(SIN(((z.dblLat-o.

Removing all escape Characters?

Hi, I am currently trying to hack some coldfusion code into submission, and success grows closer and closer by the minute. But what would make my life INFINITELY easier would be to be able to disable all escape characters in varchars and other similar column types. Basically I am porting from a

mysql clients hang on error (4.0, Tru64 precompiled)

>Description: The mysql clients hang on a server error with mysql 4.0 (Tru64 precompiled). I can see with truss that the client is receiving an error message from the server, but it doesn't react. >How-To-Repeat: $ mysqlshow mysql notable >Fix: ? >Submitter-Id: >Originator:

Removing all escape Characters?

>>2. a coldfusion function to make the sql statements "safe". You only have to escape like 3 characters. ', ", and \. You could just do 3 string replacements or create your own function to perform 3 string replacements. Chris --

Re: Removing all escape Characters?

Problem with this unfortunately though is that i have probably 100+ sql queries spread over several hundred cfm pages to find and change. Plus if i ever want to go back to ms sql i have to switch them all back again. Dave At 05:07 PM 11/19/2001 -0500, you wrote: >>>2. a coldfusion function to ma

Re: downloading manual

Hi. Is there a problem with the ones on http://www.mysql.com/documentation/mysql/alternate.html ? You are a bit unspecific regarding where from you try to download. Alternatively try downloading a binary distribution (which will also contain the manual). Bye, Benjamin. On Sat, Nov 17

Re: Removing all escape Characters?

So, then even if you make a quote function that's too much work? On Monday 19 November 2001 03:21 pm, berndt wrote: > Problem with this unfortunately though is that i have probably 100+ sql > queries spread over several hundred cfm pages to find and change. Plus if i > ever want to go back to ms

Re: Query speed seems wrong...

On Mon, Nov 19, 2001 at 03:29:26PM -0500, Anthony R. J. Ball wrote: > > 3.23.41 on Solaris > > I have an indexed table of cusips (9 character identifiers) > which I am comparing against a lookup tables of over > 1,000,000 securities, also keyed by cusip, both fields are > char(9) fields. How

Query problem

Hi please help me, i have a query and in the where clause i want to compare dates, for example in asp i used select * from table where col_date1 <= now and col_date2 >= now what is the similar using mysql thanks for your answers -

Nusphere is spamming me

This e-mail address is brand new. I used it to subscribe to the MySQL list. I sent one e-mail to the MySQL list. I used it to send two e-mails to my web hosting provider. I used it to send one e-mail to [EMAIL PROTECTED] That's it! No others yet. I know my web hosting provider did not sell my e

Re: Query problem

Hello! > i have a query and in the where clause i want to compare dates, > for example in asp i used > select * from table where col_date1 <= now and col_date2 >= now > > what is the similar using mysql See http://www.mysql.com/doc/ Look up 'date'. See especially Date and Time Types, Date and

Re: Nusphere is spamming me

I can confirm that NuSphere subscribes to mailing lists and spams its posters, as this has happened to me too, under similar circumstances. Perhaps the admins of this list should remove NuSphere. On Monday 19 November 2001 04:55 pm, Michael A. Peters wrote: > This e-mail address is brand new. >

Re: Nusphere is spamming me

On Mon, Nov 19, 2001 at 03:55:48PM -0800, Michael A. Peters wrote: > If you use MySQL I respectfully ask to to avoid NuSphere. Do not > support spammers. > > This really ticks me off, I mean really ticks me off big time. Have > they no shame? I suspect they're getting desperate. Maybe their

Re: question!!!

Hi, - Original Message - From: "Webmaster" <[EMAIL PROTECTED]> > I have Mysql,Php and apache webserver running on Freebsd 4.3 RELEASE, I > need to connect via Web to an application done in php but that requests me > user and password. You may wish to be more specific about exactly what

SOURCE command somewhere in manual?

The bitbybit.dk MySQL FAQ says: How do I use a batch file with MySQL? >From within the MySQL client (v. 3.23.9 and above): mysql> SOURCE filename Is there really a SOURCE command? Where is it in the official manual? Also, if you have ---

compile failed on raq2 (MIPS Linux)

Machine info: --- - $ uname -a Linux www 2.0.34 #1 Thu Feb 25 21:04:19 PST 1999 mips unknown $ gcc -v Reading specs from /usr/lib/gcc-lib/mipsel-redhat-linux/egcs-2.90.27/specs gcc version egcs-2.90.27 980315 (egcs-1.0.2 rele

Re: dec is treated as a reserved word.

Hi Carsten, Tom, - Original Message - From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> To: "Tom McGlynn" <[EMAIL PROTECTED]> > > >Description: > > The name dec does not work as an unqualified name > > when creating tables on inside queries. A syntax error > > is given. I

Re: does MySql support Procedures, Events and Sequences

Hi, I am developing an application which shows Meta Data of the MySql database in Tree Structure. In this i am displaying nodes like Tables and its childs are Tables in the database, Indexes and its child nodes are indexes on all tables etc. I am confused weather MySql support Procedures, Events

how to repair myisam file .?

mysql> select * from abc1212 ; ERROR 1033: Incorrect information in file: './webbbs/abc1212.frm' mysql> optimize table abc1212 ; ++--+--+---+ | Table | Op | Msg_type | Msg_text

Exporting Data

Hello, Sorry about the OT, but I need to export data from various MySQL tables and import into Excell spread sheets. Was hoping someone could suggest the best format, TAB, CSV..etc delimited, which is the preferred format? thanks, mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=

urgent questions need your help!!

hi,everyone. i have wrong deleted the records from file; use the sql : delete from test where treeid like '%'; who knows how i can restore the records from the MYD file. i need your help. sincerely, zhangyun __ Do You Yahoo!? Yahoo! GeoCities - q

problem in SQL

Hello, I have a problem related SQL Query SELECT a.cAction_Name,a.nAction_ID FROM tbl_actionmaster a LEFT JOIN tbl_roleactionrelation b ON a.nAction_ID != b.nAction_ID WHERE b.nRole_ID = 3 group by a.cAction_Name In this query i wants to find Action name and Action Id from the Action Master

Error List

hello I wants to Know of web site where's i found the list of errors mysql have. thanks Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lis

Some amazing query numbers from MySQL 4.0

Just wanted to gloat about how much I love the new 4.0 version =) === Server version: 4.0.0-alpha-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: