Single Computer (stand-alone) Usage?
I'm hoping to install MySQL on my home desktop computer (where I'm running Ubuntu Linux) and come close to simulating conditions at work (where we use MS Windows XP/Server/SQL Server). I'm also interested in doing this for an online "SQL Intro" course I'm going to be taking in October...
Is it possible to install MySQL and work from my desktop PC as both the server and the client? If so, can somebody point me towards some documentation?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Stand-alone
I want to develop a stand alone (not web based) application that will use MySQL. What is the best programming language or platform to achieve this? Which one is the easiest to install and use?
Stand Alone SQL Tool?
i have been using SQLyog 2.5.1 for my sql administration during development. i went back onto their site to see if there were any updates and realised that they were on 3.5 and you had to register the software! (2.5.1 was freeware).
MySQL Stand Alone For Simpleapplications
i am trying to build a simple app to store about 200 records, not much more than something that you can build in Access. It will be on a single machine and then networked later. I want to keep this as simple as possible as I am the only IT person in the company and travel often. I'm getting ready to install Apache, PHP and MySQL. Does MySQL have any inherent data handling capabilities of it's own?, i.e., forms, simple queries, etc.. or do I need the combination of all 3 apps' to make this work?
Connecting From Other Computer
I'm using mysql-server 4.0.13-3 on Debian. I wish to be able to connect to that server using a mysql frontend from my other computer, which is a Win32 box. However, when I try "telnet 192.168.1.40 3306" on the win32 box, or "telnet localhost 3306" on the host box, I get connection refused.
MySQL On A New Computer
I issue: ps -aux | grep mysqld and I receive root 5908 0.0 0.0 3672 660 pts/0 S 23:33 0:00 grep mysqld I look up the -x and it's: x processes w/o controlling ttys The file mysqld doe not exist and the command "service mysqld start" produces an error because the mysqld script does not exist. How do I get sql going?
Share Folder On XP Computer
I share a folder on an XP Pro computer across our peer to peer network. I have add users to the XP Pro computer for network login. If users on our network edit the MS Access 2000 file no problems occur. But if I edit the MS Access 2000 file on the XP Pro computer itself all users are removed from the security tab on the MS Access file except admin and me.
Connecting From Remote Computer
the database is on host xxx.xxx.xxx.333, Im connecting from xxx.xxx.xxx.222 In the 'user' table in the 'mysql' database on 333 i have a user called 'wordpress'. There are numerouse entries for this user, each has a different host, they are... % xxx.xxx.xxx.222 localhost They all have the same password. I try and connect and get Access denied for user 'wordpress'@'xxx.xxx.xxx.222' (using password: YES) I then try a mysql command on the 333 server to set permissions for user 'wordpress' on database 'wordpress' like this... grant select,insert,update, delete on wordpress.* to wordpress@'xxx.xxx.xxx.222' IDENTIFIED BY 'myPassword'; ...but it says that is doesnt match any rows in the user table. They are both windows machines.
Install On Home Computer
I'm totally new with mysql but I want to start using it. I want to play around and get used to it on my home system before using it on the web. So first things first.... How do I install mysql and create a mysql database on my home system (Windows XP)?
Transfering Database From One Computer To Another
I am working on a personal site and have been usqing an MySQL database I created. I have transfered databases before by simply copying the database file itself (from the data dir) and putting it on a flash drive, then throwing it back in the data file on the other computer. Currently however I am getting this error... I can USE the database, I can even see what tables it holds, but when I try SHOW COLUMNS FROM users; it gives me this... ERROR 1146 (42S02): Table 'tome.users' doesn't exist. I have tried everything, from re-installing MySQL to checking permissions. I had a similier problem a while ago but I cannot recall how I cleared it up.
Moving Database From One Computer To Another
I glad to be part of this community. The problems I am having is that I need to move the information from a database that I have created on my portable computer to a desktop computer. I zipped the files and then unzipped them in my other pc but the infomarmation was not recognized. I then tried a back up restore and still the same. Is there a way that you can transfer the information without having to recreate the database.
How To Grant Privileges To Remote Computer?
I installed Mysql on computer 'A'. I can connect as 'root' from computer 'B' and perform all sql statements. But when i try to create a view from computer 'B', i get the error: "create view command denied to user 'root'@'B' ". When i try to grant the privilege 'create view' from computer 'B', i get the error: "access denied for user 'root'@'%' (using password Yes)" Do i have to grant the privilege on computer 'A'? Is it so for all grants?
Linking/Importing From Another Database On Same Computer
My accounts program is a substantial relatonal database with its own ODBC drivers. I have for many years linked and imported the tables in my accounts progam into MS Access and manipulated my data in Access rather than in the accounts program (because it is much easier). How do I link and import these tables into MySQL? It is not via MyODBC - because that seems to be about linking to MySql tables from MS Access.
Getting Around A Restricted Connection From An External Computer
My host does not allow external connections to my MySQL database on their server from a remote computer. I would like users of my VB application to be able to add records from a table on said database to their local MySQL database. Can anyone advise me of my options to solve this one (appart from changing host)?
Can't Connect To MySQL Sever From Another Computer
Last time I used MySQL was two or 3 years ago. It was amazing. Now, i need it for another project and I have an important (for me) problem: I cannot connect to mysql server from other computer Info: I use Debian GnuLinux 3.1 Kernel 2.6.8.2 and mysql server is running in this computer [mysql-server v4.0.24], and another one (also Debian GnuLinux) has mysql client command line. I insert this options in database in the server (not by using the client mode): Code:
Transfer Database /w Tables To Another Computer
I have created in MySQL to another computer? I tried just moving over the database folder (containing all the tables in that database)from the "data" folder onto the other computer, but this resulted in some errors (for example, the data stored in the tables could not be retrieved). Am I missing a file? Is there a better way?
Easiest Way To Back Up MYSQL Database To Move Over To Another Computer
I've been working through Sitepoint's Build Your Own Database Driven Website and I've decided to change which of my computer's I use as my test server. I installed Apache, PHP and MySql on the new "server" and tried to copy over my database folder, but I can't seem to get it to work in the MySql client. I looked through the documentation for information about maybe making a backup and then restoring it to the new server, but I was a little overwhelmed. Anyone have an easy suggestion to accomplish this. I'm sure it's much easier than I'm making it.
/tmp Usage
are there any best practices for /tmp on a std *nix install for MySQL, and if so, what are they ? Also i can't seem to find any more information on what specifically you'd require a LARGE /tmp for in MySQL.
C# Usage
Does anyone know if C# will work with mysql??? I know it does C++, but I don't know if the connectors or whatever are out there for C#
MAX() Query Usage
I have a database of marks and I need to find out the maximum mark taken by each student in any subject. For example If am a student and I have got 60 in Language, 70 in Maths, 80 in Science and 90 in Social Studies, I would need the result "90" and the relevant Social Science subject to be displayed so that I know am good at Social Science of all the subjects. Likewise, my friend got 65 in commerce, 70 in accountancy, 80 in economics and 90 in Applied Maths. As you may see here, the subjects are all different in both these cases. I only need to know this following result That I am good at Social Studies and my friend is good in Applied Maths. The table name is marks. The fields are subject_id, mark_obtained, student_id. When I try this query. Select subject_id, max(mark_obtained) from marks group by student_id In this case, I get the correct maximum mark, but the subject id displayed is incorrect. Can anyone tell me what am doing wrong here?
Getting CPU Usage Of A Query
There are some various queries running on my site that appear to use a whole lot of CPU resources under certain conditions which I haven't identified. Is there any way I can see which queries are using up how much of the CPU instead of just being able to see the general process id for MySQL? I use cPanel and WHM to manage the server.
Index Usage
I have two tables, one is Student, which has studentid, personid, grade, fees as its columns. The other one is Person, which has personid, firstname, lastname, address as its columns. When given a studentid, I need to get the student' info, such as lastname from the db tables. I can do it with two queries as the following: 1. mysql> select personid FROM Student where studentid=1; 2. mysql> select lastname FROM Person where personid="the id I got above"; Or I can do it with one query: 3. mysql> select p.lastname from Student s, Person p where s.studentid=1 AND s.personid=p.personid Both works. However, I can't tell which one is actually faster, since MySQL shows me "1 row in set (0.00 sec)" for all these three queries. Both studentid and personid are primary keys, so they are automatically indexed. Will both indexes be used in query number 3? I saw people said that MySQL could use in a query only one index...Does it mean only one index will be used in query number 3? I am wondering which one will give better performance.
Max(count(*)) Usage?
I have a table with a structure along the lines of customerId itemId copyId which form a primary key. I want to know the max occurence of a particular item, based on copyId. Ie, if 5 customers want itemId 6, 3 want copyId 1, 2 want copyId 2, should return 3 for itemId 6.. I thought something like select itemId, max(count(*)) from items group by itemId might work, but alack, not the case. Suggestions in how to do this with one query?
Counting Usage Per Day
I want to record how many times an application is used in a day. Is it possible to create a table with a date field that automatically creates a new record each day with the present date as the primary key.
Memory Usage
I've been analysing the memory usage of our server and each SQL thread seems to be taking up 10mb - since our site is basically a search site that means we're using 10mb per user which means with our 2gb RAM we can take around 120-200 simultaneous visitors. Other than buying more RAM, what can I do to increase the number of simultaneous connections (ie - how can I reduce memory usage?) By my Calculations we need to be able to accept around 500 simultaneous searchers to meet our target. We will also be increasing the amount of data we have - currently it is around 1.5 million records but that will be gradually increasing to around 10 million - which I'm sure will also increase the memory load on the server. Right now we have 1.4Gb Data and 380Kb overhead.
CURRENT_DATE Usage
I am trying to access some data from a database based on the date. here is the SQL: SELECT internallocation.LocationName, breed.BreedName, animal.DateBroughtIn from breed, animal, internallocation where (breed.ID = animal.BreedID AND internallocation.ID = animal.ShelterLocation AND animal.DateBroughtIn = 'CURRENT_DATE()') This command returns no results... however, if I put in the date like so: SELECT internallocation.LocationName, breed.BreedName, animal.DateBroughtIn from breed, animal, internallocation where (breed.ID = animal.BreedID AND internallocation.ID = animal.ShelterLocation AND animal.DateBroughtIn = '2005-06-24') I get the results I am looking for. How can I use CURRENT_DATE to create a report based on the date, so the SQL does not have to be edited every time to change the day?
Wildcard Usage
Here is an example of the code: $query = "SELECT * FROM table WHERE field = '*' "; I want to return all the fields from the table where the field is any. The program is a little more complicated than this. Basically using a dropdown menu, the user can search all, or a particular field. If they select "search all", I need the ability to insert that into the query statement.
Memory Usage
We have Mysql 5.0 running on RH linux. We have noticed that the swap memory increases but never gets released unless we reboot the server every 2-3 weeks. How would I know whats using this swap memory? Second question which I think maybe related to the first is that mysql is using a lot of memory when I do a top. Is there a way to limit the memory usage of mysql? I have a large table in mysql about 7 GB and I have 8 GB physical memory and swam is set to use 2GB.
MySQL 4.0.xx Admin And Usage
I've recently taken over my non-profit's Web site design, administration and maintenance with relatively little MySQL experience (although I have learned a great deal very quickly). My question is, does anyone know where I can get a manual or something like the current manual "Building your Own Website Using PHP and MySQL .."(ordered from sitepoint.com site). This manual is basing the MySQL on the most current version of 5. I'm looking for something similar that addresses the 4.0.xx(27 specifically) of MySQL
LEFT JOIN Usage HELP!
Schema: Table1 -t1field1 --> primary key -t1field2 -t1field3 Table2 -t2id -t1field1 --> foreign key of t1field1 -t2field2 -t2field3 -t2field4 Database Values: Table1 row1: 1,aaa,123 row2: 2,bbb,123 row3: 3,ccc,123 row4: 4,ddd,123 row5: 5,eee,123 Table2 row1: 1,1,aaa,123 row2: 2,1,jjj,123 row3: 3,1,aaa,123 row4: 4,2,hhh,123 row5: 5,3,hhh,123 row6: 6,2,aaa,123 row7: 7,1,jjj,123 Query: SELECT t1.t1field1, t1.t1field2, t1.t1field3, t2.t2field2, t2.t2field3, t2.t2field4 FROM Table1 AS t1 LEFT JOIN Table2 AS t2 USING(t1field1) WHERE t1.t1field2 = 'aaa' Question: Where do I insert a "WHERE clause" if i wanted to get t2.field2 with a value of 'jjj' only? or my query is totally wrong.
High CPU Usage (99.9%) On RHEL4
i need your help on this issue. I am running a web server in my orginazation internally with mysql-4.1.12 and RHEL4. Now, its been only one day and using 'top' command its showing mysqld process using cpu 99.9% constantly. This is used by say around 4000 users. My my.cnf file : [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid output of mysqladmin version .......... ... Threads: 53 Questions: 324297 Slow queries: 588 Opens: 39976 Flush tables: 1 Open tables: 64 Queries per second avg: 67.788 output of mysqladmin extended-status Variable_name | Value | +--------------------------------+------------+ | Aborted_clients | 742 | | Aborted_connects | 35 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Bytes_received | 29401860 | | Bytes_sent | 1049908921 | | Com_admin_commands | 2352 | | Com_alter_db | 0 | | Com_alter_table | 0 | | Com_analyze | 1 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 40895 | | Com_change_master ...................................................................
Analyze Index Usage
I am running a SELECT query that is taking approx. 200+ seconds to complete. I believe I have the tables indexed properly, but apprarently not. How can I determine what indexes a query is using and evaluate the execution plan (as you would in MSSQL)?
CPU Usage Issues On A Windows Box?
As the site receives over 50 simultaneous hits, mysql uses up just about all cpu usage... I have fine tuned everything - can any one offer any suggestions or share similar experiences??
Can I Limit Ram Usage In MySQL?
I just had my server shut down because my hosting company said I was using 350 to 450 megs of ram. This seems nuts to me as I'm only running a shopping cart with about 1000 items with only about 50 visitors per day. Since they installed mysql on the server, I asked them why they hadn't configured it to work with the parameters of their system. Their response: "Unfortunately, there is no way to limit the RAM usage for mySQL. I apologize for the inconvenience this may cause however there is no way to do this." Do they know what they are talking about???
Orders Table - 100% CPU Usage
I'm starting to dive into something that looks like a PHP/MySQL issue that is bogging me down (PHP5, MySQL 4.1, Apache 2 on a Windows XP ws). (At the end of this message, the PHP code) We operate a virtual store and there's this administrative tool, loaded by the code included, which lists orders by category (new, shipped, cancelled etc.); on the top of the page, it first shows each category's totals (3 new, 18 shipped etc.). Obviously, these data comes from an "orders" table which, as of today, has 8.103 records. I did increase already cache and buffer sizes on PHP and that helped tremendously to load the tool *if data doesn't change* in between. When it does, the following happens: 1. CPU usage goes all the way up to 100%, and 2. it takes approx. 45-60 seconds like that until the page ends loading. I'm no PHP programmer, but it seems to me this has to be related to the code below. Code:
Lowering Memory Usage?
I was wondering if there's any way I can lower MySQL's = memory useage? It often uses more than 50000kb which I consider to much.. I'm guessing I should play with my.cnf or whatever it's called (located at = C:/ and windows calls it cardnumber or something)...
Mysql Usage Is Very High
My mysql usage goes up to 40% of CPU. I think one of my mysql database is causing the issue. I store images in that tables. The select query takes nearly 0.4S to 1.5Sec to fetch a single row. mysql> desc images; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | bigint(20) | | PRI | NULL | auto_increment | | slideid | int(11) | YES | | NULL | | | filename | varchar(50) | YES | | NULL | | | fileinfo | varchar(60) | YES | | NULL | | | position | int(11) | YES | | NULL | | | image | mediumblob | YES | | NULL | | +----------+-------------+------+-----+---------+----------------+ mysql> select count(*) from images; +----------+ | count(*) | +----------+ | 5022 | +----------+ e.g query results: 1 row in set (0.31 sec) 1 row in set (1.44 sec)
Mysqld Running 100 Pct Cpu Usage
I am testing mysql 4.1 on a Windows Server 2003 with a website running on Internet Information Services. I installed mysqld as a service. As times goes by, mysqld begins to reach 100 pct cpu usage and doesn't goes below that, Windows usage is slow, folders opens slow, navigating locally turns to be slow, and sometimes it makes the server to freeze or restart. When this begins to happen, I executed the command "Show processlist" and I got the following result. If somebody can point me where is my mistake or where is the problem or any solutions for this, I'm still in a learning process for mysql. Code:
Key_index_size Setting And Usage
I am using MySQL 4.1.12, compiled from source, on a Linux 2.6.11.10 kernel form the kernel archive. My Hardware is a Dual Xeon 2.8Ghz with 8GB of RAM and U320 SCSI disks. The database I am serving is about 6GB total, with the bulk of the data in 2 big tables, about 1.5 GB each. The index files for these two tables are 1.4 GB and 415MB. In my /etc/my.cnf file I have the key_index_size set to 3GB, but the most that will get used is 1.49GB, either after doing an "Optimize tables" or an "INSERT INDEX INTO CACHE" statement. My question is: How does MySQL decide how much of the systems memory to use for the key_index_size and any other of the processes allocatable address space. Also, under linux is the allocatable address space to an individual process 3GB or 4GB?
Allowable MySQL CPU Usage
I am running this query (with subqueries) in MySQL under Windows: SELECT sum(quantity)/(SELECT sum(quantity) from orders), partID from orders group by partID I noticed that it runs very slowly. It appears that MySQL is only using about 2% of CPU capacity, for some reason. The query takes almost 20 minutes to run on my table (whereas the same query takes only 1 minute in MS Access!). Is there a way to allow MySQL to use more of the CPU, so these queries can run more quickly?
Usage Of OPTIMIZE Command
I had a table of more than 800'000 rows where I deleted approx 200'000 rows. The documentation says that I shouldn't normally have to use the OPTIMIZE TABLE command, but performance on this table has not improved. Is it a good idea to use it?
Proper MySQL Usage
I'm looking to use MySQL on my next project, but I don't really know how to set it up so it fits my needs. I am making a Music Script Basically. All I need to store is Artist Name, Artist Videos, and Artist Songs. (just names of the stuff) Artist Videos & Artist Songs are unknown, size wise. Different artists are going to have different numbers of songs and videos.
|
TRACKER
