Search Results

Search found 33911 results on 1357 pages for 'mysql select'.

Page 248/1357 | < Previous Page | 244 245 246 247 248 249 250 251 252 253 254 255  | Next Page >

• MysqlTunner and query_cache_size dilemma

  - by wbad

  On a busy mysql server MySQLTuner 1.2.0 always recommends to add query_cache_size no matter how I increase the value (I tried up to 512MB). On the other hand it warns that : Increasing the query_cache size over 128M may reduce performance Here are the last results: >> MySQLTuner 1.2.0 - Major Hayden <[email protected]> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.25-1~dotdeb.0-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in InnoDB tables: 6G (Tables: 195) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 51 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 19h 17m 8s (254M q [1K qps], 5M conn, TX: 139B, RX: 32B) [--] Reads / Writes: 89% / 11% [--] Total buffers: 24.2G global + 92.2M per thread (1200 max threads) [!!] Maximum possible memory usage: 132.2G (139% of installed RAM) [OK] Slow queries: 0% (2K/254M) [OK] Highest usage of available connections: 32% (391/1200) [OK] Key buffer size / total MyISAM indexes: 128.0M/92.0K [OK] Key buffer hit rate: 100.0% (8B cached / 0 reads) [OK] Query cache efficiency: 79.9% (181M cached / 226M selects) [!!] Query cache prunes per day: 1033203 [OK] Sorts requiring temporary tables: 0% (341 temp sorts / 4M sorts) [OK] Temporary tables created on disk: 14% (760K on disk / 5M total) [OK] Thread cache hit rate: 99% (676 created / 5M connections) [OK] Table cache hit rate: 22% (1K open / 8K opened) [OK] Open file limit used: 0% (49/13K) [OK] Table locks acquired immediately: 99% (64M immediate / 64M locks) [OK] InnoDB data size / buffer pool: 6.1G/19.5G -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Reduce your overall MySQL memory footprint for system stability Increasing the query_cache size over 128M may reduce performance Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_size (> 192M) [see warning above] The server has 76GB ram and dual E5-2650. The load is usually below 2. I appreciate your hints to interpret the recommendation and optimize the database configs.

  Read the article

• How to get records in another database on the same host in MySQL?

  - by user198729

  I tried dbname.tablename, but it's not working. What's the right way to do this in MySQL?

  Read the article

• How can I tell when a MySQL table was last updated?

  - by RaGE

  In the footer of my page, I would like to add something like "last updated the xx/xx/200x"; with this date being the last time a certain mySQL table has been updated. What is the best way to do that ? Is there a function to retrieve the date ? Should I make an access to the database everytime my footer is displayed ?

  Read the article

• How to use mySql DB from C# on shared hosting?

  - by Amit

  Hi, i bought a web domain with some web space. They support only mySQL DB, how do i access the my SQL DB on my asp.net application? is there is way to access it through .net base classes without installing third party drivers?

  Read the article

• mysqldump is not dumping my data

  - by oompahloompah

  I am running mysqldump on Ubuntu Linux (10.0.4 LTS) my mySQL version info is: mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1 I used the following command: mysql -u username -p dbname dbname_backup.sql However when I opened the generated .sql file, I saw that most of the tables had only the schema dumped and in the few cases where the actual data was dumped, only 1 or two records were dumped (there are ATLEAST several tens of records in each table). Does anyone know what maybe going on?

  Read the article

• Can I put an mysql index on a date field with when I use >= or <=?

  - by Ryan Detzel

  I have indexes for my table user,date, and date,user but when I issue queries like SELECT * FROM table WHERE date >= '2010-5-1' and user='test'; It doesn't use the date,user index it uses the user index. Is there any way to get mysql to use the date,user index for these queries?

  Read the article

• What should a PHP/MySQL web developer know about servers?

  - by Mike

  I develop websites using PHP and MySQL. What resources would a seasoned web developer recommend that would cover server-specific information relevant to the job of a developer. If it helps, I work specifically with an Apache server (through my hosting company).

  Read the article

• Why does this simple MySQL procedure take way too long to complete?

  - by Howard Guo

  This is a very simple MySQL stored procedure. Cursor "commission" has only 3000 records, but the procedure call takes more than 30 seconds to run. Why is that? DELIMITER // DROP PROCEDURE IF EXISTS apply_credit// CREATE PROCEDURE apply_credit() BEGIN DECLARE done tinyint DEFAULT 0; DECLARE _pk_id INT; DECLARE _eid, _source VARCHAR(255); DECLARE _lh_revenue, _acc_revenue, _project_carrier_expense, _carrier_lh, _carrier_acc, _gross_margin, _fsc_revenue, _revenue, _load_count DECIMAL; DECLARE commission CURSOR FOR SELECT pk_id, eid, source, lh_revenue, acc_revenue, project_carrier_expense, carrier_lh, carrier_acc, gross_margin, fsc_revenue, revenue, load_count FROM ct_sales_commission; DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; DELETE FROM debug; OPEN commission; REPEAT FETCH commission INTO _pk_id, _eid, _source, _lh_revenue, _acc_revenue, _project_carrier_expense, _carrier_lh, _carrier_acc, _gross_margin, _fsc_revenue, _revenue, _load_count; INSERT INTO debug VALUES(concat('row ', _pk_id)); UNTIL done = 1 END REPEAT; CLOSE commission; END// DELIMITER ; CALL apply_credit(); SELECT * FROM debug;

  Read the article

• Quickest way to dump Python dictionary (dict) object to a MySQL table?

  - by NJTechGuy

  I have a dict object. I dumped the data using this: for alldata in data: # print all data to screen print data[alldata] Each field had brackets [] and 'None' values for NULLS and date.datetime for date values. How do I dump this dict to MySQL table? Thank you!

  Read the article

• How to keep backup of our database in MySql.

  - by Sanjeev

  I want to keep backup of my database and import it into different System? and how to make .dmp or store file in MySql?

  Read the article

• In MySQL, if the movies table has a description field, how to do search on this description?

  - by Jian Lin

  Say, using MySQL, if the movies table has 20,000 records, and each record has a field that is the description of the movie, up to 2k byte long. How can we search for movies with the word "nature" in its description? If possible, it is to be fast, instead of going through all the 20,000 records. (if in some other situations, like for books, where n can be 200,000 or more).

  Read the article

• Ruby, MySQL: Connection pool that is outside of the rails framework?

  - by Zombies

  Is there a ruby gem or such for MySQL connection pooling that isn't part of rails? I simply have a ruby script (again, I don't do anything with rails).

  Read the article

• how to connect asp.net Crystal report with mysql.

  - by Ayyappan.Anbalagan

  how to connect asp.net Crystal report with mysql database. like sql server database connection .is there any connector available to do this..

  Read the article

• restrict the scope of variables in a mysql query? with brackets?

  - by Haroldo

  I can't remember what the method is meant to be for ensuring the scope of a variable in a query is restricted to prevent mysql injection. where should i put brackets in the following examples? UPDATE table SET col_1 = '$var', col_2 = '$var2' WHERE col_1 = '$var3' and SELECT * FROM table WHERE WHERE col_1 >= '$var1' (Obviously looking for answers not using PDO!)

  Read the article

• Is it possible to merge two MySQL databases into one?

  - by Mike L.

  Lets say I have two MySQL databases with some complex table structures. Neither database has the same table name. Lets say these tables contain no rows (they do but I could truncate the tables, the data is not important right now, just testing stuff). Lets say I need these 2 databases merged into one. For instance: DB1: cities states DB2: index subindex posts I want to end up with a single DB that contains: cities states index subindex posts Is this possible?

  Read the article

• Can MySQL do row level security or what Oracle calls virtual private databases?

  - by JavaRocky

  Does MySQL have any equivalent feature to Oracle's virtual private databases in 10g. It is also known as row level security. I prefer not to implement anything like columns and triggers. I am looking for a solution similar to Oracle's.

  Read the article

• How to upload 10 Go of data to MySQL programmatically without crashing like on PHPMyAdmin?

  - by asksuperuser

  I'm very surprised that it seems impossible to upload more than a few megabytes of data to mysql database through PHPMyAdmin whereas I can upload a msaccess table easily up to 2 Gigabytes. So is there any script in php or anything that can allow to do so unlike phpmyadmin ?

  Read the article

• How to make phpMyAdmin ask for my username and password

  - by anitha

  I am using rhel 5 and php 5 with mysql 5. My server is already configured and running all applications smoothly. I am accessing mysql as root and supplying my password. However, when I access phpmyadmin through browser, it is not asking for my password. Somebody please tell me how can I set it to prompt for username and password. Since I am not familiar with php and mysql please tell me how to do it in simple way.

  Read the article

• SELECT product from subclass: How many queries do I need?

  - by Stefano

  I am building a database similar to the one described here where I have products of different type, each type with its own attributes. I report a short version for convenience product_type ============ product_type_id INT product_type_name VARCHAR product ======= product_id INT product_name VARCHAR product_type_id INT -> Foreign key to product_type.product_type_id ... (common attributes to all product) magazine ======== magazine_id INT title VARCHAR product_id INT -> Foreign key to product.product_id ... (magazine-specific attributes) web_site ======== web_site_id INT name VARCHAR product_id INT -> Foreign key to product.product_id ... (web-site specific attributes) This way I do not need to make a huge table with a column for each attribute of different product types (most of which will then be NULL) How do I SELECT a product by product.product_id and see all its attributes? Do I have to make a query first to know what type of product I am dealing with and then, through some logic, make another query to JOIN the right tables? Or is there a way to join everything together? (if, when I retrieve the information about a product_id there are a lot of NULL, it would be fine at this point). Thank you

  Read the article

• Delete record in MySQL with php targeting auto_incremented int?

  - by Chris_45

  Why doesnt this delete work to delete the whole record: $query = 'DELETE FROM tblEvents WHERE index = $_GET["id"]'; $result = mysql_query($query, $db) or die(mysql_error($db)); Where index is variable of type int, auto_incremented in MySQL?

  Read the article

• How can I employ "if exists" for creating or dropping an index in MySQL?

  - by Paul

  I was wondering if there's a way to check if an index exists before creating it or destroying it on MySQL. It appears that there was a feature request for this a few years back, but I can't find any documentation for a solution. This needs to be done in a PHP app using MDB2.

  Read the article

• How can I connect to a mysql db from a different server ?

  - by HJ-INCPP

  Hello, I have, let's say, a root website with mysql db on a remote server. I want to connect to that particular database (to make queries), from many other little websites (with lower priviledges). Can this be done? Language: jsp,java,php Thank you

  Read the article

• Sorting mysql array value after string chars swapped from fetched DB data.

  - by Shail Patel

  I want to sort one column fetched from mysql DB, and stored in an array. After fetching I am doing below steps. 1- DB Fetching fields array in row format. ->Field1, Field2, Field3, Field4, Field5 2- From that fields array One columns data [Field3], swapping string keywords. eg. AB013, DB131, RS001 to->013AB, 131DB, 001RS Now I want to sort above value in new string format like-> 001RS, 013AB, 131DB

  Read the article

• How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?

  - by Misier

  I somehow need this feature,but MySQL doesn't support it at this moment. I'm using GROUP_CONCAT(CONCAT(...)) to generate a xml-like stuff. But when the size exceeds the limit,the xml is just broken! So I have to somehow make it only retrieve 5 rows !

  Read the article

• how do I display list of URLS say maximum 50 per web page from MySQL database??

  - by mathew

  I do have thousands of urls in my database. what I want to do is display all urls in multiple pages say number of URLS per page is 100 and alphabetically then when ever a user search for a URL info it should get updated on relevant page. for example if it is google.com then it should get updated on "G" page and no duplicate entry. how can I do this with PHP and MySQL??

  Read the article

< Previous Page | 244 245 246 247 248 249 250 251 252 253 254 255  | Next Page >