improving query responce time

Hello, I am a software developer working for Lntinfotech, I am using Mysql-4.1.3b-beta-nt,ODBC3.5.1 for an application development. the application which i am developing is a client-server architecture based,in which we have to store data of the BSM(Base Station Manager of CDMA network). the nat

Re: help with dbf and dbt

On Mon, 8 Nov 2004, José Antonio Viadas O. wrote: > Can someone help me, i have two files one dbf and one dbt thant i need to > import it in mysql, can someone help me telling me how can i do this. Have a look at dbf2mysql (http://dbf2mysql.soourceforge.net) - this will import .dbf files. I'm not

Subject Headings in Tables

I have a series of database tables focusing on the world's nations. There are basic tables that give each nation's abbreviation and parent (e.g. Eurasia) and other tables that focus on information about the people, government, etc. Now I want to introduce some regional headers. For example, curren

Re: NULL values from LOAD DATA infile

Rachael LaPorte Taylor wrote: I'm trying to import a file using LOAD DATA INFILE into a table containing columns that default to NULL. See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html : | Handling of NULL values varies according to the FIELDS and LINES options in use: | | * For the default

Re: how to use except operation (corrections for the return results)?

Something like: select * from table as t1, table as t2 where t1.study=t2.study and t1.keyword = 'K1' and not t2.keyword ='K2' Santino At 11:57 -0800 8-11-2004, L a n a wrote: Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword = b" returns SQL error I've

NULL values from LOAD DATA infile

I'm trying to import a file using LOAD DATA INFILE into a table containing columns that default to NULL. However, values load into the table as 0 (zeros). What can I do to have these default to NULL? mysql> describe table column; Field | Type | Null | Key | Default | Extra | column | i

Re: problem retreiving data (mysql++1.7.17)

Warren Young wrote: if (rs.begin() != rs.end()) That will never be true for any STL or STL-like container. I think you want something like (rs.size() > 0). Sorry, I mean that will _always_ be true. 1. Glib::ustring lastname = row["LastName"]; See the ChangeLog for why this does not work. It's in

Can't get count(go._iso._objective_id) to return 0 values

I am trying to merge the following 2 selects into one select. !!! Returns all custom objectives. Another check is needed to see if in use. !!! SELECT _objectives.id, _objectives.subjects_id, _objectives.subjectHeadings_id, _objectives.name, _objectives.active, _objectives.displayOrder FROM go._obj

Re: problem retreiving data (mysql++1.7.17)

David Kinyanjui wrote: I have a mysql++ question... I'm not sure if this is right list to post to. It isn't. The MySQL++ mailing list's home is http://lists.mysql.com/plusplus Well, I just upgraded mysql++ from version 1.7.9 to 1.7.17. 1.7.21 is the current version. See

MySQL logs and restore data

I deleted some data in mysql. Is it possible to restore the data. Maybe using MYSQL logs? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

XML to Mysql

This may just sound stupid but I am going to ask anyway.   We run a search engine and we bring in 3+ XML feeds from other search engines  Via perl and PHP.   So we can end up with 300 results listed for EACH SEARCH.  They are only valid for that ONE SEARCH but we need to track every click f

MySQL logs and restore data

I deleted some data in mysql. Is it possible to restore the data. Maybe using MYSQL logs? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

help with dbf and dbt

Can someone help me, i have two files one dbf and one dbt thant i need to import it in mysql, can someone help me telling me how can i do this. Thanks. José Antonio Viadas O. Director de Desarrollo Denumeris Interactive TEL. Oficina: 56.64.31.71 TEL. C

Re: Help with SLOW query

You are always getting "filesort, where and temporary" because the optimizer cannot use an index. Both your WHERE clause and your ORDER BY clause use computed values. None of those values exist in an index because you calculate them for every query. What I did below is not a refactoring, just

Re: Not returning NULL or 'N/A' fields?

- Original Message - From: "Steve Grosz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 08, 2004 3:19 PM Subject: Not returning NULL or 'N/A' fields? > Is there a way to have a select NOT return columns that have either a > 'null' or 'n/a' value? I have some shared

Re: how to use except operation?

ian douglas wrote: Id Study keyword 1 AK1 2 AK2 3 BK1 4 BK2 5 CK1 6 Ck3 SELECT DISTINCT Study FROM yourtablename WHERE keyword='K1' AND NOT keyword='K2' That *should* give you a single entry for 'C' since its keywords do not match both 'K1' *and* 'K2' No. Rows 1

Not returning NULL or 'N/A' fields?

Is there a way to have a select NOT return columns that have either a 'null' or 'n/a' value? I have some shared specs for some products, and some of the fields aren't used for all products, so I have blank entires in those columns for those specific products. I'd like to return all the info t

Re: how to use except operation?

Id Study keyword 1 AK1 2 AK2 3 BK1 4 BK2 5 CK1 6 Ck3 SELECT DISTINCT Study FROM yourtablename WHERE keyword='K1' AND NOT keyword='K2' That *should* give you a single entry for 'C' since its keywords do not match both 'K1' *and* 'K2' But your posting *was* a little

Re: how to use except operation?

L a n a wrote: Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword =b" returns SQL error This makes no sense. You have no column named data_id. You have no columns named a or b. You have no no keywords that have a value of 'a' or 'b'. What exactly are yo

how to use except operation (corrections for the return results)?

Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword = b" returns SQL error I've got the following not working solutions to my problem: SELECT data_id FROM table WHERE keyword = a AND keyword <>(or !=) b SELECT data_id FROM table WHERE keyword = a AND NOT

how to use except operation?

Hello, I've had a problem: statement "SELECT data_id from table WHERE keyword = a NOT keyword =b" returns SQL error I've got the following not working solutions to my problem: SELECT data_id FROM table WHERE keyword = a AND keyword <>(or !=) b SELECT data_id FROM table WHERE keyword = a AND NOT (

Installation of system tables failed

Hello, I am trying to install the system db with mysql 4.1.7 on my FreeBSD-4.10 but I encounter some problems. You can find on my perso page how I compile mysql (subfolder fbsd-secure). This is what I did... (root) # mysql_install_db --user=mysql --datadir=/home/mysqld/ Installing all prepared t

Re: MySQL replication

Ahh, thanks and to Bill Alliar as well. I just needed to re-read everything, I think that answers my questions. This full situation is this. On each slave I have a database, radius, which holds auth info and accounting info for each user. I want to limit the accounting info on the slave servers

Joins in MySQL give weird results

Hi, I have the following tables in mysql: mysql> select * from a; +--+ | col1 | +--+ |1 | |2 | |3 | +--+ 3 rows in set (0.00 sec) mysql> select * from b; +--+--+ | col1 | col2 | +--+--+ |2 | b| |3 | c| +--+--+ 2 rows in set (0.00 se

Re: replication problems

After a little more RTFM-surfing, I found the "GRANT REPLICATION SLAVE" for the master, and a "LOAD DATA" worked just fine. Except that changes made on the master are not automatically picked up by the slaves. Am I missing something? -id -- MySQL General Mailing List For list archives: http://li

Re: replication problems

Answered my own question, sorry for the quick posting... When I was trying to do the "LOAD DATA FROM MASTER", with the master set as "GRANT ALL ON *.* TO 'repl_user'@ ..." the slaves were reporting an error that stated I needed to "GRANT SUPER,REPLICATION CLIENT" on the master, which didn't work

replication problems

One master, two slaves, mysql 4.1.7 installed via compiled source code, on RedHat 8.0 On the master system I did this: grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname1' identified by 'repl_passwd' ; grant SUPER,REPLICATION CLIENT on *.* to 'repl_user'@'known.hostname2' iden

(Errcode: 24) when using LOCK TABLES doing backup

Hello, We have an issue related to backup a specific db mounted on MySql 3.23.58 and RedHat 8 OS. The server is running Brightor Arcserve Backup agents for MySQL and cannot backup the entire database. Our Computer Associates support say that this error is originated by MySQL, but only occur wh

Help with SLOW query

Help: (and apologies if this is posted to the wrong list..)(pls let me know where to post if so.. Thx ;-) I have *inherited* an App that uses PHP / MySQL. THe internal search function within the application that I am supporting uses the following DB Table structure and runs the Query below to r

Re: 4.1.7 serious problems

Heikki Tuuri wrote: Ugo, - Original Message - From: "Ugo Bellavance" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, November 05, 2004 3:42 PM Subject: Re: 4.1.7 serious problems Gleb Paharenko wrote: Hi. There were several posts in list like yours. Do you use InnoDB

Re: Fast method needed to determine if a table is corrupt

Tim Murtaugh wrote: Hi, I'm using MySQL server version 4.0.15a in an embedded envirionment (as a standalone server, I'm not using the embedded server library). I have 128 MB of memory and disk space is tight. I'm using MyISAM tables. If my system loses power, some tables are left in a corrupt st

Re: Fast method needed to determine if a table is corrupt

In the last episode (Nov 08), Tim Murtaugh said: > I'm using MySQL server version 4.0.15a in an embedded envirionment > (as a standalone server, I'm not using the embedded server library). > I have 128 MB of memory and disk space is tight. I'm using MyISAM > tables. > > If my system loses power,

Fast method needed to determine if a table is corrupt

Hi, I'm using MySQL server version 4.0.15a in an embedded envirionment (as a standalone server, I'm not using the embedded server library). I have 128 MB of memory and disk space is tight. I'm using MyISAM tables. If my system loses power, some tables are left in a corrupt state. As stated in

Re: Tables Crash when I Delete A Row

Hi Gleb , thanks for the answer. Thats exactly what the problem was. I needed to rebuild the fulltext indexes on my tables. After I did that , the problem seems to have magically disappeared. :) Cheers, Aaron - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <[EMAIL PR

problem retreiving data (mysql++1.7.17)

Hello; I have a mysql++ question... I'm not sure if this is right list to post to. Well, I just upgraded mysql++ from version 1.7.9 to 1.7.17. Now, my problem is I don't seem to be getting the collect data from a table. I have an order table with the following cols: LastName, FirstName, OrderDate

Re: Sequencial Replication

Gleb, He was wondering if there were any plans to provide multiple slave SQL threads so that the slaves can process more efficiently NOT if the slave process is multi-threaded. He understood that there would be challenges to multithreading the slave's query processor (including reader query s

Problem connecting to MySQL server

Hey there I have upgraded the MySQL server on my Windows machine to 4.0.22 following the docs at: http://dev.mysql.com/doc/mysql/en/Windows_upgrading.html When I start the server using NET START MySQL the server starts with no problems and the following is written to my error log: 041108 14:24

Re: Sequencial Replication

Hello. MySQL slave receives all updates, but executes them in queue. More about implementation of replication you can read at: http://dev.mysql.com/doc/mysql/en/Replication_Implementation_Details.html Arvind Gangal <[EMAIL PROTECTED]> wrote: > Hi Gurus, > > As I understand the slav

Re: MySQL replication

Hello. See: http://dev.mysql.com/doc/mysql/en/Replication_Options.html Dave Goodrich <[EMAIL PROTECTED]> wrote: > Good morning, > > Been reading through the docs and checking online info and I m still > looking for a answer. I have a radius DB on two radius servers and I > want to

MySQL replication

Good morning, Been reading through the docs and checking online info and I m still looking for a answer. I have a radius DB on two radius servers and I want to sync them via a master server. Seems easy enough, but I have one table which holds accounting data. How long a user has been online, whe

Problem combining inner and right joins

Hi there, For bother mysql 4.1.7 and 4.0.18 on windows. I had the following behavior when combining inner joins and right joins: -- (1) I create a table A and insert some values in it CREATE TABLE A ( Id smallint, Name varchar(20) ) ; INSERT INTO A VALUES (1,'Hello'); INSERT INTO A VALUES

Re: load index into cache not working

I posted a detailed description of a similar problem one week ago to general and then later to internals with no response to either (title "load index into cache doesn't?"). Using load index into cache to preload a 1GB index into a 2GB cache comes back in 0.0 seconds as 'done'. But there is no di

mysqld segfaults.

Hi, I have problem with my mysqld, when its receiving alot of connections and at the same time doing insert/delete/update/select on the same table mysqld segfaults and restarts 041108 0:59:08 Warning: Got signal 14 from thread 162602 Segmentation fault 041708 13:17:54 -e \nNumber of processes

Sequencial Replication

Hi Gurus, As I understand the slave replicates with the master reading one query at a time from the binlog files. And at times the slave comes across a long update query and unless this has completed it will not pick up the next sql even though the other sql is on other table or may be another da

Re: Tables Crash when I Delete A Row

Hi. >From which version did you upgrade? If you upgraded from 4.0 you should carefully read: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html May be REPAIR with USE_FRM will be helpful. Some times after ugrade tables have to be rebuilt or repaired. Aaron <[EMAIL PROTECTE

Re: order by in different languages..

Hi. May be it will be helpful: http://dev.mysql.com/doc/mysql/en/Charset.html For commercial support go to: https://order.mysql.com/?ref=ensita Alaios <[EMAIL PROTECTED]> wrote: > Hi.. Listen to a peculiar problem. > We need to order by a column which includes Greek > language. T

Re: Temporary Upgrade for Cpanel?

Hi. See: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html >I read on the Cpanel.net forum that you can start the 4.0.22 mysql with >a --new switch to use it as 4.1.7 so you can see if its compatible with my >software. > >Is this true and exactly how? >Thanks >Donny Lairson

Re: settingup mysql in suse linux

Hi. See: http://dev.mysql.com/doc/mysql/en/Access_denied.html vt sharravanan <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii, 6 lines --] > > i have suse linux in my system and iinstalled mysql through rpms > (server,client,devel,shared,max). iam having pro