FAQ

Search Discussions

410 discussions - 1,326 posts

  • Hi, I have done an incredibly stupid thing. I have a server that suffered a bit of a failure. It wasn't a hard failure, but it was enough of one to have to rebuild the server from scratch. I was and ...
    Curtis MaurandCurtis Maurand
    Dec 28, 2004 at 12:48 am
    Dec 31, 2004 at 3:33 pm
  • We just installed MySQL 4.1.7 (we were previously using 4.0.22) Our applications have now become extremely slow. When executing queries directly on the database server, our response times are "228 ...
    Frank FebbraroFrank Febbraro
    Dec 7, 2004 at 5:15 pm
    Dec 7, 2004 at 11:44 pm
  • Hi, All It's happen after upgrade from 3.23.46. Just look at this set of queries mysql select 1 or null; +-----------+ +-----------+ 1 row in set (0.00 sec) mysql create table a ( a int not null ); ...
    Vlad ShalnevVlad Shalnev
    Dec 2, 2004 at 11:48 am
    Feb 6, 2005 at 4:56 pm
  • Hi, I need to compare names from different tables and therefore I need to know the proper use of soundex. I googled for it, but could not find anything useful. And select soundex('text') is no help ...
    Raphael Matthias KrugRaphael Matthias Krug
    Dec 31, 2004 at 3:46 pm
    Jan 14, 2005 at 12:04 am
  • Need help with mysql restore speed Table crashed, had to restore from backup, I started the restore 2 weeks ago, the last change date on the files is the 8th, so mysql has not wrote data into the ...
    Matt_listsMatt_lists
    Dec 13, 2004 at 2:43 pm
    Dec 22, 2004 at 3:34 pm
  • Hi, I have 3 snort sensors logging to a central mySQL database after two weeks the size of the database is about 3.3GB and the machine is getting slow, as i'm not used to be working with mySQL is my ...
    Patrick MarqueteckenPatrick Marquetecken
    Dec 9, 2004 at 3:49 pm
    Dec 11, 2004 at 5:12 am
  • Hey guys , i know this has been discussed but looking through the archives i have more less hit a stand still , i have one big excel file which has data i would like to extract., Now i am no expert ...
    David Ziggy LubowaDavid Ziggy Lubowa
    Dec 7, 2004 at 1:03 pm
    Dec 9, 2004 at 4:18 pm
  • Hi all- I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported - I'm hoping someone can provide a quick alternative for me. I have a simple table Z with 3 columns, k1, k2, and ...
    Rick RobinsonRick Robinson
    Dec 3, 2004 at 3:22 pm
    Dec 4, 2004 at 4:08 pm
  • I've been struggling with this problem for the last few days. I've enlisted the help of some colleagues on the NYLUG (NY Linux User's Group) list but finally we figured this is the best place to look ...
    JsfJsf
    Dec 30, 2004 at 10:21 pm
    Jan 10, 2005 at 11:38 pm
  • Did you install MySQL on the other box? It sounds like you took a snapshot of the data but have not installed the executables yet. James Sherwood wrote:
    Victor PendletonVictor Pendleton
    Dec 15, 2004 at 2:47 pm
    Dec 16, 2004 at 10:25 am
  • Don't mean to start a discussion whatsoever, I love php, but one thing i can't do in php is Response.Redirect("page.asp") . Apart from that no complains so far :) * Happy New Year * Pedro Almeida. ...
    Mail.pmpaMail.pmpa
    Dec 31, 2004 at 2:27 am
    Dec 31, 2004 at 11:21 pm
  • Hi, I have (among others) three tables in my database that i am struggling with a join query on. The database holds dates for Bookings. If Users are Allocated to a particular Project they can be ...
    Shaun thornburghShaun thornburgh
    Dec 16, 2004 at 7:03 pm
    Dec 29, 2004 at 9:07 pm
  • I am experiencing extreme slowness performing a query in which 2 rows are returned hanging in the "sending data" status. Performing an index only query such as SELECT COUNT(*) is extremely quick so I ...
    Bryan HeitmanBryan Heitman
    Dec 23, 2004 at 4:17 am
    Dec 23, 2004 at 10:09 pm
  • Hi, Has anyone any benchmark between 4.0 and 4.1? MySQL website says that version 4.0 has some performance improvements but I´ve heard that MySQL-4.0 is 20% faster than MySQL-4.1. Thanks, Ronan
    Ronan LucioRonan Lucio
    Dec 7, 2004 at 12:41 pm
    Dec 7, 2004 at 8:18 pm
  • I am unable to define a foreign key with the following three tables. I am unable to find the error having searched the documentation and tried several variations. Note that I created the first two ...
    Steven P LongSteven P Long
    Dec 5, 2004 at 1:42 pm
    Dec 6, 2004 at 10:57 pm
  • In the MySQL Manual under InnoDB in the "Using Per-Table Tablespace" section it says clearly at the top: NOTE: CRITICAL BUG in 4.1 if you specify innodb_file_per_table in `my.cnf'! If you shut down ...
    Bruce DembeckiBruce Dembecki
    Dec 28, 2004 at 10:38 pm
    Jan 7, 2005 at 9:31 pm
  • On Windows... Which do i install first? PHP or MySQL? Thanks Gary
    GHGH
    Dec 29, 2004 at 3:42 pm
    Dec 30, 2004 at 12:33 am
  • I've been trying to implement full text searches. Genreally I use either LIKE or REGEXP for searches but wanted to try some Full Text Searches. It's wonderfully fast and is working well for full ...
    Michael J. PawlowskyMichael J. Pawlowsky
    Dec 3, 2004 at 3:30 pm
    Dec 16, 2004 at 12:19 pm
  • Hi, I need to get all the details of an employee whose salary is the lowest. I can do like this in Oracle select * from emp where id = (select min(id) from emp). Can we have any alternative in MySQL ...
    Lakshmi NarasimharaoLakshmi Narasimharao
    Dec 1, 2004 at 7:33 am
    Dec 2, 2004 at 11:06 am
  • Hi! I have a problem with getting the order I want on a table after new rows have been inserted. I try to simplify it...: I want to have a one-to-one relationship between 'name' and 'full'. Every ...
    Marcus ClaessonMarcus Claesson
    Dec 16, 2004 at 6:54 pm
    Jan 12, 2005 at 11:26 am
  • Hi all, I downloaded the source from bk tree and I saw the federated engine. Taking a look into documentation (http://dev.mysql.com/doc/mysql/en/index.html) I didn´t find anything. So, where I can ...
    Luciano BarcaroLuciano Barcaro
    Dec 20, 2004 at 11:59 pm
    Dec 21, 2004 at 4:09 pm
  • Dear list, Quick question. What's a reasonable length for a notes-type field? I couldn't really find any guidelines on the web so I'm thinking of just setting it to 65,535. Or is that ridiculously ...
    Chris KavanaghChris Kavanagh
    Dec 7, 2004 at 6:08 pm
    Dec 16, 2004 at 5:55 pm
  • hi, i compiled mysql-4.1.7 from source. actually, i want to configure a mysql cluster. from the documentation, i need to add some flag into a file called "my.cnf". i searched through the files. it ...
    Hiu Yen OnnHiu Yen Onn
    Dec 9, 2004 at 7:26 am
    Dec 13, 2004 at 11:45 am
  • Hi all; I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2 version downloaded from Mysql.com). The system is a Ultra-250 server with multiple CPUs and 2G RAM. There are many databases ...
    Paul SmithPaul Smith
    Dec 8, 2004 at 1:24 pm
    Dec 8, 2004 at 8:31 pm
  • I beginning to use MySQL clustering abilities for a large records keeping solution. I have installed 4.1.7 with the clustering components. The ndbd and ndb_mgmd processes are running. I can create ...
    Klaus BerklingKlaus Berkling
    Dec 6, 2004 at 9:15 pm
    Dec 7, 2004 at 10:34 pm
  • Hi, I'd really appreciate any help in speeding up this type of query SELECT BindId,RecordType from BrowseData WHERE DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07'; On a MYISAM table of ...
    Marc DumontierMarc Dumontier
    Dec 7, 2004 at 7:34 pm
    Dec 7, 2004 at 8:58 pm
  • Hi, I have a MySQL 3.23.55 server managing accounts on my exim mail server.. The table type on all tables MyISAM.. I have the MTA performing various queries for each incoming email - determining mail ...
    Andrew NelsonAndrew Nelson
    Dec 2, 2004 at 1:44 am
    Dec 2, 2004 at 1:57 pm
  • I'm working on a rather large database with many cross-linked tables currently using auto increment IDs. The system is primarily a web based system, however, there will be times that the system will ...
    Andrew MullAndrew Mull
    Dec 20, 2004 at 2:34 pm
    Jan 7, 2005 at 8:28 pm
  • When I execute SHOW TABLE STATUS on my master replication server, it shows an Update_Time for some tables that is more than 2 hours earlier than the Update_Time for the same tables on the slave ...
    Robinson, EricRobinson, Eric
    Dec 29, 2004 at 2:15 am
    Dec 30, 2004 at 11:15 pm
  • Hello. After installing the latest GA (Generally Available) version, 4.1.8, of the MySQL Server [1] on my Windows XP SP2 system, I noticed something strange with the PATH environment variable. Upon ...
    Ney André de Mello ZuninoNey André de Mello Zunino
    Dec 22, 2004 at 11:22 pm
    Dec 24, 2004 at 8:38 am
  • Hi everybody. I am rather new to MySQL (and to dba in general), so sorry for the lame question (and for my English). Our company is migrating several Access database to MySQL by now with good ...
    Nico AlbertiNico Alberti
    Dec 23, 2004 at 12:17 pm
    Dec 23, 2004 at 6:15 pm
  • Hi, I am using mysql 4.1 on linux. When I execute an mysql command (e.g., UPDATE statement) at the mysql prompt, it gives me warning if something is not running correctly. e.g., mysql update ...
    QunfengQunfeng
    Dec 21, 2004 at 11:43 pm
    Dec 22, 2004 at 7:03 pm
  • I'm new to MySQL and I was wondering which storage engine is the best choice for heavily-indexed, read-mostly data. From skimming over the documentation, it seems that MyISAM is a better choice since ...
    Homam S.A.Homam S.A.
    Dec 21, 2004 at 12:38 am
    Dec 21, 2004 at 10:54 pm
  • Hi, I came across this term several times while reading about character set and collation handling, e.g. in the last paragraph of the online manual section 10.3.2 ...
    Dr. Frank UllrichDr. Frank Ullrich
    Dec 17, 2004 at 9:02 am
    Dec 20, 2004 at 10:35 am
  • Hi, I have a problem with mysql 4.0.22 on fedora core 2. ..when I try: #/usr/bin/mysqladmin -u root password 'xxxx' /usr/bin/mysqladmin: connect to server at 'localhost' failed error: Can't connect ...
    SasaSasa
    Dec 14, 2004 at 11:41 am
    Dec 17, 2004 at 5:04 pm
  • Is there any way to limit drive usage per thread? I have a problem where an update thread will use 100 % of the drive, and simple index searches that should be instant will wait and wait and wait ...
    Matt_listsMatt_lists
    Dec 13, 2004 at 6:05 pm
    Dec 17, 2004 at 1:57 pm
  • hi all... where can i see what these warnings are. i get them when i do load data infile. i was looking for some kind of log under /var/logs/ or mysql/var/log but there isn't a log file for mysql at ...
    Kalin mintchevKalin mintchev
    Dec 9, 2004 at 11:53 pm
    Dec 10, 2004 at 5:10 am
  • Does anyone know where I can get the [latest] free version of MySchema? Seems both brandosoftware.com fell off the edge of the world - MySchema along with it. Failing that I'm looking for a ...
    Attila HorvathAttila Horvath
    Dec 1, 2004 at 7:08 pm
    Dec 1, 2004 at 10:26 pm
  • [snip] We loaded a new server with Windows XP professional, and mysql server 4.1. We can't get Mysql to run. After installing mysql and trying to execute it we get the following message: ERROR 1045 ...
    Tom CrimminsTom Crimmins
    Dec 30, 2004 at 6:37 pm
    Jan 3, 2005 at 3:31 pm
  • Hi, I have two tables, seemigly very similar setup; the primary key is the combination of two columns. With mysqldump, however, the table definition of the two tables looks different. Mysqldump on ...
    Gaspar BakosGaspar Bakos
    Dec 28, 2004 at 7:48 pm
    Dec 29, 2004 at 10:32 am
  • I have a 152MB MyISAM table that I am trying to execute a simple select statement on, I need to retreave all rows with a given index, sorted by date. This is taking a very long period of time to ...
    Rob KeelingRob Keeling
    Dec 23, 2004 at 5:55 pm
    Dec 24, 2004 at 12:35 pm
  • Hey, A couple days ago my SQL server started hogging the entire CPU for no reason that I can find. I'm running MySQL 4.0.20 on Slackware 9.1 (i think), kernel version 2.4.22. The process using up all ...
    Daniel AndersenDaniel Andersen
    Dec 17, 2004 at 12:03 am
    Dec 22, 2004 at 2:23 am
  • Is there any way to make sum() return "0" instead of "NULL" when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat "NULL" as "0" when dealing with ...
    Gustafson, TimGustafson, Tim
    Dec 16, 2004 at 5:42 pm
    Dec 17, 2004 at 1:23 am
  • Hi! Could someone please explain to me why the second query below is faster then the first query? The only difference between the two is that ext_doc_id's value is quoted. Index and column ...
    Dave JuntgenDave Juntgen
    Dec 15, 2004 at 3:44 pm
    Dec 15, 2004 at 6:02 pm
  • Hi, I am running an instance of MySQL 4.0.16, mostly using MyISAM tables on a 18G 10kRPM SCSI drive w/ ext3, the server having 2G RAM and a 2.8G HT P4, on a RedHat 9 install. Would some of you ...
    Fagyal CsongorFagyal Csongor
    Dec 13, 2004 at 12:06 am
    Dec 14, 2004 at 5:46 pm
  • Hi, I need to increase the innodeb_log_file_size parameter, but when I set it higher, mysql don´t starts and give the follow erro: -------------------- 041210 13:27:40 mysqld started InnoDB: Error: ...
    Ronan LucioRonan Lucio
    Dec 10, 2004 at 5:38 pm
    Dec 10, 2004 at 6:33 pm
  • Hi, I have this weird things happens. kaspia:/var/lib/mysql# mysql --version mysql Ver 12.22 Distrib 4.0.21, for pc-linux-gnu (i386) mysql show grants for "root"@"localhost"; ...
    Batara KesumaBatara Kesuma
    Dec 3, 2004 at 12:44 pm
    Dec 6, 2004 at 1:25 pm
  • This all started when one of the 16 byte binary primary keys kicked out a duplicate key error. It seems mysql does not store the last byte of the binary value if it is a space. That is, ascii 32 or ...
    Mark MaunderMark Maunder
    Dec 3, 2004 at 6:47 pm
    Dec 3, 2004 at 9:17 pm
  • Hi All, In oracle I can query user_constraints, user_indexes for getting the constraints and indices for a particular table. User_constraints and user_idexes are view which holds all the constraints ...
    Lakshmi NarasimharaoLakshmi Narasimharao
    Dec 2, 2004 at 10:53 am
    Dec 2, 2004 at 2:33 pm
  • I'm storing telephone number (US) in 10 digit varchars. If I want to do a search on just the area code, is there a way to limit it to just the first 3 digits of the string ? Thank you Stuart
    Stuart FelensteinStuart Felenstein
    Dec 1, 2004 at 4:46 pm
    Dec 1, 2004 at 6:44 pm
Group Navigation
period‹ prev | Dec 2004 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions410
posts1,326
users424
websitemysql.com
irc#mysql

424 users for December 2004

Gleb Paharenko: 93 posts Sgreen: 54 posts Heikki Tuuri: 38 posts Roger Baklund: 29 posts Jay Blanchard: 26 posts Michael Stassen: 22 posts Matt_lists: 19 posts Victor Pendleton: 19 posts Lakshmi Narasimharao: 17 posts Anil Doppalapudi: 17 posts Rhino: 17 posts Dathan Vance Pattishall: 16 posts Ronan Lucio: 16 posts Eric Bergen: 14 posts Paul DuBois: 14 posts Sasha Pachev: 13 posts Stuart Felenstein: 13 posts Dan Nelson: 12 posts Frank Febbraro: 10 posts Kevin A. Burton: 10 posts
show more
Archives