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 |

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. -

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:

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

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

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

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

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:

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 free in 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 why I'm not populating

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 getting

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++ version of

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

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,

RE: Privileges question.

Hi All, cut 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

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

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

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 won when

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_intrst

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 anything

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

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

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: 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 got lost.

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

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?

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

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) +

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

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: submitter ID

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 make

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

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 large

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

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 Time

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 you

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

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. If escaped as

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

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

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)

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: