best way to query this table

Hello, I have a table that has a column that has a timestamp Column. This table is going to get very large ( 1 or 2 million rows) and will be queried alot. Alot of these queries will be against timestamp column. These queries will be like, getting entries for today, this week and this month I

help trying to add an autoincrement col to an exisiting table

Hello, currently i have the following table structure CREATE TABLE users ( uname varchar(20) NOT NULL default '', passwd varchar(15) NOT NULL default '', fname varchar(25) NOT NULL default '', lname varchar(40) NOT NULL default '', dir varchar(28) NOT NULL default '', pict varchar(50) NOT N

Re: table hangs on a large query

On 8/15/06, mos <[EMAIL PROTECTED]> wrote: At 09:24 AM 8/15/2006, you wrote: >Dan > >thanks for the help >so i will remove the redundant keys >below is the explain plans >but here is the weird part. >I exported the database and imported into a testDB to play with and >the query that was giving me

Re: table hangs on a large query

(id), UNIQUE KEY id (id), KEY id_2 (id), PRIMARY KEY implies UNIQUE, and the id_2 index is redundant to either of the others. Dan On 8/14/06, Randy Paries <[EMAIL PROTECTED]> wrote: > Hello, > I have a table (see below) that has 111599 records in it. > When i do a query like select *

table hangs on a large query

Hello, I have a table (see below) that has 111599 records in it. When i do a query like select * from gallery_object where dir = 'dirname' this query takes a very long time and while the query is going on it locks the entire table so no one else can query it yet a query like select * from galler

Help with this query. How to do a group by on a datetime just the month/day/year

Hello, Not sure if i can do this. I have a table with a datetime column I would like to do group by a day of the month. if i do something like select count(*) from MTracking where mallarea=1001 group by timeofclick every one is listed because time. So is this possible? Thanks Randy -- MyS

please help, can not delete database

Hello, Not sure what is going on i have mysql Ver 12.22 Distrib 4.0.17, I have a database that i can not delete. i do this #mysqladmin drop billmax -u admin --password Enter password: Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed.

mysqldump question

Hello, I have just created a new fedora 4 box with the latest mysqldump mysqldump Ver 10.9 something has changed. Before all my tables entries had their own insert statements for each row. Now each table has one insert with all the values appended to the end. is there switch that puts it back t

RE: looking for direction on how to debug this message

: Re: looking for direction on how to debug this message See: http://dev.mysql.com/doc/mysql/en/communication-errors.html http://dev.mysql.com/doc/mysql/en/making-trace-files.html Randy Paries wrote: >Info: > >DB Server >Mysql 4.0.20 >Mandrakelinux release 10.1 (Official) for

RE: Log file full of Got an error reading communication packets

] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 21, 2005 8:19 AM To: Randy Paries Cc: mysql@lists.mysql.com Subject: Re: Log file full of Got an error reading communication packets "Randy Paries" <[EMAIL PROTECTED]> wrote on 09/21/2005 08:56:13 AM: > Hello, > My log file

Log file full of Got an error reading communication packets

Hello, My log file is getting filled with these. Can someone tell me what these mean? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication pac

looking for direction on how to debug this message

Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an error reading communication packet

RE: (FIXED...)moving DB from one box to another.

another. Ian Sales said: > Randy Paries wrote: > >> >>The problem is I get this wonderfully verbose :-( error message >>:::ERROR at line 362701 >> >> >> >> > - MySQL can't parse something on line 362701 of your dump file. One > possibi

RE: moving DB from one box to another.

Sorry, When I do the mysql dbname < oldbox.sql I get the error message It creates mysqldump dbname -h oldbox > oldbox.sql fine Thanks -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:25 PM To: Randy Paries; [EMAIL PRO

moving DB from one box to another.

hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a mysqldump dbname -h oldbox > oldbox.sql then

Help getting mysqld to read my my.cnf on start from init.d on mandrake 10.1 and mysql 4

Hello, I am building a new DB box. The box is mandrake 10.1 and mysql 4.0.20 All my other boxes are RH9 and mysql 3 The one problem I am having is they appear to do the my.cnf differently There was no my.cnf in the /etc dir, so I created one from my-huge.cnf and placed it in the /etc But the

Building new db linux box, Hardware questions

Hello, I am building a new linux box , just to be an mysql server I have a couple of questions. 1) would it be better to go brandnew with a single processor or like a quad p4 that's a year or two old. 2) I am going to running raid 5, so I assume that I should run scsi drives? 3) my database i

Trying fulltext search

Hello I have a table CREATE TABLE community_files ( id int(3) unsigned NOT NULL auto_increment, type int(10) unsigned NOT NULL default '0', category_id int(10) unsigned NOT NULL default '0', filename varchar(50) NOT NULL default '', path varchar(255) NOT NULL default '', description va

Query help

Hello, I have a table Mytable:: int ID varchar Title varchar description Mytable will have many records. In my queries (via web page) I want to display 10 records at a time. ID is an auto increment key. But there is a possibility that that record could be deleted. So is there are way to get

Best practice question

Hello All, I have a design question I have a table that represents a Newsletter page. This newsletter can be single or 2 columns Here is my question. Currently the table is defined as Int articleID Int pagenum Texttitle Textbody Texttitle2 Textbody2 So here is my ques

very simple query question

Hello i have a simple query select u.*,p.* from users u, profiles p where u.uname = p.uname and u.level != 0 Is there any tricks to make this use an index. If i do level=0 is uses an index , but != does not. -- MySQL General Mailing List For list archives: http://lists.mysql.com

question about number of processes.

Hello I have a number of servers. I have one running RH7.3 with mysql-3.23.56-1.73 one running RH9 with mysql-3.23.58-1.9 My question is when i do a ps -ef on RH7.3 a get a number of /usr/libexec/mysqld on RH9 i only get one. can someone please explain why. does RH9 display thread differe