FAQ

Search Discussions

93 discussions - 372 posts

  • hello, i have a working master-slave replication, the problem i find is that if i restart the MASTER there is a difference in the MASTER_LOG_FILE and MASTER_LOG_POS on the SLAVE. what is the correct ...
    Norman KhineNorman Khine
    Aug 26, 2010 at 1:04 pm
    Aug 31, 2010 at 11:40 pm
  • Hello Gurus :-) I was running a simple load generator against our 16GB Dual Quad core server and it pretty much came down to it's knees within two hours of running tests. The customer DOES NOT WANT ...
    Nunzio DaveriNunzio Daveri
    Aug 4, 2010 at 6:40 pm
    Aug 18, 2010 at 2:58 pm
  • Hello Gurus, is there a way / script that will let me DROP ALL the indexes in a single database? for example, lets say my database is call db_Animals, and inside db_Animals there are 97 tables, is ...
    Nunzio DaveriNunzio Daveri
    Aug 9, 2010 at 8:03 pm
    Aug 11, 2010 at 2:34 pm
  • I have been trying to speed up an ALTER TABLE command that adds a column to a large InnoDB table of about 80M rows. I have found and tried many different methods, but they are all slow.I have tried ...
    Xn NoobyXn Nooby
    Aug 18, 2010 at 3:34 pm
    Aug 21, 2010 at 6:56 pm
  • Hi, I'm tasked with generating a list of fixtures from a table of teams, whereby each team plays each other home and away. Does anyone have any experience generating such information using MySQL ? ...
    Tompkins NeilTompkins Neil
    Aug 19, 2010 at 2:13 pm
    Aug 20, 2010 at 6:52 pm
  • Dear All, I'm needs a way to upload data from excel to the mySQL database. Dear all, I need help is how to upload data from excel columns and load into mysql database using php? Thanks HaidarPesebe
    HaidarPesebeHaidarPesebe
    Aug 3, 2010 at 9:23 am
    Aug 4, 2010 at 8:17 am
  • Hi listers mysql server here is mysql-server-5.1.48-2.fc13.x86_64 this morning i created a message with a literal string in chinese in it. the messages in the application i used are stored in a mysql ...
    MysqlMysql
    Aug 31, 2010 at 12:30 pm
    Aug 31, 2010 at 3:12 pm
  • Hello! I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL use 75% (100% = 8GB) of memory. When cgi programs use more than 25% of memory and all SWAP file (8GB), kernel run ...
    Евгений КилимчукЕвгений Килимчук
    Aug 5, 2010 at 6:43 pm
    Aug 6, 2010 at 4:38 am
  • Hi I've a soccer application consisting of managers, teams players and fixtures/results. Basically each manager will get points for each game which will depend on the result. What would be the best ...
    Neil TompkinsNeil Tompkins
    Aug 31, 2010 at 7:49 pm
    Sep 1, 2010 at 9:52 pm
  • Hello, For simplicity's sake, let's say I have three fields, A, B and C, all of which are integers. I'd like the value of C to be equal to A less B (A-B). Is there a way I can perform this ...
    BB
    Aug 21, 2010 at 6:25 am
    Aug 22, 2010 at 12:14 am
  • I am trying to produce charts for large amounts of data. I already limit the user to a smaller time frame in order to reduce the possible data points, but still can end up with far more data points ...
    Bryan CantwellBryan Cantwell
    Aug 20, 2010 at 3:12 pm
    Aug 20, 2010 at 3:37 pm
  • Hi, Whenever i run any commnd on mysql it gives message as below then gives the result successfully. What is the reason of the below error message : ERROR 2006 (HY000): MySQL server has gone away No ...
    Jitendra ranjanJitendra ranjan
    Aug 18, 2010 at 4:11 pm
    Aug 20, 2010 at 2:54 pm
  • The main problem - if add in Join on `OR`-condition, select become VERY slow. I realy have to use this condition. -- -------------------------------------------------------- -- -- `tree_data` -- ...
    Влад РВлад Р
    Aug 17, 2010 at 9:22 am
    Aug 18, 2010 at 2:45 pm
  • Hello, I compiled a version of mysql 5.1.49 and it crashed a couple of times already. I recompiled it with debug enabled and this is the error I got. Do any of you guys/gals have any suggestions? ...
    Yectli HuertaYectli Huerta
    Aug 12, 2010 at 9:33 pm
    Aug 13, 2010 at 7:02 pm
  • Hi, I wondered if anyone can offer me some help with regards the following issue I'm having. Basically, I've the following table structure containing rows of results between two football teams. The ...
    Tompkins NeilTompkins Neil
    Aug 24, 2010 at 1:45 pm
    Sep 6, 2010 at 2:10 pm
  • Hi, I've the following basic SUM for our products based on a rating. SELECT SUM(products.rating) AS products_rating FROM products_sales INNER JOIN products ON products_sales.products_id = ...
    Tompkins NeilTompkins Neil
    Aug 31, 2010 at 10:42 am
    Aug 31, 2010 at 12:07 pm
  • I have a requirement to keep track of a set of data, and all changes that might occur. In order to do this, for each field of the data set, I've created a table that keeps track of the version, the ...
    Jacob SteinbergerJacob Steinberger
    Aug 26, 2010 at 12:36 am
    Aug 26, 2010 at 2:19 pm
  • Hi Is it possible in MySQL 5.1 to retrieve three columns in a select sub-query like below : SELECT student_age, SELECT (student_subjects_id, random_mark, subject FROM student_subjects ORDER BY ...
    Tompkins NeilTompkins Neil
    Aug 25, 2010 at 12:22 pm
    Aug 25, 2010 at 2:02 pm
  • Hi In MySQL is it possible to SUM a field which contains like 10,23,15,10. The result I'd be looking for is 10 = count of 2 23 = count of 1 15 = count of 1 Cheers Neil
    Tompkins NeilTompkins Neil
    Aug 24, 2010 at 1:53 pm
    Aug 24, 2010 at 2:11 pm
  • Hi all, I was reading a few of the notes on this forum from a few months back and it seems that ONE WAY of upgrading from 4.x to 5.X with MyISAM only databases is to copy the actual data folder from ...
    Nunzio DaveriNunzio Daveri
    Aug 16, 2010 at 2:26 pm
    Aug 16, 2010 at 5:57 pm
  • Hi All, How can i get following information from database or is there any query for the same. (1) mysql server uptime (2) Total number of users connected to server (3) Data file information / where ...
    PRATIKSHA JAISWALPRATIKSHA JAISWAL
    Aug 9, 2010 at 4:01 pm
    Aug 11, 2010 at 4:35 pm
  • Driving to work today, I had an epiphany thought, but wanted to see if anyone could prove my theory or not. We currently have some tables that are approaching 1 BILLION rows (real Billion, with nine ...
    Daevid VincentDaevid Vincent
    Aug 6, 2010 at 12:08 am
    Aug 6, 2010 at 5:56 pm
  • Hello, is there a function, using MySQL 5.0v, that can detect if a numerical value is either an Even or Odd number Thanks, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ...
    Mike BlezienMike Blezien
    Aug 31, 2010 at 6:00 pm
    Aug 31, 2010 at 6:24 pm
  • Hi All, In performance tunning what are the steps can follow,please help me Thanks & Regards, Kranthi kiran
    Kranthi kiranKranthi kiran
    Aug 31, 2010 at 9:13 am
    Aug 31, 2010 at 4:47 pm
  • Hello Gurus, I have a customer who wants to create a reporting server for his management team. He wants to take server 1,2,3 and move the 3 databases from all 3 servers to one server server 4 and ...
    Nunzio DaveriNunzio Daveri
    Aug 23, 2010 at 9:28 pm
    Aug 28, 2010 at 12:28 am
  • Hi all, I'm wondering if it's possible to have a dynamic alias in MySQL. The result I'm looking for is essentially: +-----------------+---------------------------+--------------------+ Where "Appts ...
    Eric BloomquistEric Bloomquist
    Aug 27, 2010 at 4:17 pm
    Aug 27, 2010 at 8:56 pm
  • Hi all, My database size is 1gb.I take backup at 12 am and unfortunately I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8 records are not there, I think that 8 records ...
    KranthiKranthi
    Aug 26, 2010 at 9:32 am
    Aug 26, 2010 at 4:02 pm
  • There are so many versions of 5.1, Is there some review or recommendations for a stable one? thanks
    Elim PDTElim PDT
    Aug 20, 2010 at 2:43 am
    Aug 20, 2010 at 2:19 pm
  • Hello, I am new to the mailing list here, so I'd like to introduce myself quickly. My name is Casey Quibell, and I am also rather new to the concept of programming a database (Or in this case, more ...
    Lord_DeviLord_Devi
    Aug 18, 2010 at 5:43 am
    Aug 19, 2010 at 8:52 pm
  • Hi all, I just installed the no-install version of mysql 5.1.44 on our RHEL 5 box AFTER I yum removed the older 4.X version. The question is how do I tell RHEL to auto start and stop mysql when I ...
    Nunzio DaveriNunzio Daveri
    Aug 12, 2010 at 8:30 pm
    Aug 19, 2010 at 3:38 pm
  • hello, i have an issue with the replication here is my procedure: http://pastie.org/1100368 in the log it shows replication works, but when i update a record this is not updated on the server. any ...
    Norman KhineNorman Khine
    Aug 18, 2010 at 5:29 pm
    Aug 19, 2010 at 6:08 am
  • Hi , I am migrating the database from mssql server to Mysql.i am getting problem with newid(),I don't know about newid(),i am using mysql migration tool kit. if anybody knows please help me. Ex: ...
    KranthiKranthi
    Aug 13, 2010 at 7:31 am
    Aug 13, 2010 at 1:01 pm
  • I'm running a set of queries that look like this: =============== SET @PUBID = (SELECT pub_id FROM pub WHERE pub_code = 'DC'); DROP TEMPORARY TABLE IF EXISTS feed_new; CREATE TEMPORARY TABLE feed_new ...
    Jerry SchwartzJerry Schwartz
    Aug 10, 2010 at 9:39 pm
    Aug 11, 2010 at 1:39 pm
  • I don't know if anyone from mysql is monitoring this list, but I think there is something goofy going on with your email servers. I just now got this email below. Uhm. I wrote that bug over a year ...
    Daevid VincentDaevid Vincent
    Aug 2, 2010 at 7:34 pm
    Aug 7, 2010 at 10:18 pm
  • I recently ran out of table space on a production server that had the following configuration line: ...
    Johnny WithersJohnny Withers
    Aug 2, 2010 at 6:35 pm
    Aug 5, 2010 at 7:25 pm
  • Hi there, I install ubuntu 10.04 (64bit) on my desktop and try to move my existing MySQL data over. I first install MySQL on the new machine, and it can start and stop fine. I decide to change the ...
    Chen jiaChen jia
    Aug 29, 2010 at 7:20 pm
    Aug 30, 2010 at 1:08 am
  • Hi; I have the following query: select * from spreadsheets s join products p on p.Item=s.Item join categories c on p.Category=c.ID where s.Client=%s order by p.category, c.parent; mysql describe ...
    Victor SuberviVictor Subervi
    Aug 24, 2010 at 5:15 pm
    Aug 25, 2010 at 7:30 am
  • Dear All, Table values are getting rollback without calling rollback. I have a table Test with some columns in it. Here's the Table Structure:- Create Table TestID ( TestID int not null, MyID int ); ...
    Manasi SaveManasi Save
    Aug 9, 2010 at 7:10 am
    Aug 10, 2010 at 1:02 pm
  • With the following query if I it returns 2 results it's fast .04s, if it has less results than the limit it takes 1minute. Query: select * from hub_dailies_sp where active='1' and date='2010-08-04' ...
    Kristian DaviesKristian Davies
    Aug 4, 2010 at 9:03 am
    Aug 4, 2010 at 2:08 pm
  • I think you mean, if it is non-zero, then it is odd.
    Michael Coll-barthMichael Coll-barth
    Aug 31, 2010 at 6:10 pm
    Aug 31, 2010 at 6:36 pm
  • Hello everyone. I'm trying to perform a query that acts on 3 tables at once. I'm thinking I need to produce a set of joins between all three tables to get the results that I want, but am not sure how ...
    Michael StrohMichael Stroh
    Aug 30, 2010 at 10:39 pm
    Aug 30, 2010 at 11:42 pm
  • Can somebody tell me why the last command bellow doesn't works? mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'senha' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) mysql ...
    Darvin DenmianDarvin Denmian
    Aug 30, 2010 at 8:10 pm
    Aug 30, 2010 at 9:52 pm
  • Has no one encountered this before? There has got to be a solution, and I still haven't found it... So if you have any input please let me know! -----Original Message----- From: Andreas Iwanowski ...
    Andreas IwanowskiAndreas Iwanowski
    Aug 28, 2010 at 6:05 am
    Aug 30, 2010 at 3:51 pm
  • Hi. For example, entering mysql command line client, mysql pager more ( or pager md5sum and so on.) I want to know how many command the 'pager' follows? Any reply will be big appreciated.
    Moon's FatherMoon's Father
    Aug 25, 2010 at 5:40 am
    Aug 25, 2010 at 8:45 pm
  • Hi List, I have a very big size MyISAM table. For some reason I need to restart the server periodically. But After restarting the server, the table always get corrupt, and always need to run ...
    SangprabvSangprabv
    Aug 25, 2010 at 3:11 am
    Aug 25, 2010 at 9:29 am
  • I hope I've come to right place, and I'm asking in the right way -- please accept my apologies if not. We have some dates missing and I need to populate those fields with dates from the record just ...
    George LarsonGeorge Larson
    Aug 20, 2010 at 12:46 am
    Aug 20, 2010 at 2:44 pm
  • Hi; I have this code: select f.id from Flights f join Planes p where f.plane_id=p.id and p.in_service=1 mysql describe Flights; ...
    Victor SuberviVictor Subervi
    Aug 16, 2010 at 1:58 pm
    Aug 16, 2010 at 6:54 pm
  • Hi all, Please send sample mysql best practice document. Thanks & Regards, Kranthi kiran
    KranthiKranthi
    Aug 16, 2010 at 5:54 am
    Aug 16, 2010 at 1:53 pm
  • According to this document: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html It said MySQL support UTF-8 using one to three bytes per character. But I have created a test table: -- create ...
    Ryan ChanRyan Chan
    Aug 14, 2010 at 2:29 pm
    Aug 16, 2010 at 10:07 am
  • Hi, There is a mysql table ( wordpress) as following, called wp_usermeta, where field meta_key holds zip_code , first_name, last_name inside it ( should have been separate fields to extract data ...
    MadThMadTh
    Aug 12, 2010 at 10:08 pm
    Aug 13, 2010 at 6:37 am
Group Navigation
period‹ prev | Aug 2010 | next ›
Group Overview
groupmysql @
categoriesmysql
discussions93
posts372
users129
websitemysql.com
irc#mysql

129 users for August 2010

Tompkins Neil: 20 posts Nunzio Daveri: 18 posts Johan De Meersman: 11 posts Travis Ard: 11 posts Shawn Green (MySQL): 10 posts Ananda Kumar: 9 posts Jangita: 9 posts Jitendra ranjan: 9 posts Daevid Vincent: 8 posts Jerry Schwartz: 8 posts A Smith: 7 posts Gavin Towey: 7 posts Joerg Bruehe: 7 posts Michael Dykman: 7 posts Norman Khine: 7 posts Rob Wultsch: 6 posts Kranthi: 5 posts Mike Spreitzer: 5 posts Mysql: 5 posts Xn Nooby: 5 posts
show more
Archives