RE: Should we petition GoDaddy?

> I am slowly considering leaving GoDaddy, who has a very good bandwidth and > ok tech support (I have seen better but much much worse) and acceptable > prices, but unfortunately does not support MySQL 5 and PHP 5 either. SNIP > Who think we could make them make the right move and pretty quickly?

Should we petition GoDaddy?

I am slowly considering leaving GoDaddy, who has a very good bandwidth and ok tech support (I have seen better but much much worse) and acceptable prices, but unfortunately does not support MySQL 5 and PHP 5 either. I wonder if I could give these people a chance but one thing I'd like to do is see

Re: MySQL cache problem - innodb_buffer_pool_size and FS cache

In the last episode (Apr 15), Charles Q. Shen said: > From: Dan Nelson [mailto:[EMAIL PROTECTED] > > In the last episode (Apr 15), Charles Q. Shen said: > > > This question is about tuning the innodb_buffer_pool_size in an > > > experiment related to my earlier post. I am running MySQL 4.1.11 > >

RE: MySQL cache problem - innodb_buffer_pool_size and FS cache

Hi Dan, Thanks! Please see comments inline. > -Original Message- > From: Dan Nelson [mailto:[EMAIL PROTECTED] > Sent: Saturday, April 15, 2006 2:51 PM > To: Charles Q. Shen > Cc: 'Philippe Poelvoorde'; 'MySQL General' > Subject: Re: MySQL cache problem - innodb_buffer_pool_size > and FS

Re: copying table fo other database

[EMAIL PROTECTED] wrote: > Hi to all! > > I have to transfer copy of the one table from one to other database. > I was working with phpMyAdmin. I exported table in sql file but, when > tried to Import it to other database I got > Fatal error: Allowed memory size of 8388608 bytes exhausted (tried t

Prepared Statement, Select and Calls in C/C++ UDF

Hi, I want to make "C" User Defined Function where to do some data processing using the parameters and the data in the database and to return some BIGINT result after that. My questions are: Q1. Is it possible to use Prepared Statement, Select and Calls in C/C++ UDF? Q2. If, Yes, which MySQ

Re: MySQL cache problem - innodb_buffer_pool_size and FS cache

In the last episode (Apr 15), Charles Q. Shen said: > This question is about tuning the innodb_buffer_pool_size in an > experiment related to my earlier post. I am running MySQL 4.1.11 with > innoDB on RedHatEnterprise Linux, kernel 2.6.9-22. The table contains > 50M records, with a total data_leng

Re: Show Grants problem

--- Todd Smith <[EMAIL PROTECTED]> wrote: > Hello > Does anyone know why a user would show up in a select from user > query but > not in a show grants command. What I am trying to say is I tried > SHOW > GRANTS FOR 'user1'@'%' and received that there is no such grant > defined for > 'user

RE: MySQL cache problem - innodb_buffer_pool_size and FS cache

Hi, This question is about tuning the innodb_buffer_pool_size in an experiment related to my earlier post. I am running MySQL 4.1.11 with innoDB on RedHatEnterprise Linux, kernel 2.6.9-22. The table contains 50M records, with a total data_length of 9GB and index_length of 9.5GB. I measured repeat

localhost, wildcards and external connections

Hi, Just upgraded my mysql installation from 4.0.18 to 4.1.14, and i'm seeing some odd things with mysql authentication. We use some scripts to change/add mysql users. In this script there's an option to allow 'external' connections, this is implemented by using Host="%" in the user and db table.

copying table fo other database

Hi to all! I have to transfer copy of the one table from one to other database. I was working with phpMyAdmin. I exported table in sql file but, when tried to Import it to other database I got Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 806882 bytes) Any idea how

RE: ~ How to install 3 instances of mysql~

Hi, Also a read of http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would probably be quite helpful. The second gives you a good idea on how to setup the my.cnf file for multiple servers. The concepts are the same for version

Re: ~ How to install 3 instances of mysql~

On Sat, 15 Apr 2006, Mohammed Abdul Azeem wrote: > To: [EMAIL PROTECTED] > From: Mohammed Abdul Azeem <[EMAIL PROTECTED]> > Subject: Re: ~ How to install 3 instances of mysql~ > > Hello Keith, > > Thank you very much for your guidence. > > This is my existing my.cnf file > > > [mysqld] > por

Re: mysqldump

Anago Chima wrote: Please, I want to know if there is a way I can back up all the databases in my MySQL server to a text file just with a single mysqldump query. I run MySQL Server Version 4.1.14 on Windows XP pro __ Do You Yahoo!? Tired of spam?

mysqldump

Please, I want to know if there is a way I can back up all the databases in my MySQL server to a text file just with a single mysqldump query. I run MySQL Server Version 4.1.14 on Windows XP pro __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the b

Re: How to remove muiltiple queries to a table at the same time

1. A single query that fetvhes a value, increases it and save it : UPDATE `table_name` SET `field`=`field`+1; 2. You can lock tables, make updates an then unlock them, the other processes will wait the table to be unlocked before running their queries : LOCK TABLES `table_name` WRITE; {SQL st

How to remove muiltiple queries to a table at the same time

Dear Friends, I run several processes and they need to query the mysql 5.0.8 database simultaneously .I have a config table which have the record id. I need to fetch that and increment that .What I feel that the same record id is fetched by different simultaneosly before i update .Can anyone help m

How to host multiple data nodes on a single computer having two processors

In mysql-5.1-reference manual: Each data node is usually located on a separate computer. However, it is also possible to host multiple data nodes on a single computer having more than one processor. In such cases, it is feasible to run one instance of ndbd per physical CPU. (Note that a processor w

Re: MySQL 3 to 5 upgrade

At 19:14 +0100 14/4/06, Philippe Poelvoorde wrote: Have a serious look at : http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html I will definitely do this. Me

Re: ~ How to install 3 instances of mysql~

Hello Keith, Thank you very much for your guidence. This is my existing my.cnf file [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M t

Right column type for OLE objects

Dear friends, I need to store OLE objects such as Word, Excel & OpenOffice, Autocad documents in the database. Which will be the correct column type for it? Thanks and regards, CPK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c

Re: ~ How to install 3 instances of mysql~

Create 3 my.cnf files with different ports and sockets: [mysqld] port = 3306 socket=/var/lib/mysql/mysql1.sock . Launch server with: bin/safe_mysqld --defaults-file=/usr/local/mysql/bin/my1.cnf client: /usr/local/mysql/bin/mysql -S /var/lib/mysql/mysql1.sock stop: mysqladmin -S /var/li

Re: ~ How to install 3 instances of mysql~

Hi Mohammed - yes it is possible to install multiple instances of mysqld on one machine. Under SuSE Linux 9.2 I have had 3 instances of mysqld running. I would suggest the following. Use the generic static pre-compiled distibution. Linux (non RPM package) downloads (platform notes) Linux (x8